Page Expires - even on Back button?

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
    - ASP CDO Problems Hey All, I have MDaemon running locally on the server, and that is what I want to send mail through. It's a normal mail server which doesn't require an access list, I just have a list of trusted IP's to accept mail from. This is the code I use on my ASP page <% 'Send email using CDO. Public Function sendEMail( fromAddress, toAddress, subject, body ) Dim outgoingSMTPServer, smtpUserID, smtpPassword Dim objMail 'Trim all the parameter values. fromAddress = Trim( fromAddress ) toAddress = Trim( toAddress ) subject = Trim( subject ) outgoingSMTPServer = "" smtpUserID = "" smtpPassword = "" 'outgoingSMTPServer = Application( "OutgoingSMTPServer" ) 'smtpUserID = Application( "SMTPUserID" ) 'smtpPassword = Application( "SMTPPassword" ) 'Correct COX SMTP address. outgoingSMTPServer = "127.0.0.1" 'Make sure that we have from, to address and body. If fromAddress = "" Or toAddress = "" Or body = "" Then sendEMail = False Exit Function End If 'Create the object. Set objMail = Server.CreateObject( "CDO.Message" ) objMail.From = fromAddress objMail.To = toAddress objMail.Subject = subject objMail.HTMLBody = body 'Send using the specified SMTP server. objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/sendusing" ) = 2 'Name of the smtp server name. objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/smtpserver" ) = "localhost" 'Default port. objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/smtpserverport" ) = 25 'Set the user ID and password if available. If smtpUserID <> "" And smtpPassword <> "" Then objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/smtpauthenticate" ) = 1 'Your UserID on the SMTP server objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/sendusername" ) = smtpUserID 'Your password on the SMTP server objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/sendpassword" ) = smtpPassword objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/smtpusessl" ) = False objMail.Configuration.Fields.Item _ ( "http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout" ) = 60 End If 'Update the configuration. Call objMail.Configuration.Fields.Update() 'Send the message Call objMail.Send() 'Release the object. Set objMail = Nothing sendEMail = True Exit Function End Function %> That function is in it's own asp page. I just include it when necessary. when I call the function and pass it the appropriate parameters, it seems to go through without erroring, but of course I never get the email, and the MDaemon logs dont even show an attempted connection. Any ideas? Tag: Page Expires - even on Back button? Tag: 298494
  - 2
    - Web Publish behind ISA I have been assigned a perm IP address for my registered domain along with a gateway and two dns addresses. I am using one W2003 Server for domain controller and ISA. My local address is 192.xxx.xxx.xxx Q1:what do I put in the Lat for internal addresses? Q2: Does mydomain.com go into the LDT? Q3:More to come...... -- Generations Ranch Tag: Page Expires - even on Back button? Tag: 298493
  - 3
    - IIS 5.0 Config for Asp hosting trouble Hi I am having some trouble getting a asp page to load. Im a noob to the asp side. I have followed knowledege base Article 301305. I am running 2000 adv, IIS 5.0 I have the following settings to the folder that has the asp. Application settings application name: upload Starting poing: <website>\upload Execute Permissions: Scripts Only App Protection: High(isolated) Is there anything else i need to do? I installed the lockdown awhile back...does that interfere? Thanks, James Tag: Page Expires - even on Back button? Tag: 298484
  - 4
    - Managing a Database using Word / IIS I have a fairly ambitious client who would like to offload the management of intranet content to other individuals in the organization. For the project to be successful, the data management must be as painless as possible. Accordingly, the ideal interface for data input is Microsoft Word, as most users are extremely comfortable working with it. I would like to be able to create word templates/forms which are dynamically populated with data from an database, then downloaded to the client PC. Once the data is updated, I would like the user to upload their files back to the server, which will in turn update its database and maintain an audit-trail of all changes. Can this be done? I'm assuming that if I install Office on the server, it would be feasible using the office API, but I would love to be able to do this without office on the server.. any hints / suggestions would be HUGELY appreciated! Thanks, Aaron Tag: Page Expires - even on Back button? Tag: 298479
  - 5
    - Urls messy - extra characters not expected? After peforming a basic redirect with two query string parameters I load the page successfully...however the url does not look pretty...can anyone tell me why these percentage signs and extra symbols are showing up: http://69.2.200.70/dev/1/doc3.asp?vID=12&u_FromURL=http://69.2.200.70/dev/1/link.asp&bhjs=1&bhrf=http%3A%2F%2F69%2E2%2E200%2E70%2Fdev%2F1%2Flogon%2Easp%3FCookieChk%3DDisabled%26u%5FFromURL%3Dhttp%3A%2F%2F69%2E2%2E200%2E70%2Fdev%2F1%2Flink%2Easp%26u%5FCurrentURL%3D%2Fdev%2F1%2Fdoc3%2Easp&bhqs=1 Is this related to UNENCODE or something along these lines...? I know percentage symbols traditionally stand for 'spaces' but this seems different.... Thanks Jason Tag: Page Expires - even on Back button? Tag: 298469
  - 6
    - ASP Web Application Timeout Greetings, I have an ASP web application that is written in VBScript, uses MS Access 2000 for record storage, and is running on a Windows 2000 Professional SP4 computer with IIS 5. The application can be started, have a record updated and stored, and then terminate successfully on demand. I would like to have the application remain active on the IIS Server without timing out, but when I attempt to run it in that way, I receive a message (usually first thing in the morning) of "An Eror Occurred - Your Session Timed Out". I have set the Session Timeout feature in IIS to 1440 minutes, and the Server Script Timeout feature in IIS to 1000000 seconds, but the application still times out each morning. Can anyone tell me what else I need to do to keep this application available all day and all night? Thanks! MrLr Tag: Page Expires - even on Back button? Tag: 298468
  - 7
    - localization and ASP Hi, I have a simple 'user' table (SQL Server 2000) and an ASP form that connects to it. I want users of all languages to be able to type in their registration info, in their own language (chinese, german, etc..), store it that way, then have another page that displays it. Is there anything specific I need to do with ASP (classic, not .NET), to handle this? Thanks Tag: Page Expires - even on Back button? Tag: 298464
  - 8
    - Out of memory error message. I get the following error message from an ASP page that we have: METHOD: POST ERROR DESCRIPTION: 007~ASP 0100~Out of memory~Unable to allocate required memory. ERROR NUMBER: -2147024882 ERROR SOURCE: Response object Does anyone out there have any ideas? Please let me know if you need any more information ... I am not sure why this message has suddenly started to pop up. I checked the system logs and cannot see any particular memory loss related message so I don't know. TIA, Rohan Tag: Page Expires - even on Back button? Tag: 298463
  - 9
    - How can I test to see whether a particular object variable is defined? Hi Gang, I want to test and find out whether or not a particular variable object has been defined. I need to know whether or not a recordset has already been defined in the current script. However, my script crashes even though I've disabled error handling, which doesn't make a whole lot of sense to me, but anyways :). Here's my code: --------------------------------------------------- on Error Resume Next If objRS.Fields.GetCount > 1 Then RestartRecordSet() Else OpenConnection() End If On Error Goto 0 ----------------------------------------------------- Is there some command like If isdef(objRS) then... or something to that effect? Also is .GetCount the correct command? I think it is, but MSDN help has a special way of giving too much information. Thanks in advance, Christian Blackburn Tag: Page Expires - even on Back button? Tag: 298448
  - 10
    - Source Control for Web Projects What are people using for source control for ASP and HTML files? We have a typical scenario here, a handful of developers working locally on development, an internal staging server, then an external-facing production web server, all Windows 2003. I'm quite familiar with Visual Sourcesafe, but it doesn't easily allow (to my knowledge, anyway) to move ad-hoc files through to production to fix high severity bugs on the fly. It requires project labeling or "pinning" other files that have been checked-in but aren't ready for prime time. Other solutions? thx Jeff Tag: Page Expires - even on Back button? Tag: 298447
  - 11
    - Converting hrs and min to just min I am using two fields on a form to capture time someboby is working. The fields are hours and minutes. How can I when submitting to the db take both fields and convert them to a single field in the db as minutes? Thanks Carmen Tag: Page Expires - even on Back button? Tag: 298444
  - 12
    - Where do I go wrong when using URLencode? <A href= "GenericUploader.asp?SavePath=<%=server.URLEncode("D:\my new web site\U") %>">folder name</A> the link above does not seem to produce the appropriate query string value upon being clicked on. That is, when an internet user clicks on that link, the Internet Explorer opens the GenericUploader.asp web page, and the code in that asp web page responsible for picking up the value corresponding to the argument 'SavePath' (i.e, request.querystring("SavePath")) returns solely the first word of the value rather than the entire CORERECT value, which is 'D:\my'rather than 'D:\my new web site\U'. Can anyone tell me what needs to be done? Thank you in advance Avi Tag: Page Expires - even on Back button? Tag: 298441
  - 13
    - Error "cannot update database or object is read-only" when updating MDB file in ASP I have IIS installed on XP Professional workstation machine. I have an ASP page that open connection to an Access database, then when trying to update the database, it gave me the error "cannot update database or object is read-only". This is a workstation machine, not connected to any other computer, and I login to the PC using an administrator account. I already check the .MDB file is NOT read-only. But, I do not see the .LDB file. Manually, I can update the .MDB file, and I can create a new file on the directory where the MDB file is. The directory where the MDB is located says "read only", then I uncheck the read only, click apply and OK. When I go back to the property of the directory, it went back to "read only". This seems to happen on any XP machine. But, I can still manually create a new file, delete a file, rename a file on this directory. The MDB file used to have a password, when it did, I got the error on the statement sds("SECURITY_EXTRA1") = sExtra When I got rid of the password, I got the error on the statement sds.update How can I fix this problem ? Thank you. Here are my codes: Set dbConnection = Server.CreateObject("ADODB.Connection") session("CustomersDB_ConnectionString") = "dsnName" Session("CustomersDB_RuntimeUserName") = "userId" Session("CustomersDB_RuntimePassword") = "passw" dbConnection.Open Session("CustomersDB_ConnectionString"), Session("CustomersDB_RuntimeUserName"), Session("CustomersDB_RuntimePassword") Set sds = Server.CreateObject("ADODB.Recordset") sds.ActiveConnection = dbConnection sds.CursorType = adOpenKeyset sds.LockType = adLockOptimistic sds.Source = "select SECURITY_ID,SECURITY_EXTRA from SECURITY where SECURITY_USERID = 'abc'" sds.Open sds("SECURITY_EXTRA1") = sExtra sds.update Tag: Page Expires - even on Back button? Tag: 298438
  - 14
    - upload sql files from IIS to sql We have clients upload sql files to a folder on an IIS 6.0. The sql file are then processed by a scheduled task that runs once every 10mins to process the file with oSQL. With oSQL the files upload the data to a 2 tier SQL server. The developers are complaining about performance and are saying it is the OS/hardware. I have Profmon on the IIS server and 2 tier SQL server. Both only peak at %5 usage on processor memory stays close to the same. I believe that it would better to have IIS make a connection to the SQL server and upload the record directly. What do you think? and any examples would be nice or URL that talks about how to do this. Thanks for you ideas and help!! Tag: Page Expires - even on Back button? Tag: 298434
  - 15
    - Using special characters within a string Hi Doing my best to understand why I cant insert a vbcrlf or an equivalent into this piece of code that read messages from an SQL DB. The messages it takes read into a marquee fine but I want the Marquee to scroll up instead of horizontally and I need new line spacings else the mesages are difficult to read. At present we use the strNewTextDelimitor and I am unable due to syntax or perhaps idioscy to find a way of adding the VBCRLF or any derivative into this code so......I am sure its simple but could do with a hand...Tx in advance. This outout is pumped to a page back to a page which will not pick up the new messages if I use any of the following characters (even without placing them into a variable) vbcrlf vbcr vblf chr(13) chr(10). Do While Not adoRecordset.EOF ' Add the current message in the recordset to the string that is returned strNewText = strNewText & strNewTextDelimiter & Trim(adoRecordset.Fields("Message").Value & "") ' Set the delimiter ready for the next message. strNewTextDelimiter = " * * " ' Get the next message from the recordset adoRecordset.MoveNext Loop The code above works fine but the moment I attempt to add the special characters the scripts do not run and the web page will not update :-( , Tis driving me crackers! Cheers, Tag: Page Expires - even on Back button? Tag: 298428
  - 16
    - Centrilized Data Connection Hi, I have several ASP pages, and some of them are using the same access Database and table. Can I put the connection string somewhere centralized, so I can link to it ? Thx in advance TNGgroup Tag: Page Expires - even on Back button? Tag: 298419
  - 17
    - Put a Timer on the web form Hi, I'm new to ASP.NET. I have an WebForm1 which contained a ListBox1. I have drag a Timer on the form. In the timer1_Elapsed() function , I have add the line ListBox1.Items.Add("haha"). But when the timer elapsed, it called that line of code, but the ListBox1 didn't show "haha". Would you tell me what I have missed? I'm using C#/ASP.NET Best regards, C Learner Tag: Page Expires - even on Back button? Tag: 298418
  - 18
    - How can I check that the form is not posted from a local html page As title Tag: Page Expires - even on Back button? Tag: 298415
  - 19
    - asp with radio buttons on forms Hello all... I have a page that will be performing a search. The search consists of 3 radio button options. The first 2 will search the entire web through google and the site as indexed by google. The 3rd option I want to search the site using MS-Index Server. I can get them to run individually but I'm not sure how to set the parameters and test for the 3rd radio button (index server) selected on the page. I thought that, for example, my Searchinc.asp could have an If...then...else: <form action="../gw/incl.idq" method="GET"> <td valign="bottom" align="right" width="100%"> <input type="HIDDEN" name="CiScope" value="/geo_portal/gw"> <input type="HIDDEN" name="CiMaxRecordsPerPage" value="10"> <input type="HIDDEN" name="TemplateName" value="incl"> <input type="HIDDEN" name="CiSort" value="rank[d]"> <input type="HIDDEN" name="HTMLQueryForm" value="../gw/incl.asp"> </td> <td width="1"> </form> <%else%>  <form method="get" action="http://www.google.com/custom" target="google_window"> <%end if%> <table width="770" height="32" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr class="geoTopLinks"><td width="99" height="32" align="left" valign="top" nowrap="nowrap"> <a href="http://www.google.com/"> <img SRC="http://www.google.com/logos/Logo_25wht.gif" alt="Google" height="32" border="0"></img></a> </td> <td nowrap> <input type="hidden" name="domains" value="www.site.com"></input> <input type="text" name="q" size="15" maxlength="255" value=""></input> <input type="submit" name="sa" value="Search"> </input> </td> <td width="342" height="32" nowrap><font size="-1" color="#000000"> <input type="radio" name="sitesearch" value=""> <span class="Verd10pt">Web <input type="radio" name="sitesearch" value="sitename"> GeoPlace <input type="radio" name="sitesearch" value="geoworld" checked> GeoWorld </span></font><br> <input type="hidden" name="client" value="pub"> </input> <input type="hidden" name="forid" value="1"> </input> <input type="hidden" name="channel" value="a number"> </input> <input type="hidden" name="ie" value="ISO-8859-1"> </input> <input type="hidden" name="oe" value="ISO-8859-1"> </input> <input type="hidden" name="safe" value="active"> </input> <input type="hidden" name="cof" value="big number"> </input> <input type="hidden" name="hl" value="en"> </input> </td> <td width="133" nowrap> The google part works just fine, I can't seem to get the index server piece to work.... Can anyone give me any suggestions? Thanks in advance... Brian Tag: Page Expires - even on Back button? Tag: 298394
  - 20
    - how do i allow access to a shared folder? how can i allow access to a shared network folder? i am trying to give access to my as pages only. i don't want just anyone to type in the path of my files. i can't seem to do this with a shared folder. -- 5khzgjf9e001@sneakemail.com Tag: Page Expires - even on Back button? Tag: 298392
  - 21
    - using ASP and parametized query Per a previous suggestion, I'm trying to use a parametized query in Access 2002. The query functions properly in Access. Now I'm trying to call it from ASP. I'm using code I found at http://www.xefteri.com/articles/apr302002/default.aspx and trying to adjust for my needs. I'm getting this error. The query is there and functioning. It appears that I'm not connecting. Can I get some more insight? thanks! ------------------------------ Microsoft VBScript runtime (0x800A01A8) Object required: 'qry_FindSongs 'White' ------------------------------ My connection string is ------------------------------ Dim conn, mdb, mdw, MM_GenKAccess_STRING set conn = CreateObject("ADODB.Connection") conn.Mode=adModeRead mdb = Server.MapPath("songs.mdb") mdw = Server.MapPath("system.mdw") MM_GenKAccess_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source=" & mdb & ";" & _ "Jet OLEDB:Database Password=xyz;" & _ "Jet OLEDB:System database=" & mdw conn.open MM_GenKAccess_STRING ------------------------------ <% OPTION EXPLICIT %> <% Dim T T = "%" If (Request("title") <> "") Then T = Request("title") End If %> <% Dim A A = "%" If (Request("artist") <> "") Then A = Request("artist") End If %> <% Dim C C = "%" If (Request("category") <> "") Then C = Request("category") End If %> <% Dim TY TY = "%" If (Request("type") <> "") Then TY = Request("type") End If %> <% Dim M M = "%" If (Request("manuf") <> "") Then M = Request("manuf") End If %> <% Dim SA SA = "%" If (Request("singleartist") <> "") Then SA = Request("singleartist") End If %> <% Dim rsResults Set rsResults = Server.CreateObject("ADODB.Recordset") rsResults.ActiveConnection = MM_GenKAccess_STRING rsResults = "qry_FindSongs '" & T & "', '" & A & "', '" & C & "', '" & TY & "', '" & M & "', '" & SA & "'" rsResults.Open rsResults, 0, 4 %> Tag: Page Expires - even on Back button? Tag: 298391
  - 22
    - asptxn.dll in Windows 2000 but not in Windows 2003 Hello All This might just be my ignoranace. --------------------------- The asptxn.dll exists on my Windows 2000 box: C:\WINNT\system32\inetsrv>dir asptxn.dll Volume in drive C has no label. Volume Serial Number is 5839-8874 Directory of C:\WINNT\system32\inetsrv 06/19/2003 01:05p 30,480 asptxn.dll 2 File(s) 369,184 bytes 0 Dir(s) 264,912,896 bytes free -------------------------- However, on my Windows 2003 box: C:\WINNT\system32\inetsrv>dir asptxn.dll Volume in drive C has no label. Volume Serial Number is 7CFC-DDD5 Directory of C:\WINNT\system32\inetsrv File Not Found Does anyone know if (a) I missed an installation step (b) If there is a replacement for asptxn.dll that I should be using (c) If there is another location that I should search for this dll. Actually, I searched the whole filesystem and didnt find anywhere. Any help would be appreciated. Please respond to this post. Thanks -R Tag: Page Expires - even on Back button? Tag: 298389
  - 23
    - http_referer empty? Firewalls? Can one reliably use http_referer to track a user page selections as I appear to be getting BLANK values? I have read that company firewalls etc block this method.... Thanks jason Tag: Page Expires - even on Back button? Tag: 298376
  - 24
    - Converting 25062002120236 to a date! How can I convert a string such as 25062002120236 into a date (25-06-2002 12:02:36). I have tried using the CDate() & ISDate() functions but they don't recognise and convert this into a date. Thanks in advance, Quintus Tag: Page Expires - even on Back button? Tag: 298373
  - 25
    - Cookies being reset or disappearing mysteriously My website uses cookies to persist a certain amount of data on the client. However, occasionally the cookies will disappear or be set to an empty string for no discernable reason. It does not happen in our development environment at all, but does happen in our production environment. We looked at all the likely settings and they were identical on both the production and live servers. We set the cookie domain properly and the cookie path. Has anyone seen similar behavior? And if so, what did you do about it? What IIS settings should I be looking at? Could it be a service pack that was installed on one machine but not another? Any ideas, thoughts or advice would be appreciated. Thanks for any help! Richard Tag: Page Expires - even on Back button? Tag: 298370
