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 PROTECTED]
