getting a bizzare error on this page:
happens when there is nothing added to the cart. BUT if you add something to the cart and then remove it.. it shows you the cart as empty without a problem.
i get a syntax error which then refers to this line:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Set rsAddItem = Server.CreateObject("ADODB.Recordset")
Conn.ConnectionTimeout = 0
Conn.Open "dsn=paceprintscatalog;uid=paceprints;pwd=pace212prints;"
rsAddItem.Open "Select b.*, a.artistID AS artistID, a.firstname AS firstname, a.lastname AS lastname FROM paceprints.basket AS b, paceprints.stocklist AS s, paceprints.artists AS a WHERE b.printID = s.UID AND s.artistID=a.artistID AND b.basketID =" & Session("basketID"), Conn, 1, 3
%>
any ideas?
happens when there is nothing added to the cart. BUT if you add something to the cart and then remove it.. it shows you the cart as empty without a problem.
i get a syntax error which then refers to this line:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Set rsAddItem = Server.CreateObject("ADODB.Recordset")
Conn.ConnectionTimeout = 0
Conn.Open "dsn=paceprintscatalog;uid=paceprints;pwd=pace212prints;"
rsAddItem.Open "Select b.*, a.artistID AS artistID, a.firstname AS firstname, a.lastname AS lastname FROM paceprints.basket AS b, paceprints.stocklist AS s, paceprints.artists AS a WHERE b.printID = s.UID AND s.artistID=a.artistID AND b.basketID =" & Session("basketID"), Conn, 1, 3
%>
any ideas?