Hi,
I'm tring to pass a variable from my database to another page so I can do a query on the variable(member number)..
I saved the data in a variable and tried to pass it, but it doesn't work. here is my code.

***here I get the member info from the database

 mySQL = "SELECT memberemail, memberpassword, memberID, contractorID FROM memberinfo WHERE";
 mySQL = mySQL + " memberemail = '" + Request.Form("txtEmail") + "'";
 mySQL = mySQL + " AND memberpassword = '" + Request.Form("txtPassword") + "'";
 adoRecordSet = adoConnection.Execute(mySQL);




// Loop through recordset and write stock details out to page
  if( adoRecordSet.Eof == false )
   {
***here I am TRYING to save the contractorID number in the variable "contractID"(yes i declared this variable above as var contractID"

    contractID = adoRecordSet("contractorID");
    Response.Cookies("IsValid") = "Yes";
****the line below doesn't work when I put <%=contractID%>
    Response.Redirect("memberpage.asp?contractorID=con tractID");

any ideas?
thanks
Kathleen

Try something like :

Response.Redirect("memberpage.asp?contractorID=" & contractID)

or :

Dim myRedirectURL="memberpage.asp?contractorID=" & contractID
Response.Write(myRedirectURL)
' uncomment the following line once you are sure that the line above works.
'Response.Redirect(myRedirectURL)

above isn't vbscript

try this (including greg's remark; adding <%=...%> into somthing that is already vbscript does not work, it only works in plain html)

if not adoRecordSet.EOF then
contractID = adoRecordSet("contractorID");
Response.Cookies("IsValid") = "Yes"
Response.Redirect("memberpage.asp?contractorID=" & contractID)
end if

would the synatax be the same if i was using javascript? with the exception of using var instead of Dim?