I really Cannot understand what you are trying to do. Where does your SKU value is coming from ? Do you want a List of SKU's or do you want to get details for A Given SKU ?
If you Could explain the big picture a little bit, maybe able to help you. cheers Kuminda Chandimith Sr. Technical Consultant Ducont.com FZ-LLC Tel: + 971-4-3913000 Ext 237 Fax: +971-4-3913001 http://www.ducont.com -----Original Message----- From: "Rob Lamb`\" <[EMAIL PROTECTED]> [mailto:"Rob Lamb`\" <[EMAIL PROTECTED]>] Sent: 20 August 2002 11:50 To: ActiveServerPages Subject: Defining a recorset as a variable Hi I need to define a recorset as a variable. I am really stuck and cant get it right. If I hard code the product number in I dont have a problem but I need each product to have its unique number. I have connected to the database with an ADODB connection. Here is ny existing code please can someone advise me as what to do! <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Option Explicit Response.Buffer = True Dim Cat, SubCat, header, SKU Cat = Request.QueryString("Cat") SubCat = Request.QueryString("SubCat") SKU = I need the record value here Dim Conn, RS, cnpath, SQL Set Conn = Server.CreateObject("ADODB.Connection") Set RS = Server.CreateObject("ADODB.RecordSet") cnpath="DBQ=" & server.mappath("/database/instant.mdb") Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath & ";pwd=******" %> Thanks Rob --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
