saving search result??

Results 1 to 2 of 2

Thread: saving search result??

  1. #1
    Join Date
    Dec 1969

    Default saving search result??

    after a search in the database yield some can i save the result for future reference??? It looks like a shopping cart<BR>anyone can suggest how to do the shopping cart..

  2. #2
    Rob Guest

    Default RE: saving search result??

    After you pull your results from the db with a recordset you can save whatever data you want to variables and then pass them as you need to to other pages.<BR><BR>very simple eg<BR><BR>sSQL = "select onething, secondthing from table where blah = blah"<BR>adoRS.Open sSQL<BR><BR>var1 = adoRS("onething")<BR>var2 = adoRS("secondthing")<BR><BR>adoRS.Close<BR>Set adoRS = nothing<BR><BR>Rob

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts