ASP - First Time Onload

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Checking check box does not chage query result Hi, I have a form when loaded, retrieves record from an access table. Among other fields there is a check box called FinalUpdate. This is tied to a field in Access of type Yes/No. The form retieves the values perfectly. This form is being used to update the record in the table via a successconfirmation.asp. Now, when the checkbox is loaded as checked, then unchecking the checkbox reflects the change in query result in successconfirmation.asp. However, if the form is loaded as unchecked, and then the checkbox is checked, the final query does not change the result. The value of FinalUpdate is still False though it should be True. Any help is appreciated. MAIN CODE FOR THE successconfirmation.asp 'Store the values to the local variables l_ss = Request.Form("txtSocialSecurity") l_firstname = Request.Form("txtFirstName") l_lastname = Request.Form("txtLastName") l_password = Request.Form("txtPassword") l_colorpreference = Request.Form("txtColorPref") l_foodpreference = Request.Form("txtFoodPref") l_finalupdate = CBool(Request.Form("chkFinalUpdate")) Response.Write l_finalupdate 'Create the dynamic sql script for database update corresponding to 'the current record. strsql = "UPDATE main SET main.FirstName ='" & l_firstname & "', " & _ "main.LastName = '" & l_lastname & "', " & _ "main.ColorPreference = '" & l_colorpreference & "', " & _ "main.FoodPreference = '" & l_foodpreference & "', " & _ "main.FinalUpdate = " & (l_finalupdate) & " where " & _ "main.SocialSecurityNumber ='" & l_ss & "'" Response.Write strsql MAIN CODE FOR THE LOADING OF INITIAL FORM: Dim l_SocialSecurityNumber Dim l_Password Dim l_FirstName Dim l_LastName Dim l_ColorPreference Dim l_FoodPreference Dim l_FinalUpdate 'Get all the fields from the database in the above variable l_SocialSecurityNumber = RS.Fields("SocialSecurityNumber") l_Password = RS.Fields("Password") l_FirstName = RS.Fields("FirstName") l_LastName = RS.Fields("LastName") l_ColorPreference = RS.Fields("ColorPreference") l_FoodPreference = RS.Fields("FoodPreference") l_FinalUpdate = CBool(Rs.Fields("FinalUpdate")) %> <div ALIGN="CENTER"> <big> <big><font COLOR="navy">Locking Test</big></big> </div> <br><br> <form ACTION="successconfirmation.asp" method="POST" NAME="frmLockTest"> <table> <tr> <td HEIGHT="50" COLSPAN="2"><b><font COLOR="green">Edit Screen</font><b></td> </tr> <tr> <td>Social Security Number</td> <td><input TYPE="text" NAME="txtSocialSecurity" SIZE="15" value = "<%Response.Write l_SocialSecurityNumber%>"></td> <td>First Name</td> <td><input TYPE="text" NAME="txtFirstName" SIZE="15" value = "<%Response.Write l_FirstName%>"></td> <td>Last Name</td> <td><input TYPE="text" NAME="txtLastName" SIZE="15" value = "<%Response.Write l_LastName%>"></td> </tr> <tr> <td>Password</td> <td><input type="password" NAME = "txtPassword" size="15" value = "<%Response.Write l_Password%>"></td> <td>Color Preference</td> <td><input TYPE="text" NAME="txtColorPref" SIZE="15" value = "<%Response.Write l_ColorPreference%>"></td> <td>Food Preference</td> <td><input TYPE="text" NAME="txtFoodPref" SIZE="15"value = "<%Response.Write l_FoodPreference%>"></td> </tr> <tr> <td>FinalUpdate</td> <td><input TYPE="checkbox" NAME="chkFinalUpdate" VALUE= "<%=CBool(l_FinalUpdate)%>"<%If CBool(l_FinalUpdate) Then Response.Write " checked" Else Response.Write " unchecked"%>></td> </tr> Tag: ASP - First Time Onload Tag: 304766
  - 2
    - replace text I have a little test that replaces the same character with two different values. Currently I have to process it twice. Is it possible to do it all at once? dim a, z a = "a,b,c" z = replace(a,",","x",1,1) Response.write(replace(z,",","y")) I'm thinking regular expressions are the way to go but in use it will have to replace a single character with an XML tag. TIA... -- Roland Hall /* This information is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. */ Technet Script Center - http://www.microsoft.com/technet/scriptcenter/ WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp Tag: ASP - First Time Onload Tag: 304763
  - 3
    - Unable to create temp file: Error Hi there, im brand new to ASP. Ive done loads of VB coding and one of my clients is intrested in a web based application, so im trying to play on and learn it a tad. However im comming across lots of problems. Up until now ive managed to sort most of them, but now im strugling. When i run my application i keep getting this. Server Error in '/WebApplication1' Application. -------------------------------------------------------------------------------- Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30138: Unable to create temp file in path 'C:\DOCUME~1\XP-MAC~1\ASPNET\LOCALS~1\Temp\': Access is denied. Source Error: [No relevant source lines] Source File: vbc : Line: 0 Show Detailed Compiler Output: C:\WINDOWS\system32> "c:\windows\microsoft.net\framework\v1.1.4322\vbc.exe" /t:library /utf8output /R:"c:\windows\assembly\gac\system.enterpriseservices\1.0.5000.0__b03f5f7f11d50a3a\system.enterpriseservices.dll" /R:"c:\windows\assembly\gac\system.xml\1.0.5000.0__b77a5c561934e089\system.xml.dll" /R:"c:\windows\assembly\gac\system.web.services\1.0.5000.0__b03f5f7f11d50a3a\system.web.services.dll" /R:"c:\windows\assembly\gac\system\1.0.5000.0__b77a5c561934e089\system.dll" /R:"c:\windows\assembly\gac\system.web\1.0.5000.0__b03f5f7f11d50a3a\system.web.dll" /R:"c:\windows\assembly\gac\system.drawing\1.0.5000.0__b03f5f7f11d50a3a\system.drawing.dll" /R:"c:\windows\assembly\gac\system.data\1.0.5000.0__b77a5c561934e089\system.data.dll" /R:"c:\windows\assembly\gac\system.web.mobile\1.0.5000.0__b03f5f7f11d50a3a\system.web.mobile.dll" /R:"c:\windows\microsoft.net\framework\v1.1.4322\temporary asp.net files\webapplication1\3860b6e6\760156ee\assembly\dl2\2fa85b6b\50f17af8_e2e2c401\webapplication1.dll" /out:"C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\webapplication1\3860b6e6\760156ee\xs005t5z.dll" /D:DEBUG=1 /debug+ "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\webapplication1\3860b6e6\760156ee\xs005t5z.0.vb" Microsoft (R) Visual Basic .NET Compiler version 7.10.3052.4 for Microsoft (R) .NET Framework version 1.1.4322.573 Copyright (C) Microsoft Corporation 1987-2002. All rights reserved. vbc : error BC30138: Unable to create temp file in path 'C:\DOCUME~1\XP-MAC~1\ASPNET\LOCALS~1\Temp\': Access is denied. Show Complete Compilation Source: Line 1: '------------------------------------------------------------------------------ Line 2: ' <autogenerated> Line 3: ' This code was generated by a tool. Line 4: ' Runtime Version: 1.1.4322.573 Line 5: ' Line 6: ' Changes to this file may cause incorrect behavior and will be lost if Line 7: ' the code is regenerated. Line 8: ' </autogenerated> Line 9: '------------------------------------------------------------------------------ Line 10: Line 11: Option Strict Off Line 12: Option Explicit On Line 13: Line 14: Imports Microsoft.VisualBasic Line 15: Imports System Line 16: Imports System.Collections Line 17: Imports System.Collections.Specialized Line 18: Imports System.Configuration Line 19: Imports System.Text Line 20: Imports System.Text.RegularExpressions Line 21: Imports System.Web Line 22: Imports System.Web.Caching Line 23: Imports System.Web.Security Line 24: Imports System.Web.SessionState Line 25: Imports System.Web.UI Line 26: Imports System.Web.UI.HtmlControls Line 27: Imports System.Web.UI.WebControls Line 28: Line 29: Namespace ASP Line 30: Line 31: <System.Runtime.CompilerServices.CompilerGlobalScopeAttribute()> _ Line 32: Public Class Global_asax Line 33: Inherits WebApplication1.Global Line 34: Line 35: Private Shared __initialized As Boolean = false Line 36: Line 37: Public Sub New() Line 38: MyBase.New Line 39: If (ASP.Global_asax.__initialized = false) Then Line 40: ASP.Global_asax.__initialized = true Line 41: End If Line 42: End Sub Line 43: End Class Line 44: End Namespace Line 45: -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 Has anyone else had this?? Or know what im doing wrong. Hope someone can help me out. Regards James Tag: ASP - First Time Onload Tag: 304757
  - 4
    - Getting Started I've passed my VB 6 exams. Now I've installed .NET 2003 and I'm trying to get started in ASP .NET My problem is I know exactly what I want to do and how to write vb ado code, but I don't know where to put it. I need a kick start to get going. Can anyone recommend an ASP .NET for VS6 users type of book or online course? Thanks in advance, Joe in Florida Tag: ASP - First Time Onload Tag: 304752
  - 5
    - Problem in building dynamic sql update statement Hi, I am trying to update database from asp. However, the finalupdate field is not working here. The finalupdate field is a Access Database field of type yes/no. Any help/advise is appreciated. Regards THE DYNAMIC SQL STATEMENT: strsql = "UPDATE main SET main.FirstName ='" &l_firstname& "', " & _ "main.LastName = '" &l_lastname& "', " & _ "main.ColorPreference = '" &l_colorpreference& "', " & _ "main.FoodPreference = '" &l_foodpreference& "', " & _ "main.FinalUpdate = &l_finalupdate& where " & _ "main.SocialSecurityNumber)='" &l_ss& "' THE TRANSLATED SQL STATEMENT: UPDATE main SET main.FirstName ='Cocoa', main.LastName = 'Jones', main.ColorPreference = 'Choco', main.FoodPreference = 'Lamb', main.FinalUpdate = &l_finalupdate& where main.SocialSecurityNumber)='222-22-2222' Tag: ASP - First Time Onload Tag: 304748
  - 6
    - New Window Kills Browser When Connected to Oracle I have an ASP page setup for doing maintenance jobs in Oracle. Clicking a maintenance job spawns a new window (cut down to a small size with Javascript) and the jobs runs. Just before processing starts I output a message to the user in this new window using a span (with an ID) using Response.Flush. This is to let the user know that processing has started. After the procedure has completed, I update the span message using its ID with 'processed' or 'failed' accordingly. So far so good! The problem I have is that it only worked during development. This seems to be because during development I used an example I picked up from the ASPFAQ site to simulate database activity (ie a 15 second delay) without actually doing anything using SQLServer: sleep = 15 cn.open "Provider=sqloledb;Data Source=SVR;User Id=id;Password=pw" cn.Execute "WAITFOR DELAY '00:00:" & sleep & "'" With the above script everything worked great, and I could open three or four different procedures and have them all running simultaneously. Just what I wanted! However when I switched to running the actual procedures Oracle (which take a couple of minutes) I've found that it will only run one procedure at a time. And while this one procedure is running I lose communication with the parent window (the list of jobs) until the procedure has finished. Does anyone have any idea what might be causing this? The only difference (apart from the SQL) between running in live (Oracle) and simulating activity using SQL Server is the Provider. Could the Oracle provider be missing something the SQL Server Provider has? And if so, what might this be and can I get round it? I've copied an example maintenance job page below. TIA, Colin <%@Language=VBScript%> <%Option Explicit%> <%Session.LCID = 2057%>   <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> </head> <body id="oBody" style="filter:progid:DXImageTransform.Microsoft.Fade(duration=2);font-weight:bold;font-size:10pt;font-family:arial;tahoma"> <div id=messageToUserTxT style="background-color:3996FF;color:ffffff;position: absolute; left: 0; top: 0;"> Processing Receipts... </div> <table height="100%" width="100%"> <tr> <td align=center>Process Receipts</td> </tr> </table> <% Response.flush() Dim cn Dim sql Dim arSQL() Dim sleep Dim testing 'Setup SQL Redim arSQL(2) arSQL(0) = "begin" arSQL(1) = " Pacs_Inbound_Api.Process_Receipts;" arSQL(2) = "end;" 'Setup connection Set cn = Server.CreateObject("ADODB.Connection") 'RUN AS TEST OR LIVE? testing = True 'testing = False If testing Then 'TESTING Server.ScriptTimeout = 20 sleep = 15 cn.open "Provider=sqloledb;Data Source=SVR;User Id=id;Password=pw" cn.commandTimeout = 15 cn.Execute "WAITFOR DELAY '00:00:" & sleep & "'" Else 'LIVE Server.ScriptTimeout = 600 cn.open "Provider=OraOLEDB.Oracle;Data Source=SVR;User Id=id;Password=pw" cn.execute Join(arSQL,"") End If 'Destroy SQL array Erase arSQL If Err.number <> 0 Or cn.Errors.Count <> 0 Then response.write "<br>" & err.Description %> <script language=javascript> // After setting Apply, changes to the oBody object // are not displayed until Play is called. oBody.filters[0].Apply(); oBody.style.backgroundColor="FFD3D3"; oBody.filters[0].Play(); messageToUserTxT.innerText = ' Processing failed! '; </script> <% Else %> <script language=javascript> // After setting Apply, changes to the oBody object // are not displayed until Play is called. oBody.filters[0].Apply(); oBody.style.backgroundColor="CEFFC2"; oBody.filters[0].Play(); messageToUserTxT.innerText = ' Processing complete! '; </script> <% End If cn.Close: Set cn = Nothing %> </body> </html> Tag: ASP - First Time Onload Tag: 304741
  - 7
    - Problem in Response.write statement to retrieve a field in a check Hi, Here is my problem: I am logging in to a page, where the page retrieves a record from a database. The text boxes are used in the display formto let the users update the fields, if they desire to. The colorpreference and foodpreference fields are text fields while the FinalUpdate field is a yes/no field in Access Database. While retieving the values, the FinalUpdate field value is not showing up as it should. e.g. if for the record the database has a checked field for FinalUpdate(i.e. yes) then the chkFinalUpdate checkbox in the form should be checked. Instead it shows unchecked. I believe the code to retrive the value of the final update field is not correct. Any help is appreciated here for problem resolution. Regards RELEVANT CODE: <% 'Declare variables to store field values Dim l_ColorPreference Dim l_FoodPreference Dim l_FinalUpdate 'Get all the fields from the database in the above variable l_ColorPreference = RS.Fields("ColorPreference") l_FoodPreference = RS.Fields("FoodPreference") l_FinalUpdate = Rs.Fields("FinalUpdate") %>  <% Response.Buffer = true 'Declare all local variables dim CN dim RS dim rs1 dim strSQL 'set a local variable to my DSN-less connection String strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=C:\_______GWISNEWCON\greytest.mdb" 'Verify user information in the database 'Create the connection and recorset objects, set the SQL String and parameters 'and open recordset myDSN="DRIVER={Microsoft Access Driver (*.mdb)}; " myDSN=myDSN & "DBQ=C:\_______GWISNEWCON\greytest.mdb" set CN=server.createobject("ADODB.Connection") set RS=server.createobject("ADODB.Recordset") set rs1 = server.createobject("adodb.recordset") CN.Open myDSN RS.ActiveConnection=CN rs1.ActiveConnection = CN strSQL = "SELECT Main.IDNumber, Main.SocialSecurityNumber, Main.Password, Main.FirstName, Main.LastName, Main.ColorPreference, Main.FoodPreference, Main.FinalUpdate FROM Main where " & _ "SocialSecurityNumber ='" & Request.Form("txtSocialSecurity") & "'" RS.Open strSQL 'Response.Write strSQL 'Check for empty recordset which indicates user information was not found If RS.EOF or RS.BOF Then 'This statement opens the table so we can add a record notice the addnew 'The 2, 2 is how the table is opened there are many ways it can be opened rs1.Open "Main", 2, 2 'Use the addnew method of the recordset object to add a record rs.addnew 'Set the table column = to my input text box from my form rs("SocialSecurityNumber") = Request.Form("txtSocialSecurity") rs("FirstName") = Request.Form("txtFirstName") rs("LastName") = Request.Form("txtLastName") rs("ColorPreference") = Request.Form("txtColorPref") rs("Password") = Request.Form("txtPassword") rs("FoodPreference") = Request.Form("txtFoodPref") rs("FinalUpdate") = CInt(Request.Form("chkFinalUpdate")) rs.update Response.Write "<font color = ""teal"">" Response.Write "Process successful. Your record has been added to our database." Response.Write "</font>" Else 'Dispaly error message Response.Write "<font color = ""teal"">" Response.Write "Data exists corresponding to your input social security." Response.Write "<br>" Response.Write "Please check your social security number and try again." Response.Write "</font>" 'set objects to nothing to clear out memory CN.Close rs.Close rs1.Close set RS= nothing set rs1= nothing set conn = nothing End If %> Tag: ASP - First Time Onload Tag: 304698
  - 20
    - Add Records to an Iseries (AS/400) Server Hi All, I've gotten to the point where I can read records from our AS/400, but when I write, it goes through the motions but does not write anything. Here's my code to write to the AS/400: Set rsADDPM = Server.CreateObject("ADODB.Recordset") PNPLCD = request.querystring("pcode") PNOPTNO = request.form("PNOPTNO") PNOPTCL = request.form("PNOPTCL") PNNPTNO = request.form("PNNPTNO") PNNPTCL = request.form("PNNPTCL") SQLaddpm = "insert into SPSL.VARPM_PF (PNPLCD,PNOPTNO,PNOPTCL,PNNPTNO,PNNPTCL) values ('" &PNPLCD& "','" &PNOPTNO& "','"&PNOPTCL& "','"&PNNPTNO& "','"&PNNPTCL& "')" rsADDPM.open SQLaddpm, adoCon Like I said, it goes through the motion and tells me it wrote something, but when I check through the AS/400 sql intepreter, it doesn't display the record I just added. Do I have to commit the records somehow when I'm finished writing them? If not, what should I add in the code to make it write? Thanks! Brian. Tag: ASP - First Time Onload Tag: 304691
  - 21
    - How to increase the asp scripting expiry time? I have an asp application. However, the scripting time is too early too expried. How can I extend the scripting time for an individual asp page, or set for one website. Chris Tag: ASP - First Time Onload Tag: 304687
  - 22
    - Losing form variables!!! This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C4E1EA.12207390 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Howdy, I am having issues on an onine catalog site that is randomly losing = data. The first page amongst the issue is oc3.asp and the final page = that does the processing is ou.asp. oc3 collects credit card info and = billing address and passes it to ou. Ou then saves it all back to a = RedBack object connected to a UniVerse server. Out of the 100's of = orders placed since Friday, we lost 25 orders because we didn't have the = credit card no or billing information. I have created a log to catch certain information from the client = including the credit info, which doesn't appear here either. Some other = information I am catching that does appear everytime is the customer no, = which is a session variable, browser and OS and IP address. The browser = varies from Win95 and Win98 to AOL10 and WinNT 5.1 (WinXP). So it doen't = appear to be a client side issue, it appears to the be server. Event = Viewer is NOT displaying any errors in regards to these pages.=20 So, have you heard of something like this before? How can I troubleshoot = it more? Thanks! --=20 David Lozzi Web Applications/Network Specialist Delphi Technology Solutions, Inc. dlozzi(remove-this)@delphi-ts.com ------=_NextPart_000_0006_01C4E1EA.12207390 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Howdy,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I am having issues on an onine catalog = site that is=20 randomly losing data. The first page amongst the issue is oc3.asp and = the final=20 page that does the processing is ou.asp. oc3 collects credit card info = and=20 billing address and passes it to ou. Ou then saves it all back to a = RedBack=20 object connected to a UniVerse server. Out of the 100's of orders placed = since=20 Friday, we lost 25 orders because we didn't have the credit card no or = billing=20 information.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I have created a log to catch certain = information=20 from the client including the credit info, which doesn't appear here = either.=20 Some other information I am catching that does appear everytime is the = customer=20 no, which is a session variable, browser and OS and IP address. The = browser=20 varies from Win95 and Win98 to AOL10 and WinNT 5.1 (WinXP). So it doen't = appear=20 to be a client side issue, it appears to the be server. Event Viewer is = NOT=20 displaying any errors in regards to these pages. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>So, have you heard of something like = this before?=20 How can I troubleshoot it more?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks!</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV><FONT face=3DArial = size=3D2> <DIV><BR>-- <BR>David Lozzi<BR>Web Applications/Network = Specialist<BR>Delphi=20 Technology Solutions, Inc.<BR>dlozzi(remove-this)@delphi-ts.com</DIV> <DIV> </DIV> <DIV></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C4E1EA.12207390-- Tag: ASP - First Time Onload Tag: 304686
  - 23
    - Change in Short Date format under Hebrew Regional Settings This is regarding a change in the Short Date format under Hebrew Regional Settings, that has caused huge problems in our ASP web application. The change appears to have been introduced sometime before Windows 2000 Service Pack 4 and has remained through to Windows XP. I am looking for a solution that doesn't involve rewriting our application (much) and that allows all our users to keep using Hebrew Regional Settings. To summarize our problem - we have an ASP-based intranet web application that is used in our Israel office. Before we installed Windows 2000 SP4 on our web server and on the client machines in the office, the application ran perfectly. Dates appeared on the pages and in input textboxes in the correct dd/mm/yyyy format. Immediately after installing SP4, dates on the pages and in input textboxes are formatted as yyyy/mm/dd. This is not just a visual change, it has caused many functions in the application to break. No change was made in the Control Panel Regional Options on the clients or server. In fact if you look there, when Hebrew is chosen, the short date format on the Date tab is set to dd/mm/yyyy. We have pinned the problem down to residing in the vbShortDate argument with the VBScript function FormatDateTime. Following the installation of SP4, RTL control characters are inserted (unicode character 8207) after each date separator (/) in the date returned. I am certain that this is a bug with windows, or a badly implemented new 'feature'. Suppose we're working with the date January 20, 2004 and the serverside ASP code is returning exactly this (unformatted): 20/01/2004 1:00:00 When we format the date using FormatDateTime(datevalue, vbGeneralDate) we get this (the exact same thing): 20/01/2004 1:00:00 However, when we format the date using FormatDateTime(datevalue, vbShortDate) we get this: [Char8207]20/[Char8207]01/[Char8207]2004 This translates to display (inside an input field in internet explorer) to: 2004/01/20, although the date is really being written as the line above, i.e. [Char8207]20/[Char8207]01/[Char8207]2004. Internet Explorer is writing the date to the screen correctly, but the control characters that the formatdatetime function using vbshortdate argument are inserting are rearranging the display. The reason this is such a big problem is that other ASP functions that process dates do not recognise these dates that include the control characters as valid. If we use the IsDate function on the output of FormatDateTime("20/1/2004", vbShortDate) the result is FALSE (because the control characters exist). Does anyone know of a permanent solution to this problem that doesn't involve rewriting our application (much) and that allows all our users to keep using Hebrew Regional Settings? Tag: ASP - First Time Onload Tag: 304683
  - 24
    - new to asp I'm doing some asp, but all of my experience is with linux and linux related tools like python, php, mysql, etc. Basically, I can't find any good resources for asp/vb script. Nothing akin to the docs on python.org or php.net. Here is my current problem. I have a result set I got from an adodb connection and I want to loop through all the fields, but the number of fields may vary. Here's my code. If not RS.eof then RS.movefirst Do 'this doesn't work so how would I do this. for each field in rs.fields Response.write "Here is some Data " & field & "<br>" next Rs.movenext Loop until RS.eof End if Basically, I don't know how to get the fields into a form that I can loop through. Any help or links to good resources will be greatly appreciated. Tag: ASP - First Time Onload Tag: 304680
  - 25
    - XML Permissions I'm making a 1st attempt try at XML. I have downloaded a working example and tried to run on my IIS6 webserver. I get the below error in Listing #1. The code is in Listing #2. I think I need to set file premissions on file msxml3.dll located in my windows\system32 folder but wanted to ask is this a security risk or is it something we have to do to write to an XML file? Listing #1 msxml3.dll error '80070005' Access is denied. /testXML/xml1.asp, line 86 Listing #2 oXML.save myxmltest.xml Tag: ASP - First Time Onload Tag: 304678
