cannot have the result page2 to display the record submited from the first page
Thank you
> and the problem is?
>
> -----Original Message-----
> From: jhd67@v... [mailto:jhd67@v...]
> Sent: Thursday, December 05, 2002 4:25 PM
> To: ASP Databases
> Subject: [asp_databases] Checkbox
>
>
> i am trying to compare two Cars once two or three checked you click
> submit, and comapre them: here is my first page:
>
> If Request("Checkbox") <> "" Then
>
> Set oRs =3D cn.Execute("SELECT * FROM CarID WHERE Checkbox =3D -1")
>
> END IF
>
>
>
> 'while not oRs.EOF
>
> response.write "<a href=3D'showdetails.asp?CarID=3D" &server.urlEncode(oRs
> ("CarID"))& "'>" &"<input name=3DCheckbox type=3Dcheckbox value=3D(oRs(CarID)
> >"&oRs("Year")& "</a>&oRs("Model")& " " &oRs("State")&
> Count =3D Count + 1
>
> oRs.MoveNext
>
> Loop
>
> %>
>
> -------------------------------------------------------------------------
>
>
>
> Second page:
>
>
>
> <%
>
> Dim Rscomapre
>
> Dim Rscomapre_numRows
>
>
>
> Set Rscomapre =3D Server.CreateObject("ADODB.Recordset")
>
> Rscomapre.ActiveConnection =3D MM_autofindtwo_STRING
>
> Rscomapre.Source =3D "SELECT * FROM cars"
>
> Rscomapre.CursorType =3D 0
>
> Rscomapre.CursorLocation =3D 2
>
> Rscomapre.LockType =3D 1
>
> Rscomapre.Open()
>
>
>
> Rscomapre_numRows =3D 0
>
> %>
>
> <html>
>
> <head>
>
> <title>Untitled Document</title>
>
> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-1">
>
> </head>
>
>
>
> <body>
>
> </body>
>
> </html>
>
> <%
>
> Rscomapre.Close()
>
> Set Rscomapre =3D Nothing
>
> %>
>
>
>
> Thank you
>
>
------------------------------------------
Faites un voeu et puis Voila ! www.voila.fr
View Cart
