passing data between 2 pages

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
    - Sign-up Hey! I am creating a little signup script and tus far i have run into problems with this line. This line inserts the users information that they entered from the form into the SQL database. Does anyone know what is wrong with this line? myconn.execute("INSERT regfreeup set signup = '" & Now() & "' , firstname = '" & first & "' , lastname = '" & last & "' , email = '" & email & "' , ordernum = '" & order & "', username = '" & user & "' , pass = '" & pass & "' , site = '" & site & "';") Thanks!! Tag: passing data between 2 pages Tag: 295648
  - 2
    - Use a recordset inside a Function? This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C45933.30136C80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm trying to use a recordset inside of a function but I'm getting an = "object required 'adoRS" error. =20 At the top of the page I create my recordset, ex: dim strConnection, adoCN, adoRS, strSQL strConnection =3D <Connection> Set adoCN =3D server.CreateObject("ADODB.connection") Set adoRS =3D server.CreateObject("ADODB.recordset") adoCN.Open strConnection adoRS.ActiveConnection =3D adoCN adoRS.CursorLocation =3D adUseClient strSQL =3D "SELECT ... " adoRS.open strSQL then further down the page I call a function GetRecords(). The function = looks like this: function GetRecords() adoRS.movefirst var1 =3D adoRS("field1") ...........etc end function I'd rather not have the whole recordset inside of the function since I = also use it on other parts of the page. What am I doing wrong? Thanks ------=_NextPart_000_0008_01C45933.30136C80 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.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2>I'm trying to use a recordset inside of a function = but I'm=20 getting an "object required 'adoRS" error.  </FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>At the top of the page I create my recordset, = ex:</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>dim strConnection, adoCN, adoRS, strSQL</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>strConnection =3D <Connection><BR>Set adoCN = =3D=20 server.CreateObject("ADODB.connection")<BR>Set adoRS =3D=20 server.CreateObject("ADODB.recordset")<BR>adoCN.Open=20 strConnection<BR>adoRS.ActiveConnection =3D = adoCN<BR>adoRS.CursorLocation =3D=20 adUseClient</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>strSQL =3D "SELECT ... "</FONT></DIV> <DIV><FONT size=3D2>adoRS.open strSQL</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>then further down the page I call a function=20 GetRecords().  The function looks like this:</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>function GetRecords()</FONT></DIV> <DIV><FONT size=3D2>    adoRS.movefirst</FONT></DIV> <DIV><FONT size=3D2>    var1 =3D = adoRS("field1")</FONT></DIV> <DIV><FONT size=3D2>      =20 ...........etc</FONT></DIV> <DIV><FONT size=3D2>end function</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>I'd rather not have the whole recordset inside of = the function=20 since I also use it on other parts of the page. What am I doing=20 wrong?</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Thanks</FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C45933.30136C80-- Tag: passing data between 2 pages Tag: 295640
  - 3
    - ADODB.RecordSet, RecordCount always return -1 Hi, I have an ADODB.RecordSet that RecordCount alway return -1 and this RecordSet is plenty of record! R.RecordSet = -1 R.eof = False R.BOF = False Is the cursor is lost somewhere? How can I do to get the number of record in the result set? Thank you in advance serge Tag: passing data between 2 pages Tag: 295621
  - 4
    - Session Variable in a Javascript Popup I have a session variable set on my main page which works fine, I also have a popup window called from a text link via javascript. For some reason the session variable is not available on the popup window. Is this normal? Tag: passing data between 2 pages Tag: 295611
  - 5
    - Crawl a site Is it possible to crawl a site using ASP & XML HTTP? I know you can hit one link, but how can you go through each link in a page and validate that it returns 200? Tag: passing data between 2 pages Tag: 295603
  - 6
    - Get Username of a domain user How can I get the domain, username and PC network name (Win 2000 Pro & Win XP Pro PC's) of the current logged on user (logged onto a domain and access an intranet page, Window 2000 server running IIS) and put this automatically in a textbox in an webpage. Can this be done with asp & VB? I basically want to automatically populate a username field with the users logon so the do not need to type it themselves, leading to type errors. Thanks, Jach Tag: passing data between 2 pages Tag: 295601
  - 7
    - How? Send Same Email as HTML *or* Plain Text Hello. I'm looking for a simple way to do the following: We have a database that serves-up content to a website. Some of those items are events, some are news articles. They're stored in the DB as formatted HTML so ASP just drops them right into a page shell. Now, we want to send out a newsletter email containing some of those items. No problem sending as HTML. However, some of the members want just plain text. Is there some magic method in CDO that can automatically convert HTML to plain text? Or, is there some existing VBScript code out there that can do this? BTW, the environment is IIS 5.x (Windows 2000), Classic ASP, and CDO. Thanks... Tag: passing data between 2 pages Tag: 295595
  - 8
    - What's wrong with this? Hi all, I've got this snippet which is not working: <% Dim tDATA Dim oConn Call Connect(oConn, "") Set tDATA = Server.CreateObject("ADODB.Recordset") tDATA.Open "SELECT * FROM MyTable WHERE id = " & CLng(Request.QueryString("id")), oConn With tDATA If Not tDATA.EOF%> <p><strong><%=tDATA("name")%></strong><br /> </p> <font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><%=tDATA("text")%> <%End If tDATA.Close Set tDATA = Nothing %> </font> Can anyone see the problem?? Thanks, Ivan Tag: passing data between 2 pages Tag: 295587
  - 9
    - PostField and Variable names Hi, I am new to ASP and I cannot figure out how to pass variable content in ASP. How to pass the variable sClientNo in the following redirect. Response.Redirect("AccessDenied.asp?ClientNo=sClientNo") thank you in advance serge Tag: passing data between 2 pages Tag: 295586
  - 10
    - Aspx return system.drawing.image Hi, I have aspx page, and this page go to another aspx i have that this second aspx return a image, how the first page can received the object system.drawing.image. My code is that: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here Response.Buffer = True Dim lImage As System.Drawing.Image lImage.FromFile(Request("Path")) Response.End() End Sub It's OK??? And how I can view the image in the first page?? Thanks Silvia Tag: passing data between 2 pages Tag: 295584
  - 11
    - Silvia Hi, I have aspx page, and this page go to another aspx i have that this second aspx return a image, how the first page can received the object system.drawing.image. My code is that: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here Response.Buffer = True Dim lImage As System.Drawing.Image lImage.FromFile(Request("Path")) Response.End() End Sub It's OK??? And how I can view the image in the first page?? Thanks Silvia Tag: passing data between 2 pages Tag: 295583
  - 12
    - Caching images & ASP pages I've had some periodic problems on certain (intranet)servers where IIS seems to be caching thing in an unexpected way, or is server cached pages where new content is expected. The first situation is where we have a standard Top + Left + Content framset; the left frame contains a menu which shows standard options - when the user logs in, extra menu options are available to them, depending on their priveleges. The menu is generated from a DB in ASP, and when the user logs in, Javascript is used to reload the page in the left frame - eg. re-generate menu based on logged-in user. This used to work on all servers, but at some point in time I found that people were logging in but were stuck with the standard menu. If we right-clicked in the menu and chose refresh, often the correct (eg expanded) menu would be shown. I'm not sure where the problem is IIS or could be controlled in ASP... The second problem is on my development machine; when I browse to my development copy of the intranet, I dont get the icons for each menu item. However, when I browse to the live Intranet system, the correct graphics are shown. Screenshots: My machine - http://www.brightnorth.com/news/menu1.gif Normal site - http://www.brightnorth.com/news/menu2.gif I'm assuming that this one is purely an IIS problem. Any thoughts? Tag: passing data between 2 pages Tag: 295579
  - 13
    - Session.LCID? We are translating our web shop to Slovak but when I use Session.LCID=1051 for slovak do I get the error "Invalid LCID". The same shope use Swedish = 1053, Norwegian(Bokmal) = 1044, English = 1033 and no problems. What do I have to do in order to get Slovak to work on the same server? Regards, Hagge Tag: passing data between 2 pages Tag: 295578
  - 14
    - attribute value in a html button The code <input type="button" name="btn" value="ok"> will produce a html button with caption ok and value ok. The problem is the width of button is dependent on the length of attribute value. And I do the following, which is not a good solution. <input type="button" name="btn" value=" ok "> The problem is if I want to get the button's value: Request.Form("btn"), then I need to trim the data. any ideas?? Tag: passing data between 2 pages Tag: 295568
  - 15
    - Problem with Radio Buttons I have a form with a single named multiple valued radio button, as it should be, i have got an error for 2nd time on my site, the error shows that the value of radio button submitted is multiple i.e. "17, 18", i can't figure it out how, there is no problem in the code. it has just one INPUT field for this variable..... ? Tag: passing data between 2 pages Tag: 295566
  - 16
    - reference the document object? Is it possible to reference a Web page title (Document.Title) in an asp page? For example, <% Document.Title%> embedded in the body of an asp page? This would allow a server side include that changes a header at the top of the page, based on the page Title. Thanks, Jim Tag: passing data between 2 pages Tag: 295562
  - 17
    - post form data to a modal dialog window I reposted this question because I really want to accomplish this task. Please advise!! I want to post the form data (http://server/page1.asp) to a modal dialog window (http://server/modaldialog.asp) with a desired height 200px by width 200px. Here's my attempts and problems: Attempt #1) In http://server/page1.asp, it has code <form action="http://server/modaldialog.asp" method="post" target="_blank"> In http://server/modaldialog.asp, it has code <body onBlur = "self.focus()"> It can produce modal dialog window modaldialog.asp, but I want to set the width and height of modaldialog.asp. Attempt #2) var sReturn = window.showModalDialog("modaldialog.asp", params, "dialogHeight:200px; dialogWidth:200px;"); This is the effect I want. But this is not posting the form data to modaldialog.asp. Any workarounds to my problems?? Thanks!! Tag: passing data between 2 pages Tag: 295559
  - 18
    - submit button with image question In the following code, I have 2 questions regarding submit button with image. 1) Does this code <input type="image" name="populate" src="populate.gif"> behave the same as an HTML submit button with image populate.gif? When I click p1 or p2 button, it will post the page to process.asp. 2) When I check the checkbox, I want the image in submit button change from populate.gif to validate.gif. Unfortunately, the code InputForm.p2.src = "validate.gif"; doesn't work. But InputForm.p1.value = "validate button"; is working for a regular HTML submit button. Any workarounds? Please advise. Thanks!! <html> <head> <script type="text/javascript"> function cb_onClick() { if (InputForm.C1.checked == true) //NOT InputForm.C1.value == "on" { InputForm.p1.value = "validate button"; InputForm.p2.src = "validate.gif"; } else { InputForm.p1.value = "populate button"; InputForm.p2.src = "populate.gif"; } } </script> </head> <body> <form name="InputForm" method="POST" action="process.asp"> <p><input type="checkbox" name="C1" onClick="cb_onClick()"></p> <p><input type="submit" name="p1" value="populate button"> <p><input type="image" name="p2" src="populate.gif"> </form> </body> </html> Tag: passing data between 2 pages Tag: 295558
  - 19
    - response.cookie in session_onstart event and IE 6.0 cookie acceptance When I set a cookie in global.asa in the sub session_onstart, even if I have "privacy" in IE 6.X set to "block all cookies" the cookie is still set, and I can get it on other pages. I can't find an article that addresses this as a specific issue. Why does the browser get the cookie when it is set in the session_onstart event even when I have "block all cookies" set? Tag: passing data between 2 pages Tag: 295554
  - 20
    - asp script for forms result I am struggling to come up with a way to save a forms' results, to a text file, but the name of the text file comes from the input of a user name on another forms... ex. john doe enters pg1 & enters his name in a space on the page (form) . this links him to the next page, pge_form. I need the results of page_form to be named johndoe.txt Thank you very much for any help at all... Tag: passing data between 2 pages Tag: 295552
  - 21
    - ASP book recommendation??? I am just starting to learn ASP and would like to pick up a good book. I have been through ASP Programming for the Absolute Beginner and got some ideas, but it only discussed local servers running PWS or IIS - nothing about working with an internet ASP hosting service. It also lacks good descriptions of syntax. I have also looked at the O'Reilly ASP in a Nutshell, but it seems like a reference for more advanced users, not a learning tool. I have some Javascript background, but right now I'm trying to pick up ASP and VBScript at the same time so a book that has an ASP/VBScript focus would be ideal. thanks, BDT Tag: passing data between 2 pages Tag: 295541
  - 22
    - help with Server.CreateObject("Scripting.FileSystemObject") I am just beginning with asp and have gotten an error that I need some help with. I posted a pair of files to an online ASP host server. The files are in the same directory; one is readfile.asp which should open the other which is a simple text file - newText.txt . Here is readfile.asp : <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Reading Text Files</title> </head> <body> <b>An Example of reading a .txt file and hopefully adding some formatting.</b> <hr> <% set tfile=Server.CreateObject("Scripting.FileSystemObject") set TFStream=tfile.OpenTextFile("newText.txt") textprinter=TFStream.readall() %> <p> <%=textprinter%> </body> </html> Here is the error msg that results: Microsoft VBScript runtime error '800a0035' File not found /Test-BDT/readfile.asp, line 13 Where line 13 is: set tfile=Server.CreateObject("Scripting.FileSystemObject") MY Qustions: -Why didn't it work? -How do I get it to work? (I suppost I could do a server side include, but I'd like to figure out the how& why of this code first. -I may have a path problem. Can someone point me to a good reference about referencing path in this code? thanks a lot, BDT Tag: passing data between 2 pages Tag: 295538
  - 23
    - Favorite Scripting shortcuts What's your favorite bit of "short-cut" code that you use? One of my favorite shortcuts I'll use when coding a page is to create a sub along the lines of the following: Sub Print(myText) Response.Write myText & vbcrlf End Sub And then I use Print instead of Response.Write thru my code. I do this for several reasons: A) I'm an old-skool coder, and I started coding back in the days when you wrote to the screen with "PRINT" B) It's shorter than doing Response.Write [insert string here] & vbcrlf for every instance where you want to write to the client. C) It's easier to use for debug purposes: If for example I want to do a time-trace to see where a slow-down is occuring, I'll change the code to Response.Write "" & myText D) If I want to adapt a particular snippet of code for client-side, I'll usually just have to copy/paste (along with minor changes), and include the Print sub, except with Response.Write changed to Document.Write. Tag: passing data between 2 pages Tag: 295533
  - 24
    - ASP vs ASP.NET Complete newbie questions! Why use ASP instead of ASP.NET? Why use ASP.NET instead of ASP? I am assuming that ASP.NET has all of the "features" of ASP plus a whole lot more, is more up to date and more future proof, so would prefer that some work I want undertaken is written in ASP.NET. Why would a company I am dealing with prefer to stick with standard ASP? They have said that ASP.NET is not proven and so ASP is more reliable. They have also said that they are more experienced with ASP than ASP.NET but wouldn't the "language" be the same? I am a complete novice to this so would like some impartial comments on whether I should insist they use ASP.NET. Richard Tag: passing data between 2 pages Tag: 295518
  - 25
    - Calling a Block of ASP from Another I have a block of ASP code (enclosed in <% .. %>). How can I call that piece of code from another piece of similar code? And can the code be in any order on the page for it to work? Thanks Tag: passing data between 2 pages Tag: 295516