- Next
  - 1
    - Script to format existing Access table into wall calendar format? I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus. Any suggestions on where to start? TIA! Lisa Tag: Page Expires - even on Back button? Tag: 298369
  - 2
    - HTMLBody and variable Hi everybody, It seems that a variable cannot be assign to HTMLBody field. Am'I doing something wrong? - this line write a bold html phrase in the email body .HTMLBody = "<HTML><HEAD><BODY><B>Here is the text body</BODY></HTML>" - this line produce an empty body. The variable TableData contains all the required HTML to construct the table. I Use Response.Write and see all the code in it.. .HTMLBody = "<HTML><HEAD><BODY>" & TableData & "</BODY></HTML>" thanks in advance Tag: Page Expires - even on Back button? Tag: 298364
  - 3
    - Build a form - function - combo/select boxes? Is it possible to extend this function to dynamically create a combo boxes from the db table....How would do this...I tried passing a 'Select' type to the function but got a blank entry....Any ideas? function BuildInput(sType,sName,sValue,iSize,iLength) select case sType case "text": BuildInput = "<INPUT TYPE=""text"" NAME=""" & sName & """ VALUE=""" & sValue & """ SIZE=""" & iSize & """ MAXLENGTH=""" & iLength & """>" case "password" BuildInput = "<INPUT TYPE=""password"" NAME=""" & sName & """ VALUE=""" & sValue & """ SIZE=""" & iSize & """ MAXLENGTH=""" & iLength & """>" case "submit" BuildInput = "<INPUT TYPE=""submit"" NAME=""" & sName & """ VALUE=""" & sValue & """>" end select end function Response.Write(BuildForm("edituser","post")) Response.Write(BuildInput("hidden","u_id",Request.QueryString("u_id"),"","") ) Response.Write("<TABLE>") Response.Write("<TR><TD>User Name</TD><TD>" & & BuildInput("text","u_name",escapeString(oRS.fields("u_name")),20,50) & "</TD></TR>") Response.Write("<TR><TD>Password</TD><TD>" & BuildInput("text","u_password",oRS.fields("u_password"),12,12) & "</TD></TR>") Response.Write("<TR><TD>First Name</TD><TD>" & BuildInput("text","u_firstname",escapeString(oRS.fields("u_firstname")),20,5 0) & "</TD></TR>") Response.Write("<TR><TD>Last Name</TD><TD>" & BuildInput("text","u_lastname",escapeString(oRS.fields("u_lastname")),20,50) & "</TD></TR>") Response.Write("<TR><TD>Email Name</TD><TD>" & BuildInput("text","u_email",escapeString(oRS.fields("u_email")),20,50) & "</TD></TR>") Response.Write("<TR><TD COLSPAN=2>" & BuildInput("submit","action",ACTIONSAVE,"","") & "</TD></TR>") Response.Write("</TABLE>" Many thanks Jason Tag: Page Expires - even on Back button? Tag: 298354
  - 4
    - ASP object required error - vbscript Dear Group I am trying to use the following code to refer to a form and control on my form. I am supposed to be using VBSCRIPT for this code. I always get an "object required: 'document' " error: <% Dim Myform Set Myform = document.forms.thisform Myform.textbox1.value = "fish" %> None of this code will work. Always get an error. Using Visual Interdev, plain ole ASP, and vbscript, and Win XP Pro with IIS 5.1 What am I missing or doing wrong??? Thanks eric Tag: Page Expires - even on Back button? Tag: 298353
  - 5
    - Loop with Read Only cursor? Hello, I posted a question about looping with Select in a While loop, a few days ago. Repliers to my post advised me that a Cursor would be much better (thanks all for your replies). I found a looping example using cursors on the net, but I don't know how to declare a read only cursor. Note: my objective is to simulate an array of field names for creating an xml doc/string (to use with OpenXML function). So I created a small table with 22 field names (22 rows). Originally, I had 2 columns - a RowNum col and a fldName col. But with the following example using a Cursor, it seems that I only need 1 column, the fldName col, although this seems like more lines of code than the Select method. The cursor example follows. The question is "How to declare a read only cursor". I also included my Select example - actually the full UDF using Select in the While loop - if anyone could advise me between the two examples which would be more suited for my situation. Cursor Example ----------------------------------------------------- declare @fldName varchar(50) declare @RowNum int declare fldList cursor for select fldName from tblflds OPEN fldList FETCH NEXT FROM fldList INTO @fldName set @RowNum = 0 WHILE @@FETCH_STATUS = 0 BEGIN set @RowNum = @RowNum + 1 print cast(@RowNum as char(2)) + ' ' + @fldName FETCH NEXT FROM fldList INTO @fldName END CLOSE fldList DEALLOCATE fldList -------------------------------------------------------- UDF using Select in While loop Example ---------------------------------------------------- CREATE FUNCTION ConvertToXML( @str1 varchar (8000)) --@str1 contains a list of values from external source --UDF will create xml string by adding a fieldname to --each value from @str1, comma delimited returns varchar (8000) as begin declare @fld varchar(255) declare @fldNum int declare @rownum int --used to increment Select statement declare @xml varchar(8000) --resultant xml string declare @val varchar(255) --each value in @str1 declare @pos1 int --get comma delimeter position of @str1 declare @pos2 int --get comma delimeter position of @str1 set @xml = '<ROOT><Worktable ' set @rownum = 0 set @pos1 = 1 select top 1 @fldNum = rownum, @fld = fldName from tblflds while @rowNum < 22 begin set @pos2 = charindex(',', @str1, @pos1) set @val = substring(@str1, @pos1, @pos2 - @pos1) set @xml = @xml + @fld + '="' + @val + '" ' select top 1 @fldNum = rownum, @fld = fldName from tblflds where rownum > @fldnum set @rowNum = @rownum + 1 set @pos1 = @pos2 + 1 End set @xml = substring(@xml, 1, len(@xml)) set @xml = @xml + '/></ROOT>' return @xml end ---------------------------------------------------------- This UDF works fine with the Select loop. But if this is a kludge and the cursor method would be more correct/professional/better habit to be in, please advise. I am also open to suggestions if there is an easier way to parse @str1 or create @xml. Thanks, Ed Tag: Page Expires - even on Back button? Tag: 298350
  - 6
    - SQL statement error fixed, now wrong data appending Hey guys.... I put an error-handling in my page and have it posted at the complete end of the code, see below(when people were putting in 's I was getting the delimiter errors). Great, I understand that now and it seems to be fixed but the data I'm pulling from the HTML fields is not being appended correctly do my Access DB....The field in the DB now reads " ' ". I understand why it does that (my function) but what I need it to read is whatever data was entered into my text area named "comments". I tried to change the line of code in the SQL statement to read DoubleUpQuotes(comments) but that didn't work....Any help? The page processes, which is a step in the right direction but fixing one thing has broken another.... All of the text input boxes need to have this error-handling capability... <% Mode = request.form("mode") Name = request.form("name") -DROP DOWN BOX Shift = request.form("shift") -RADIO BUTTON Wave = request.form("wave") -TEXT INPUT BOX Carton = request.form("carton") -TEXT INPUT BOX Location = request.form("location") -TEXT INPUT BOX License = request.form("license") -TEXT INPUT BOX Sku = request.form("sku") -TEXT INPUT BOX Qty = request.form("quantity") -TEXT INPUT BOX Reason = request.form("reason") -DROP DOWN BOX Comments = request.form("comments") -TEXT INPUT BOX if mode = "Send" then '***************************************************************************** '* DATABASE APPENDING * '***************************************************************************** 'create db connection Set dbconn = Server.CreateObject("ADODB.Connection") 'open db in a DSN-less method dbconn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE="& Server.MapPath("/jax/wh/Online_Forms/Secured_Archives/search_files/shortage.mdb") 'SQL statement to be run stateSQL = "INSERT INTO shortage (name, shift, wave, carton, location, license, sku, qty, reason, comments)" &_ "VALUES ('" & name & "','" & shift & "','" & wave & "','" & carton & "','" & location & "','" & license & "','" & sku & "','" &_ qty & "','" & reason & "','" & DoubleUpQuotes(strFormElement) & "')" 'display results of statement on screen for testing purposes Response.Write(stateSQL) 'remind the SQL statement who it works for dbconn.Execute(stateSQL) 'smack around the db connection until it lets go dbconn.Close 'kill the connection with extreme prejudice set dbconn = nothing '***************************************************************************** '* FILE APPENDING * '***************************************************************************** ' Create a text file shortage = Server.MapPath("/jax/wh/Online_Forms/Secured_Archives/Archive_TextFiles/Shortage_File.txt") Set fileobject = Server.CreateObject("Scripting.FileSystemObject") Set textfile = fileobject.OpenTextFile(shortage, 8) ' Append to the newly created text file textfile.writeline "<BR>" textfile.writeline "<BR>" textfile.writeline "<b>Name</b> :" & Request.form("name") textfile.writeline "<BR>" textfile.writeline "<b>Shift</b> :" & Request.form("shift") textfile.writeline "<BR>" textfile.writeline "<b>Wave</b> :" & Request.form("wave") textfile.writeline "<BR>" textfile.writeline "<b>Carton</b> :" & Request.form("carton") textfile.writeline "<BR>" textfile.writeline "<b>Location</b> :" & Request.form("location") textfile.writeline "<BR>" textfile.writeline "<b>License</b> :" & Request.form("license") textfile.writeline "<BR>" textfile.writeline "<b>SKU</b> :" & Request.form("sku") textfile.writeline "<BR>" textfile.writeline "<b>Quantity</b> :" & Request.form("quantity") textfile.writeline "<BR>" textfile.writeline "<b>Reason</b> :" & Request.form("reason") textfile.writeline "<BR>" textfile.writeline "<b>Comments</b> :" & Request.form("comments") textfile.writeline "<BR>" textfile.writeline "<b>Date/Time Received</b> :" & FormatDateTime(Now,4) textfile.writeline "<BR>" textfile.writeline "<HR>" ' Close the file and set object to nothing textfile.close Set fileobject = nothing '************************************************** '* EMAIL STATEMENT * '************************************************** Set Mail = Server.CreateObject("Persits.MailSender") Mail.Host = "SMTP1" ' Specify a valid SMTP server Mail.From = "someone@somewhere" ' Specify sender's address Mail.FromName = "Test Warehouse Shortage" ' Specify sender's name Mail.AddAddress "someoneelse@somewhere" 'email address that will receive form submission Mail.IsHTML = True Mail.Subject = "Test Warehouse Shortage" Dim mail_body mail_body = "Name: " & request.form("name") & "<br>" &_ "Shift: " & request.form("shift") & "<br>" &_ "Wave: " & request.form("wave") & "<br>" &_ "Carton: " & request.form("carton") & "<br>" &_ "Location: " & request.form("location") & "<br>" &_ "License: " & request.form("license") & "<br>" &_ "SKU: " & request.form("sku") & "<br>" &_ "Quantity: " & request.form("quantity") & "<br>" &_ "Reason: " & request.form("reason") & "<br>" &_ "Comments: " & request.form("comments") & "<br>" mail.body = mail_body & "Submitted IP Address: " & request.servervariables("REMOTE_ADDR") On Error Resume Next Mail.Send If Err <> 0 Then Response.Write "Error encountered: " & Err.Description End If End if %> <html> HTML FORM DATA IS IN HERE. </html> <% Function DoubleUpQuotes(strText) DoubleUpQuotes = "'" & Replace(strText, "'", "''") & "'" End Function %> Tag: Page Expires - even on Back button? Tag: 298347
  - 7
    - Problem sending mail (CDOSYS) Hi everybody, The following code for sending email (found on msn I think) works find when used in a .VBS file. I double click the file and the mail is send. When I use the same code in my .ASP application I get the following message: "The pickup directory path is required and was not specified" Where to specify that directory? As stated in the article http://www.aspfaq.com/show.asp?id=2418. I did 'web share' c:\inetpub\mailroot\pickup and got no result. It seems that sending email using a .VBS file does not use the same ressource as using a .ASP file even if the component is the same (CDOSYS)! How can'I solve this problem? here is the code i use in the .asp file: Dim iMsg Dim iConf Dim Flds Const cdoSendUsingPort = 2 set iMsg = CreateObject("CDO.Message") set iConf = CreateObject("CDO.Configuration") Set Flds = iConf.Fields With Flds .Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 1 ' local server .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "http://127.0.0.1" .Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 10 .Item("http://schemas.microsoft.com/cdo/configuration/smtpServerPort") = 25 .Update End With With iMsg Set .Configuration = iConf .To = "<to@x.com>" 'Enter a valid email address. .From = "<from@x.com>" 'Enter a valid email address. .Subject = "This is a test CDOSYS message (Sent via Port 25)" .HTMLBody = TableData .Send End With Set iMsg = Nothing Set iConf = Nothing Set Flds = Nothing Thank's in advance serge Tag: Page Expires - even on Back button? Tag: 298343
  - 8
    - MS SQL CE I have just installed and setup, but when I try to call the sscesa20.dll, I get a page cannot be displayed error. Also in event view I see a W#SVC error event ID 36 in the application log every time it try to call this dll. It says "the server failed to load the application /LM/W3SVC/3/Root, No such interface is supported" does anybody have any ideas as to why I'm getting this? Tag: Page Expires - even on Back button? Tag: 298339
  - 9
    - ms word What is the best way to generate a word-document with wbscript code? I have a text string I would like to save as a word document on the server. Any tutorials? or code examples? Thanks in advance, Christopher Brandsdal Tag: Page Expires - even on Back button? Tag: 298337
  - 10
    - Begginer guide for asp I am looking for some beginner guide for someone to learn asp - tutorials, examples etc Thanks -- Louise Woodward Opal Telecom Application Team Irlam Tel - 01612222443 lwoodward@opaltelecom.co.uk This communication together with any attachments transmitted with it ("this E-Mail") is intended only for the use of the addressee and may contain information which is privileged and confidential. If the reader of this E-Mail is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient you are hereby notified that any use, dissemination, forwarding, printing or copying of this E-Mail is strictly prohibited. Addressees should check this E-mail for viruses. The Company makes no representations as regards the absence of viruses in this E-Mail. If you have received this E-Mail in error please notify our IT Support Team immediately by telephone on 0845 456 9100 or via e-mail at support@opaltelecom.co.uk Please then immediately delete, erase or otherwise destroy this E-Mail and any copies of it. Any opinions expressed in this E-Mail are those of the author and do not necessarily constitute the views of the Company. Nothing in this E-Mail shall bind the Company in any contract or obligation. For the purposes of this E-Mail "the Company" means Opal Telecom Ltd. Please feel free to visit our website: www.opaltelecom.co.uk Opal Telecom Ltd (Registered in England & Wales No. 3849133) Brinnel Drive, Northbank Industrial Park, Irlam, Manchester M44 5BL. A member of the Carphone Warehouse Group of Companies Tag: Page Expires - even on Back button? Tag: 298329
  - 11
    - SQL Breaks ASP In one of our applications we have product id field which sometime contains ' When doing a search the sql breaks due to this. I cannot use replace function to remove this is there anything else I can do so that this works strProductId = 2277'778 sqlstr = " Select * from productdetails where id ='" & strProductId & "'" In this instance the sql breaks and gives me an error. Any suggestions how i can solve this Regards Tag: Page Expires - even on Back button? Tag: 298328
  - 12
    - Session Variables being cleared automatically We have a strange problem with our IIS server running on windows 2003 server. A small number of users complain that thier session expires midway and the application logs them out and even after logging in again the same problem exists. It only happens to about 3-5% of our users. Does anyone know why this happens? Tag: Page Expires - even on Back button? Tag: 298327
  - 13
    - Search Page ASP Hi All We are building an application with ASP/SQL Server and need to build a search page. I want to display lots of fields/textboxes on the search page to allow user to search any field by entering the search terms in any of the textboxes. I was thinking of using lots of if conditions to build the search string something like strSQL = "Select <<fieldnames>> from Contracts where Active= True " if request.form("contractno") <> "" then strSQL = strSQL & " and contractno ='" & request.form("contractno") & "'" end if Does anyone know of a better way to build the SQL string. Also any methods to speed up the query built will be much appreciated. I have already limited the total results that the query displays but adding " Top 20 " in the SQL string. Any other suggestions? Tag: Page Expires - even on Back button? Tag: 298326
  - 14
    - IIS5 to 6 migration trouble with ASP include directives We are poised to migrate about 600 ASP sites from a single IIS5 server to a new pair of IIS6 servers. However, it appears that all files with includes like:  will not work on IIS 6, it returns ASP 0126, include file not found. We have enabled parent paths, but I can't find any documentation that suggests that IIS 6 handles include directives differently than IIS 5. Has this in fact changed in IIS 6? We are trying to avoid a huge and messy "search and replace embedded text" exercise. Your thoughts greatly appreciated. TIA John Chertudi Tag: Page Expires - even on Back button? Tag: 298325
  - 15
    - possible to put 9 asp pages in one server,1 in remote , all under same domain? Hi, I have a site in israel which composed from 10 asp pages, and i want to put page number 1 in a different server in U.S.A since the page need to access a data base in USA. all pages must belongs to the same domain,since i am using IE userData behavior to persist data. thanks Tag: Page Expires - even on Back button? Tag: 298324
  - 16
    - How can I get the TextStream Object to write on Fat32? Hi Gang, I have so far been unable to get the TextStream Object to write on Fat32. I'm using Windows 2000 Pro Sp4. Scripts have write access and I even tried giving IUSR user level writes and still when I tried loading the ASP page it just hangs trying to create the file :(. <% Function WriteText(sPath, sText) Dim fso, TextFile Set fso = CreateObject("Scripting.FileSystemObject") Set TextFile = fso.CreateTextFile(sPath, True) TextFile.Write sText TextFile.Close End Function WriteText "Test.htm", "Testing, Testing, 1, 2, 3" %> Can anyone tell me what I'm doing wrong? This must be a security issue, but how and where? Thanks, Christian Blackburn Tag: Page Expires - even on Back button? Tag: 298307
  - 17
    - Access97 DB locks up the asp code at times I have an Access 97 DB called employees.mdb within a NT security type folder. Other users have write privileges to this document to make updates. This Access DB is only used for an ASP called employee.asp that's within the same folder. Here's the connection string example: <%@ Language=VBScript %> <% Dim my_conn, rs ConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("employees.mdb") Set my_conn = Server.CreateObject("ADODB.Connection") my_conn.Open ConnString set rs = server.CreateObject("ADODB.Recordset") %> This asp has been working without major problems for about 2 years. On most occasions, a user can open the Access DB, make changes and close it without any problems. However, on two occasions, a problem has occurred after a user opened the Access DB. My only guess is that someone accesses the employee.asp, which queries the Access DB when the Access DB is opened and being changed. Once this occurs, the employee.asp delivers an error code and complains about the connection line of "my_conn.Open ConnString". Any idea why this is happening? To correct the problem, I can just rename the employees.mdb to another name like employees1.mdb and then change connection string in the employee.asp to "ConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("employees1.mdb")", from employees.mdb Anyway, I would like the users to still have the ability to be able to modify the MS Access DB if possible so that I don't have yet another thing to do. Any thoughts? Thanks Tag: Page Expires - even on Back button? Tag: 298297
  - 18
    - SELECT CASE in ASP??? Dear friends, I am having a hard time understanding how to use a SELECT CASE in ASP. I have used it in VB but never in ASP scripting. Scenerio: I have 2 textboxes on a form that I have to allow entry to one or the other or Both at the same time. Now I tried to use an If ElseIf but it got too hard to track, so now I am using a SELECT CASE Statement. TEXBOX1 named strEnglish TEXBOX2 named strFrench My code: <% strEnglish=Request.Form("strEnglish") strFrench=Request.Form("strFrench") Select Case Then I have no idea how to go from here, because I have 2 input textboxes to follow. I found this example but I do not know how to apply it to my situation as I have to folow 2 textbox entries. <% UserName=request.form("UserName") Select Case UserName Case "Kathi" Msg = "You deserve a break. Take the day off!" Case "JD","Anne" Msg = "Don't forget to call Kathi today!" Case Else Msg = "Do I know you?" End Select response.write Msg %> Can someone please help me out, a known tutorial, perhaps an example or just plain good ole help please?? Thanks in advance, ~Newbie Tag: Page Expires - even on Back button? Tag: 298265
  - 19
    - Secure Page/Reg/Login Process Flow Which of these scenarios is better: A -- User Registers and is returned to the login screen to test his new username ie (email address). A login script checks user name against database. and asigns him a cookie id with an expiration date 30 days in the future from Date(Now). He is automaticaly redirected to his initial requested target URL. B -- User registers and is immediately sent to the Page he initially requested. At the registration page a cookie is also initialized with an expiration date and his prospsect database id. A? or B? Secure Page ------------- Test for cookies Enablment/Turned On (Yes) If cookie present, test for Cookie Prospect ID. No - Send back to login page Yes - Depost Current URL in the UserPath table...Now let him view page (No) 1. A. Send User to [A] Login Screen and force him to login. Or 2. Inform him he can go no further until he enables cookies. Sorry if this seems obvious, but I am concerned about where I place the burden of the database code (sql server Sps) and where exactly I should initialize the cookies and what I should do exactly to degrade appliation if user does not have cookies. Thanks Jason Tag: Page Expires - even on Back button? Tag: 298260
  - 20
    - Cant get ADO running under IIS I have a new W2K3 box running IIS Is there anything I have to install in order to use ADO? When I perform the following Set Connection = Server.CreateObject("ADODB.Connection") Connection.Open "mydsn" I get the error Provider error '80004005' Unspecified error Tag: Page Expires - even on Back button? Tag: 298259
  - 21
    - Read cookie expiry date? How does one read and write the cookie expiration date. At the moment my code is returning a value BUT a garbled value: '//Write cookie... Response.Cookies("Propsect").Expires = Date() + 1 '//Read cookie... ExpDate = Request.cookies("Propsect") Response.write "Prospect expiry date: " & expDate & "<br>" Result: u%5Fname=k ? Any ideas? Thanks Jason Tag: Page Expires - even on Back button? Tag: 298257
  - 22
    - How do I enable ASP on a W2K3 box I hava a new Windows 2003 box running IIS When I try and display an asp page it says page not found but the page is there. I've checked the settings in IIS - I have execute permissions script only. What do I have to do to allow ASP to run? Thanks Tag: Page Expires - even on Back button? Tag: 298253
  - 23
    - script for you Hey you can get a very good script at http://www.virtualpromote.com/tools/website-search/ The interface is totally customizable (just a single .html file). We'll even spider your website for you, to help you create the database! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Page Expires - even on Back button? Tag: 298247
  - 24
    - looping question ok.. here is my script <% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("/singlestour/fpdb/singles_tour.mdb") SET oRS= Server.CreateObject("ADODB.Recordset") strSQL = "Select username, total_score from current order by total_score desc" SET oRS= Conn.Execute(strSQL) Const MAX_COLS = 2 Dim iCol, username, total_score Response.Write "<table border='1'>" Do While not oRS.Eof iCol = 0 Response.Write "<tr>" Do While iCol < MAX_COLS If oRS.Eof Then username = " " total_score = " " Else username = oRS("username").value total_score = oRS("total_score").value oRS.moveNext End If Response.Write "<td>" & username & "</td>" Response.Write "<td>" & total_score & "</td>" Response.Write "<td>""against""</td>" iCol = iCol + 1 Loop Response.Write "</tr>" Loop Response.Write "</table>" %> and the display looks like this http://www.gig-golf.com/singlestour/scores.asp but i want it to look like this http://www.gig-golf.com/singlestour/scoresexample.asp i am trying how to learn how to put html into asp.. but the main thing i want to get rid of, is having the extra column on the right that says against... i just want it in the middle.... any ideas?? Thanks Jeff Tag: Page Expires - even on Back button? Tag: 298246
  - 25
    - Cookies - Is this possible? Is it possible for a user to enable permanent cookies but disable session cookies.....this seems like a contradition yet this is what I appear to be reading in online articles? Tag: Page Expires - even on Back button? Tag: 298242

Hi All!

At the moment, I have this in the footer section of my login protected
pages:
<%Response.Expires=-1%>

But I notice this doesn't prevent me from being able to press 'Back' after I
have logged out and view the same content - content I should not view if I
have logged out! How do I force the page to expire then?

Any advice would be most welcome!

Rob
:)

Top

Re: Page Expires - even on Back button? by Ray

Ray
Wed Aug 11 08:24:22 CDT 2004

This code works for me in such situations:

http://www.aspfaq.com/show.asp?id=2022

Ray at work

"Robert Mark Bram" <none> wrote in message
news:411991bd$0$24139$afc38c87@news.optusnet.com.au...
> Hi All!
>
> At the moment, I have this in the footer section of my login protected
> pages:
> <%Response.Expires=-1%>
>
> But I notice this doesn't prevent me from being able to press 'Back' after
> I
> have logged out and view the same content - content I should not view if I
> have logged out! How do I force the page to expire then?
>
> Any advice would be most welcome!
>
> Rob
> :)
>
>
>

Top