- Next
  - 1
    - date comparation hello to all, i have this sql sentence Set xRs=pCon.Execute("SELECT sum(monto_abono) AS TpuntosM FROM con_vtas WHERE RUTGTE='"&session("rut")&"' and month("fecha")='#month("date")#'") but this (month("fecha")='#month("date")#'") is correct? the browser send me error "Error de compilación de Microsoft VBScript (0x800A03EE) Se esperaba ')'" thank -- Marco Antonio Artus S. Lakromsoft INC. 56-9-9594663 Tag: ASP - First Time Onload Tag: 304677
  - 2
    - Showing Calculated fields in the form Hi, I have a asp input form of a financial report. Here most of the fields are text boxes where the user need to input the values corresponding to an item. However, there are few items which are calcuated field. Prior to submission of the information, I would like the user to know what the calculated field be (based on the information input in text boxes) before submission of the form. Is there any way to display the calculated value before submission in ASP? I appreciate in any help. Thanks. Tag: ASP - First Time Onload Tag: 304671
  - 3
    - error while hosting asp.net in managed c++ dll. I have a pluggable asp.net hosting provider which uses a cassini-based http listener if the platform is win2k or xp (non sp2), and uses a HTTPAPI (http.sys) based listener in a managed c++ dll if the platform in win2k3 or XPsp2. The solution works perfectly when the HttpWorkerRequest is implemented in a c# dll. When it is implemented in the managed c++ dll, I always get the following error: The application's configuration files must contain 'trust' section. Stepping through the code, I can see that asp.net receives my HttpWorkerRequest and properly maps the directory to where I have my web.config. Adding a trust section doesn't help for any values in it. It's not a permissions problem because I've not only given the file full control for Everyone, but when debugging I can see that the process is in fact running as an administrator. Could anyone help? -EP Tag: ASP - First Time Onload Tag: 304663
  - 4
    - How can you put text from a file into a textarea box, when the file is selected from a Select list! Hi All, Hope someone can help here!! I'm putting a standard mail page together, that will allow my users to sent templete emails out to people. The files are stored in text files. I have come up with a script to produce the names into a Select list, but know i'm wanting them to be read into a textarea box, to allow me to submit them into from the form into the sendmail.asp page! but the only way i can pass them out, is into a iframe, which doesn't seem to allow me to then pass them into the sendmail.asp page for sending. Anyone help? Cheers Shaiboy shaiboy_ukNOSPAM@NOSPAMyahoo.co.uk Tag: ASP - First Time Onload Tag: 304659
  - 5
    - Picking out top three out of database Sorry for not answering earlier... to much do at the moment, christmas time and all. The database used is an access, simply because I don´t know how to do with any other db. Would like to try out something else (sql-server?) but don´t know what. I need it to be free though... /Thomas Tag: ASP - First Time Onload Tag: 304656
  - 6
    - Microsoft Word error '800a1528' 'the setting could not be created' I've just migrated a web-based vbscript process to w2k, which uses server- side word to create a new doc from a template and populate it from a form. Now, this was working fine on NT4, but now, when wordapp.options.defaultfilepath(wdUserTemplatesPath) = strpath is called, it throws the above with 'the setting could not be created' I'm assuming its a perms issue, but the iusr account has exe perms on the office folder, and the perms on the template folder are fine. ??? Tag: ASP - First Time Onload Tag: 304651
  - 7
    - learning ASP on XP Home Edition My daughter wants to learn ASP but her PC runs XP Home Edition which doesn't allow IIS. Is there any way she can still learn ASP? Tag: ASP - First Time Onload Tag: 304649
  - 8
    - How to Q (Resx) This is my Flow: 1. Create New project. 2. Add new item 3. Select "Assembly resource file" and name it "MyRes". 4. In the resx designer click on "Create Schema". 5. In the Schema remove the "Reshader". 6. Add new attribute named Data1 to "data" table. 7. Go Back to "MyRes" and add records. Now all I want is to read the data from the imbedded resx file. If I use the "ResourceManager" or the "ResourceReader" or the "ResXResourceReader" I can read the "value" attribute and not the new "Data1" attibute. I tried to create a Dataset based on the XSD but the dataset is empty without the data. Please help what should I do? Tag: ASP - First Time Onload Tag: 304647
  - 9
    - numeric value and string okay.. this should be long.. I made up a table in database with access consists of columns with text type. Some of them I put in data with numeric value and some of them I put in "Unlimited" as the value. Then, I allowed people to insert data but only with conditions. They can insert data if the value they are trying to insert is smaller than the one in the database. For "unlimited" value, they can insert any value. My problem is.... if the limited value in the database is 35, we cant insert data of 40 but we can insert data of 100. It seems that the code only takes the first number to be compared to the value in the database. Can anyone help me to overcome this? here''s part of my code If (diff = 0) OR (diff = 1) Then If (maxunit1 < strnoofunit) OR (maxdoc1 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End If ElseIf (diff = 2) Then If (maxunit2 < strnoofunit) OR (maxdoc2 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End If ElseIf (diff = 3) Then If (maxunit3 < strnoofunit) OR (maxdoc3 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End if ElseIf (diff = 4) Then If (maxunit4 < strnoofunit) OR (maxdoc4 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End If ElseIf (diff = 5) Then If (maxunit5 < strnoofunit) OR (maxdoc5 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End If Else If (maxunit6 < strnoofunit) OR (maxdoc6 < strnoofdoc) Then rs2.close conn.close set rs2 = nothing set conn = nothing Server.Transfer("maxunit2.asp") End If End If '' ------------------------------------------------------------------------- '' finish '' ------------------------------------------------------------------------- rs.Open "SELECT * FROM timesheet", conn, 3, 3 ''Add a record rs.AddNew ''Put username and password in record rs("memberid") = Session("memberid") rs("reference_no") = strrefno rs("entry_date") = date() rs("lspid") = Session("lspid") rs("solicitorid") = Session("solid") rs("code") = strcode rs("no_of_unit") = strnoofunit rs("no_of_document") = strnoofdoc rs("note_legalmatter")= strlegalmatter rs("note_entitlement")= strentitle ''Save record rs.Update Thanks guys ----------------------------- This message is posted by http://asp.forumszone.com Tag: ASP - First Time Onload Tag: 304641
  - 10
    - How to use MAPI using VB Script? Hi Kindly please give me a sample code to send email by using MAPI control with VB Script. I am planning to use it in my ASP pages on the server side. Thanks Michael Tag: ASP - First Time Onload Tag: 304640
  - 11
    - Do I need Dreamweaver or is NET Framework sufficient for good desi Are there things offered by products like Dreamweaver that I need to complement the Net Framework design in Visual Studio? I find that Javascript routines and special graphics are non-existent in Visual Studio. I code most of my html pages manually and use C# for my asp pages. Drop down menus and such I have to rely on third party products. So, will Dreamweaver fill these gaps? Dave Tag: ASP - First Time Onload Tag: 304634
  - 12
    - Blank ASP pages. Hello, We use Vignette V5.6 to display our site. In our CMA site, we have a page which has FRAMESET and in one of the frames we call a ASP page. There seems to be some problem that the frame shows the ASP page is blank. When we restart the IIS it works fine. But after some time it again shows the blank. If we get one blank page, all the asp pages under the same virtual directory, called in the Frame shows blank. FYI. The Vignette template which contains the frame is marked for NO caching & For itnernal use only. Any help on this front would be greatly appreciated. Thanks, Chandra Tag: ASP - First Time Onload Tag: 304628
  - 13
    - Locking all text boxes in asp page Hi, I need advise as to how to do the following. In a asp page, the user can input information via text boxes which goes to a database. If users click a check box named final and submit the asp page, then next time they come, they will not be able to change any information. This means, I would like to grey out the text boxes so that users are unable to edit the values in the text boxes. The only way to allow edit is via adminstrator's intervention. Any article, asvise, help to handle the concept and approach the problem is appreciated. Thanks. Tag: ASP - First Time Onload Tag: 304624
  - 14
    - runat="server" Hi, I have a BoundColumn in a DataGrid: <asp:BoundColumn DataField="lastname" SortExpression="lastname" ReadOnly="True" HeaderText="Last Name"></asp:BoundColumn> Column is sorted. I am wondering why this code is working properly as there is missing the statement runat="server". When I click on a header of the column, the grid posts back to the server and sorting is done. Why does it work without runat="server"? In my books is always used runat=â??serverâ?? expression. Is it a preferable way? Thanks, Lubomir Tag: ASP - First Time Onload Tag: 304620
  - 15
    - How To? How can I display the entry point URL Link after calling another .ASP?p=param Explain. assuming you are here www.mydomain.com and there's a login request within the login.asp there is a Method="POST" action=login.asp?p=loginid" I do not want the browser show the following www.mydomain.com/login.asp?p=param on the HTTP:// address bar just show the default URL www.mydomain.com Can this be possible.? TIA Tag: ASP - First Time Onload Tag: 304617
  - 16
    - session vars Is possible to terminate all session variable created without closing the browser I do not want users to click on BACK button on browser or paste the url link in the http:// and shows the record displayed after logout. This works fine if users close the Browser. Tag: ASP - First Time Onload Tag: 304614
  - 17
    - Creating Excel like form in asp application Hi, Currently, our clients use excel spreadsheet to give details of expense for a particular grant. e.g. expenseid type amount date ............. ..... ......... ...... ............. ..... ......... ...... ............. ..... ......... ...... ............. ..... ......... ...... This spreadsheet can run into 8-9 pages. I am working on a web application where the above process need to be converted into asp page allowing to add or delete detail expense line item. I would like to know if there is any knowledge base article or concept that will help me to build the above functionality in an asp page. Thanks in advance. Tag: ASP - First Time Onload Tag: 304611
  - 18
    - Consuming Web Services from ASP? Has somebody got an example of consuming web services from an ASP "client" web site? I saw mentions of "Soap Toolkit" but the Microsoft download area specifies that this will not be supported beyond April 2005... Is it a viable alternative to create a small .Net Library project to do the Web Services bit and expose the methods through COM (Interop)? Thanks Eric Mamet Tag: ASP - First Time Onload Tag: 304610
  - 19
    - Request.form doesn't wotk with this IIS config Hi i got a strange problem but it's true i don't make thing like anyone... First Config: + IIS5.0 SP2 (yes i know...) WebSite Security Root : Digest Authentication, NT Authenticated SubFolders : Anonymous Login Anonymous login is set to use a domain user to enable a sql server authenticated connection. Permissions are based on Page/action/user Membership So i know it is a bit strange but let me explain 1 I need a secured connection to a sql server 2 The Webserver is running multiple websites and i don't want to make it run under an account 3 I should avoid to request user and pass Now the way it works 1 Page default on the root is NT authenticated and i retrieve user and group membership. I put this in a Cookie. 2 When i click on one of the page linked it checks if an entry in the database exists for specified page, user(from the cookie), action. this page is with Anonymous login and so it uses the Account i set as anonymous user. 3 If it's ok i show the form mixing querystring and form 4 on submit (javascript function) when i echo all the content of the request i only see the querystring. NOW if i put Basic authentication on the Page... i see the request.form and the request.querystring... But i don't want basic authentication as password is sent in clear text and this is an administrative (System Admin) web site. here is a page as you'll see it is simple... if anyone has an idea... <HTML> <head> <link rel="stylesheet" href="/ERA/Lib/ERA.css" type="text/css"> <title>EB Automation : Da Vinci</title> <SCRIPT TYPE="text/javascript" LANGUAGE="JavaScript">  </SCRIPT> </head> <a name="Show_Environment_Create"> <TABLE width="800px" cellspacing="0" cellpadding="1" class="Pink" > <TH>Create an Environment</TH> <tr><td> </td></tr> <tr> <td colspan="2"> <FORM id="frmBody" name="frmBody" target="Contents" method="POST"> <TABLE width="800px" cellspacing="0" cellpadding="1" class="Pink" > <tr> <td class="pink">Name </td> <td class="pink"><input type='text' size=50 name='txtName' value='' > </td> </TR> <tr> <td class="pink">ShortName </td> <td class="pink"><input type='text' size=8 name='txtShort' value='' > </td> </TR> <tr> <td class="pink">Type</td> <td class="pink"> <select size='1' name='cmbType' class='pink'> <option value=''> </option> <option value='1'>Physical </option> <option value='2'>Logical </option> <option value='3'>Rollout </option> </select> </td> </TR> </table> <input type="button" value="Next" name="btNext" OnClick="return SubmitBody('Environments.asp?Action=CreateDb')"> </form> </td> </tr> </table> </body> </html> Tag: ASP - First Time Onload Tag: 304594
  - 20
    - MSXML2.XMLHTTP I wrote a small script that grabs two CSV files [links to the data files] from a remote web site, parses them out and displays them in scrolling divs. The first file has a little over 27k records, the second has less. It retrieves the data pretty quick but it takes awhile to write the page. Is there a better alternative to this approach? This is my page: http://kiddanger.com/lab/getsaveurl.asp This is the relevant code to retrieve the data: function strQuote(strURL) dim objXML set objXML = CreateObject("MSXML2.ServerXMLHTTP") objXML.Open "GET", strURL, False objXML.Send strQuote = objXML.ResponseText set objXML = nothing end function I split the data into an array and then split that into a new array because the delimeters are line feed and comma, respectively. TIA... -- Roland Hall /* This information is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. */ Technet Script Center - http://www.microsoft.com/technet/scriptcenter/ WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp Tag: ASP - First Time Onload Tag: 304593
  - 21
    - Auto-lock out module after 3-5 unsuccessful logins Hi, I would like to create an auto-lock out module where users are unable to continue login attempt after 3-5 unsuccessful logins. In addition, the user account are automatically suspended after stipulated unsuccessful logins. Is there any sample coding in ASP or Javascript for me to refer to?? Thanks alot!!! Tag: ASP - First Time Onload Tag: 304588
  - 22
    - ASP & Excel Hi, I'm trying to export an ASP based report to Excel while preserving its display properties. I've added: Response.ContentType="application/vnd.ms-excel", and it works fine for several clients. For other clients it displays an emptry excel sheet. I'm not sure, but i think it has something to do with the excel version installed on clients - empty sheets were displayed for Excel 2000 clients while clients running Excel 2002 displayed the report correctly. If I add: Response.AddHeader("attachment","file_name=%file_name%"), all clients display the data correctly but the styles are lost. If anyone knows of a solution other than reformatting the report for excel, it will be very helpful. Thanks Tag: ASP - First Time Onload Tag: 304587
  - 23
    - How to use a variable in a server control Instead of using <asp:sqldatasource selectcommand="select * from Table1">, how can I use a variable in place of the 'Select * from Table1' ? Thanks! Tag: ASP - First Time Onload Tag: 304581
  - 24
    - Mutex page operations I have a site which is using caching for some frequently used pages. When the page-level cache expires, or is expired by me, the page will get re-rendered to a static HTML file and then shown to the user, after it has been rendered. Assume the cache is stale. Somebody comes along and requests the page. It will then get re-generated, but whilst this is happening, if somebody comes along and requests the page again then they can get an error because the static HTML page file is still being recreated by the previous page request. What I think I need is a mutex for the page to stop this from happening, for the second page request, during cache refresh. So: 1st request owns the mutex until finished, and, whilst it's updating, all other page requests wait on the mutex. How can I implement a 'mutex' style operation for this scenario in ASP or handle it better to avoid this situation from happening? I've got my code able to understand if the page being requested is actually being updated, so I could just redirect the client back to the same script again, but at the same time the update process itself takes less than a second, so if the page could somehow wait for the operation to complete it would be a cleaner operation. I tried wrapping the Sleep API in a COM object, but this didn't seem to work and I'm just looking for a bit of a sanity check on the best way to go about this. Thanks Richard Tag: ASP - First Time Onload Tag: 304576
  - 25
    - ASP and Telnet I need to communicate with a POP3 server using ASP. Does anybody have any ideas how I can set up a telnet connection using an ASP script? There are some components out there, but my host won't allow them. Thanks for any ideas, R Tag: ASP - First Time Onload Tag: 304575

Hi Guys,

Can you please help me. Im trying to redirect the first time visitors to
my homepage to a different page other than the homepage. Is this
possible?

regards
Jan.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Top

Re: ASP - First Time Onload by Mark

Mark
Wed Dec 15 17:56:27 CST 2004

only by setting a cookie to distinguish between "old" and "new" visitors

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com

"JAN MELLO" <j1@lbizo.com> wrote in message
news:ubbYR6v4EHA.1392@tk2msftngp13.phx.gbl...
>
>
> Hi Guys,
>
> Can you please help me. Im trying to redirect the first time visitors to
> my homepage to a different page other than the homepage. Is this
> possible?
>
>
> regards
> Jan.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Top

Re: ASP - First Time Onload by John

John
Thu Dec 16 02:40:06 CST 2004

I think setting cookies is the only way too.

JAN MELLO wrote:
> Hi Guys,
>
> Can you please help me. Im trying to redirect the first time visitors
to
> my homepage to a different page other than the homepage. Is this
> possible?
>
>
> regards
> Jan.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Top

Re: ASP - First Time Onload by John

John
Thu Dec 16 03:04:21 CST 2004

I think setting cookies is the only way too.

JAN MELLO wrote:
> Hi Guys,
>
> Can you please help me. Im trying to redirect the first time visitors
to
> my homepage to a different page other than the homepage. Is this
> possible?
>
>
> regards
> Jan.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Top