- Next
  - 1
    - ASP issue Can a ASP work like a CGI.(Email Scripts) ? Can a ASP script for email will work, if a Script is on 1 server and form(html.form) is on another server and a thank you page is on 3rd server. Like if u don't know about a CGI there are many websites who give you permission to use their script by editing little bit in yours form and place them on yours server website, there are number of site. And 1 more thing I want to ask is if some one use a windows server he have a form html on that server, can he run asp script which is on Linux server to get form result on his desired email id. Tag: passing data between 2 pages Tag: 295511
  - 2
    - HTTP Compression - Urgent i have activate the HTTP compression for static and dynamic files, the problem is that iis or web browser is caching the response of the asp page... and allways display the same. Example: <% Response.Write "Time: " & Time() %> allways display the same time, i need to do a manually Refresh (and that is not what i want...). how can i fix the problem Thanxs Tag: passing data between 2 pages Tag: 295510
  - 3
    - Unicode Character Problem Hi Folks, I am having a problem with a forms entry using Unicode characters, specifically "smart-quotes". Under Microsoft PWS and MS-SQL 7.0 it works fine and I get the Unicode characters, such as smart-quotes, being written and read form the database. However, if I use the same code using Apache, Linux and SunONE ASP the Unicode characters don't work! Here is an example of the pages: http://www.oldham.gov.uk/mccall/smart.jpg http://www.oldham.gov.uk/mccall/broke.jpg Our developers have tried to change the character set to correct the problem, but have been unable to get it working and its currently using a work-around at the moment to specifically detect the characters we want. Can anyone suggest what the problem is, and how to correct it? Thanks, Andrew McCall Tag: passing data between 2 pages Tag: 295509
  - 4
    - HELP.. ERROR: Unable to relay for user@mail.com Can someone please help!! This is driving me nuts... I keep getting the following error when I run the send mail script below. I think it might be because I don't have the smtp server configurered properly or because I have to make a change on our exchange server??? We are running IIS 5 on Win2K server and using Microsoft Exchange Server 5.5 can someone please tell me how I solve this! Thanks Error: Email send failed: The server rejected one or more recipient addresses. The server response was: 550 5.7.1 Unable to relay for user@mail.com <% mailComp = "CDOSYS" smtpServer = "SMTP01" fromAddr = "user@mail.com" if mailComp = "CDOSYS" then set cdoMessage = Server.CreateObject("CDO.Message") set cdoConfig = Server.CreateObject("CDO.Configuration") cdoConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 cdoConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserver") = smtpServer cdoConfig.Fields.Update set cdoMessage.Configuration = cdoConfig cdoMessage.From = fromAddr cdoMessage.ReplyTo = replyTo cdoMessage.To = recipients cdoMessage.Subject = subject cdoMessage.HtmlBody = body on error resume next cdoMessage.Send if Err.Number <> 0 then SendMail = "Email send failed: " & Err.Description & "." end if set cdoMessage = Nothing set cdoConfig = Nothing exit function end if %> Tag: passing data between 2 pages Tag: 295506
  - 5
    - how to check user account and password in another domain controller? By using <authentication mode="Forms" > in web.config, we can create self-designed login page, but how to check user's account and password is vaild in another domain controller? Does <authentication mode="Windows"> can have self-designed login page? Tag: passing data between 2 pages Tag: 295505
  - 6
    - cannot find .net framework directory: system error &H80131700& Hi Guys, I have installed Visual Studio.Net on my windows XP machine. First after installing all the required WCU, then installed the Visual Studio.Net. All set up was completed successfully. then when i try to create a Web Application i get the error "project 'ABC' could not be opened because the microsoft visual basic .net compiler could not be created. please re-install visual studio" So i uninstall the entire setup and reinstall it again. Now i get the error: "project 'webapplication4' could not be opened because the microsoft visual basic .net compiler could not be created. cannot find .net framework directory: system error &H80131700&" Can you please assist with this and let me know how i need to proceed further for a successful installation of Visual Studio.Net 2003. Appreciate your help on this! Thanks, Vamsi. Tag: passing data between 2 pages Tag: 295504
  - 7
    - Simple Insert into Table? Can anyone give me some simple sample code to insert a value from a session variable into a table in a SQL DB. I am using Dreamweaver MX04 and this works fine with their built in procedures, but I need to modify one to do dual inserts and I am not knowledgeable enough to modify the code. Tag: passing data between 2 pages Tag: 295503
  - 8
    - Pages are not refreshed on client machines Hi all I have a web site where I use cookies to navigate between the pages. The cookie is his id no which is nothing but his staff id no. All most all pages are dynamic and connected to sql server 2000 through ADOs. My problem is : if any one logs in and enter bowse the pages and goes back uses other log in his old page is displaced rather than new one, untill he explicity uses the refresh button. Once he does that , it is working. Iam using javascript menus to navigate between pages.Previously when menus are not there pages were working fine. Now I would like to to see that the cached pages expire after he comes out of page . how to do that. Thank u so much in advance R.D.CHETTY Tag: passing data between 2 pages Tag: 295499
  - 9
    - Is it possible to change the request order of fields on a form? For an auto-generated form I have the following order of fields: savevalues userid productcode PrintColour1_1 Colour1_1 Quantity_1 " " " " " " " " PrintColour1_5 Colour1_5 Quantity_5 I was hoping to get them from the request object by rows, but they come out as the following (example values included): savevalues = yes userid = 4029 productcode = 46BN PrintColour1_1 = Black PrintColour1_2 = PrintColour1_3 = PrintColour1_4 = PrintColour1_5 = Colour1_1 = Red Colour1_2 = Colour1_3 = Colour1_4 = Colour1_5 = Quantity_1 = 5 Quantity_2 = Quantity_3 = Quantity_4 = Quantity_5 = Is there any way of changing this order as I think it may make it easier to process the fields (which can change according to what the original form fields are.) Thanks. -- GIT Groupie : http://gitgroupie.timchuma.com The Twits Give Me the Shits : http://twitsgivemetheshits.timchuma.com My Photos : http://photos.timchuma.com Hong Kong Movie Reviews: http://hkmovies.timchuma.com Tag: passing data between 2 pages Tag: 295488
  - 10
    - ASP and session object (get type) I would like to be able to get the type of object that a session variable contains (for example, determine whether it is a string, integer, single precision floating point, ADODB.Recordset, etc...) I need to know this for a ASP <----> ASP.NET session management script I am writing. I would like to be able just to copy strings and numbers. I already have code that does this, but I don't want my script to blow up when it finds a recordset in the session object! Is there any easy way to detect the object type in ASP? Tag: passing data between 2 pages Tag: 295477
  - 11
    - session variable inconsistency Hi, I am experiencing a problem with recalling a session variable which stores whether a person is logged in to a "members only" section of a website. This area of the site has been working flawlessly for a couple of years under Windows 2000 server but now is very inconsistent following a recent upgrade to Windows server 2003. Following a login, the login info is passed to this asp page that checks an Access database for the user name and password: SET DbObject = Server.CreateObject ("ADODB.Connection") DbObject.Open "DSN=pseudoCAP1;UID=;PWD=" set rs = server.createobject("adodb.recordset") SET Rs = DbObject.Execute (SQL) If Rs.EOF Then Session("Authenticated") = 0 Response.Redirect ("unsuccessfulLogin.htm") Else Session("Authenticated") = 1 Session("user") = Request.Form("username") End If rs.close set rs = nothing DbObject.Close set DbObject = nothing response.redirect "main.asp" If a correct password and username is provided, the user is always forwarded to the main.asp member start page. I included a snippet of code while troubleshooting to print the value of the authentication session variable in the browser window to see if it was set (1=logged in, 0= not logged in). However about 50% of the time, the following error occurs with our access database and Authentication session variable is output as = 0: ADODB.Field error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. C:\INETPUB\WWWROOT\SUBMISSIONS\../include/functions.inc, line 4 The way that this page is written though, even if the record was not present (although it is when I open the database), the authentication should still be set to 1. Refreshing the main.asp page will often eliminate the ADODB error above and the session variable value of 1 will be returned. The rest of the time, authentication is OK and a value of 1 is output. However when the user goes to another page requiring authentication, they are redirected back to the login.html page because the authentication variable is once again set as zero! Could this be an IIS 6.0 specific problem (I do have session state enabled at default value of 20 min) ?? Or could there be some permissions problem related to a specific file (I have checked the database as well as the related files and they all seem OK)? Thanks, Geoff Tag: passing data between 2 pages Tag: 295476
  - 12
    - Corrupt files when using SSL download and ASP 3 My company has a web application for downloading and uploading of reports in MS Office formats. The application has been working fine until we added certificate for secure transfer. Now, when the files have been uploaded and then downloaded, I get an alert saying "select the encoding that makes your document readable". In the preview box, a line of ASP code (a line with a file include) is displayed and there after alot of squares and other unreadable characters. I am using the SA File-up components for upload and download of files. Any ideas? This was working file until SSL was added. Cheers, Jens. Tag: passing data between 2 pages Tag: 295474
  - 13
    - website is down because of ASP code Our web site sometime down with unknown reasons, someone can help me? I checked application log in event viewer: 1.Error: File confirmation.asp CreateObject Exception. The CreateObject of '(null)' caused exception C0000094. (But I didn't use ADO recordset session variable) 2.Error: File confirmation.asp Unexpected error. A trappable error (C000001E) occurred in an external object. The script cannot continue running.. (But I checked VBScript.dll version it is above 5.1, it is 5.6, it should not have formatnumber race condition problem) any clue? Thanks Betty Tag: passing data between 2 pages Tag: 295472
  - 14
    - SQL Query Causing Inifinate Output When I change the "aplink.withdrawn" to include a new field with a similar name "aplinks.pwithdrawn,aplinks.awithdrawn", the output in the web page is blank and un-ending. When I test this query against the Foxpro database, it works correctly. 'Good Query sql2="SELECT DISTINCT aplinks.partyno,attorney.*,aplinks.party_type,aplinks.partyname,aplinks. withdrawn FROM attorney,aplinks WHERE attorney.dktno LIKE '%" & case_no & "%' AND aplinks.dktno LIKE '%" & case_no & "%' AND attorney.attyno=aplinks.attyno ORDER BY aplinks.partyname ASC, aplinks.party_type ASC, attorney.principal DESC" ' NEW Query sql2="SELECT DISTINCT aplinks.partyno,attorney.*,aplinks.party_type,aplinks.partyname,aplinks. pwithdrawn,aplinks.awithdrawn FROM attorney,aplinks WHERE attorney.dktno LIKE '%" & case_no & "%' AND aplinks.dktno LIKE '%" & case_no & "%' AND attorney.attyno=aplinks.attyno ORDER BY aplinks.partyname ASC, aplinks.party_type ASC, attorney.principal DESC" *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! Tag: passing data between 2 pages Tag: 295471
  - 15
    - ASP's not opening Our ASP's stopped opening, and we gewt the error, page not found. Any ideas? Tag: passing data between 2 pages Tag: 295469
  - 16
    - Can I share Session variables across Applications? In one Application (2) the client is redirected to a Logon ASP in a = different Application (1). A Session Variable is made in Application 2 = which needs to be recognized in Application 1. Can I do that in Windows = 2000 SP3 IIS5 no .NET Framework? Thanks. --=20 George Hester __________________________________ Tag: passing data between 2 pages Tag: 295467
  - 17
    - ASP Security I am trying to prevent users from submitting HTML pages from their local machine to our website and I was wondering what the best way of doing this was. I was thinking about using the HTTP_REFERER server variable (to check where the user has submitted a page from) as a blanket fix however when you use the javascript document.location on a page the HTTP_REFERER is always blank, which makes that a flawed fix. I have seen other sites protect against this, so I know it can be done. Whats the best way. Thanks for listening. Tag: passing data between 2 pages Tag: 295465
  - 18
    - OpenTextFile never return Hi, I cannot use the OpenTextFile method, it's never return and I get no error message! Setting Response.Buffer=False, has no effect. No matter if I use it ForReading or ForWriting, it never return. In the following code, the problem occurs at line 3. aFileName = Server.MapPath("WEB_PROD.htm") set fs = server.CreateObject("Scripting.FileSystemObject") set fso = fs.OpenTextFile(aFileName, ForReading, False) s = ts.ReadAll ts.Close set ts = nothing Response.Write s any help will be appreciate. thank you in advance serge Tag: passing data between 2 pages Tag: 295463
  - 19
    - CreateObject in ASP page limit? I've made an ASP page that use a VB6 ActiveX EXE with a CreateObject. Initially, this page work fine. The objectâ??s reference created with the CreateObject are saved on a session variable for reuse it on many page. When many users call this page and many instance of the ActiveX EXE Object are created, the CreateObject command fails with a 429 error (ActiveX component can't create object). The class (in ActiveX EXE) are MultiUse, then only a single EXE are running. Terminating the EXE with Task Manager then the CreateObject will get to work again. There is a limit of use with Objects created? Any idea? Tag: passing data between 2 pages Tag: 295458
  - 20
    - Delete images from listview Hi, I have a program that capture images and put this into a listview (using imagelist), the problem is when I delete de image the listview, when do that and capture another image, the image painting in the listview is the image delete, I supose that the problem is that the image exist in the imagelist, in order to solve this problem I clear the imagelist and add all the images captured, but i have another problem now, some time when I delete a image, when do IO.File.Delete(gstrPathImage & "\" & lstrFile) say that the file is be using with another process. The code is: Private Sub cmdDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdDelete.Click Dim lIndexes As ListView.SelectedIndexCollection = ListViewImages.SelectedIndices Dim liIndex As Integer Dim lstrFile As String Dim liNumSelect As Integer = lIndexes.Count Dim i, j As Integer Dim lstrFiles(liNumSelect - 1) As String Dim lstrFilesRemove() As String Dim lstrFileRemove As String Dim liIndexRemove As Integer i = 0 For Each liIndex In lIndexes lstrFiles(i) = ListViewImages.Items(liIndex).Text i = i + 1 Next For i = 0 To lstrFiles.Length - 1 For j = 0 To ListViewImages.Items.Count If lstrFiles(i) = ListViewImages.Items(j).Text Then lstrFile = ListViewImages.Items(j).Text ListViewImages.Items(j).Remove() IO.File.Delete(gstrPathImages & "\" & lstrFile) IO.File.Delete(gstrPathImages & "\" & Microsoft.VisualBasic.Left(lstrFile, Len(lstrFile) - 4) & ".raw") ImageList.Images.Clear() liIndexRemove = 0 lstrFilesRemove = IO.Directory.GetFiles(gstrPathImages, "*.BMP") Dim lImage As System.Drawing.Image For Each lstrFileRemove In lstrFilesRemove lImage = lImage.FromFile(lstrFileRemove) ImageList.Images.Add(lImage) liIndexRemove = liIndexRemove + 1 Next lImage.Dispose() lImage = Nothing Exit For End If Next Next end sub Anybody know that is the problem?? Thanks Silvia Tag: passing data between 2 pages Tag: 295456
  - 21
    - Russian in ASP pages? Hi all, I would like to create a site which shows text in English or in Russian (depending on the user's choice). Problem is that I can't save the pages in Unicode (Unicode can contain Russian characters), because IIS can't handle Unicode ASP pages (correct, right?!). So how can I have normal (ASCII) ASP pages, which can show either text in English or Russian (charset Windows-1251)??? Thanks! Greetings, Steven Tag: passing data between 2 pages Tag: 295453
  - 22
    - adding values from a submitted form HI There, I am trying to total the value of some form fields I am referecing the form field with an inner loop, I am having a little trouble because the amount of fields returned is always different, how can I roll-up the total of the form fields (request.form("subtotal_"& i)) to get one final figure? Sean - Thanks in advance for your answer for i = 1 to Request.Form.Count if request.form("quantity_"& i) <> "" AND request.form("quantity_"& i) <> "0" then !-- inner loop dim j dim thetotalof for j = 1 to request.form("subtotal_"& i).count thetotalof = request.form("subtotal_"& i) response.Write thetotalof next !-- finish inner loop thecounter = thecounter + 1 response.Write "<tr><td>" & trim(stripQuotes(request.form("productid_"& i))) & "<input type=hidden name=productid_" & thecounter & " value='" & trim(stripQuotes(request.form("productid_"& i))) & "'></td><td>" & trim(stripQuotes(request.form("quantity_"& i))) & "<input type='hidden' name=quantity_" & thecounter & " value='" & trim(stripQuotes(request.form("quantity_"& i))) & "'></td><td>" & Application ("defaultcurrency") & " " & FormatNumberVal(trim(stripQuotes(request.form("subtotal_"& i)))) & "<input type='hidden' name=subtotal_" & thecounter & " value='" & trim(stripQuotes(request.form("subtotal_"& i))) & "'></td></tr>" end if next Tag: passing data between 2 pages Tag: 295450
  - 23
    - ASP problem with includes When I use an include file like this   my server gives an error of : Active Server Pages error 'ASP 0131' Disallowed Parent Path /test/module/VieBoard/main.asp, line 1 The Include file '..\..\cfig.asp' cannot contain '..' to indicate the parent directory. Tag: passing data between 2 pages Tag: 295444
  - 24
    - Reading Form values into a Scripting.Dictionary I have been trying to read values from a form into an array on a page without much success and was told to use a Scripting.Dictionary instead. There are a variable number of fields on the form as it is different according to which product is ordered (as are the fields that are used to create the record.) This is my first attempt: set OrderInfo = Server.CreateObject("scripting.dictionary") set OrderInfo("prodid") = Server.CreateObject("scripting.dictionary") set OrderInfo("userid") = Server.CreateObject("scripting.dictionary") OrderInfo("prodid") = lngProductID OrderInfo("userid") = lngUID For each x in Request.Form set OrderInfo("prodid")("userid")(x) = Server.CreateObject ("scripting.dictionary") OrderInfo("prodid")("userid")(x) = Request.Form(x) Next For each x in OrderInfo("prodid")("userid") Response.Write x & " = " & OrderInfo("prodid")("userid")(x) & "<BR>" & vbcrlf Next Thanks. -- GIT Groupie : http://gitgroupie.timchuma.com The Twits Give Me the Shits : http://twitsgivemetheshits.timchuma.com My Photos : http://photos.timchuma.com Hong Kong Movie Reviews: http://hkmovies.timchuma.com Tag: passing data between 2 pages Tag: 295443
  - 25
    - HTTP 500.100 I don't know anymore Hi I really don't know anymore how to solve this problem. I bought .NET thinking i can debug my way out of it but still no cigar. This very simple piece of code does not work: Now here some things before looking at the code: 1. In .NET and IE and IIS I've set all possible debugging options 2. I've set a watch at the beginning of this page, so that when .NET enters this page I can step the program 3. If I have the line: set test = cnn.Execute("INSERT INTO comments ('ghj', 'comment', 67)) in this code then .NET does not even let me step throught the program. It just immediatly give the error below. 4. If I have the line: cnn.Execute("INSERT INTO comments ('ghj', 'comment', 67)) in this code then .NET does not even let me step throught the program. It just immediatly give the error below. 5. I know I should not use c:\events.mdb but this was only a test. 6. with the cnn.Execute line ommited, the thing steps through the code but ofcourse does not work. 7. I know I can use the long way getting the data in the database, but damit I want to do it this way! <code> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <title>myweb</title> </head> <body> <% Dim cnn Dim strDBPath dim test Set cnn = Server.CreateObject("ADODB.Connection") strDBPath = "c:\events.mdb" cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";" cnn.Open set test = cnn.Execute("INSERT INTO comments ('ghj', 'comment', 67)) %> </body> </html> I get the error: The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. -------------------------------------------------------------------------- Please try the following: a.. Click the Refresh button, or try again later. b.. Open the localhost home page, and then look for links to the information you want. HTTP 500.100 - Internal Server Error - ASP error Internet Information Services If anyone can help me here I'd really be a happier guy. Tag: passing data between 2 pages Tag: 295442

Hi All,

I have a asp page created which pulls information from an access
database. One of the things it pulls from the database is the address.
I want to put a link on this page which when clicked will open a
smaller new window asking the user to input their address. Once they
input the address and hit submit, the 2 addresses, user inputted (as
starting point) and the one from database (ending point) needs to be
inputted such that a url is formed, leading to the directions page on
yahoo or mapquest or any other site.

My question is how do I take the ending address and pass it over to
this new page (using http_referrer???) and then construct the url to
the directions page.

Thanks in advance.
Mandeep

Top

Re: passing data between 2 pages by Bullschmidt

Bullschmidt
Wed Jun 23 18:09:13 CDT 2004

Here is a mapping querystring I've used before that hopefully might give
you some ideas:

<a
href="http://www.mapquest.com/maps/map.adp?country=US&addtohistory=&addr
ess=<%= Server.URLEncode(FamilyAddress) %>&city=&state=&zipcode=<%=
Server.URLEncode(FamilyZip) %>&homesubmit=Get+Map" target="new">

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
http://www.Bullschmidt.com
ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...

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

Top