Programming Forums > Web Development and Design > ASP

mann95 · Dec 30th, 2005, 11:19 AM

Hi guys

I am trying to add a shopping cart to my website, so far I have managed to create a page which will insert items into a table called cart within my database. However I am getting an error message with the page I have created to allow users to view items within their cart. The error I am getting is:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/n0253071/viewcart.asp, line 14

sql="SELECT * FROM Cart, Books WHERE Cart.BookID = Books.BookID AND Cart.user_id LIKE '" & UserNo & "'";
---------------------------------------------------------------------------------------------------------------------------------------------------------^

At the moment all I want the cart to display is the user_id from the cart table where it matches that stored in cookie and where BookID is the same in both the books table and cart table. I am unsure if I constructed the join correctly.

My code for this page is:

(Toggle Plain Text)

<%
set UserNo = Request.Cookies("Name2")
response.write(UserNo)
%>

<%
set BookNo = Request.QueryString("BookID")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("\n0253071\db\products.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT Books.BookID FROM Books, Cart WHERE (Books.BookID = Cart.BookID) AND (Cart.user_id='" & UserNo & "')"
rs.Open sql,conn

response.write("<p><font face=verdana size=2>" & rs.fields("BookID") & "</font></p>")

rs.close
conn.close
%>

Any help is much appreciated.

Thanks

CM

Dec 30th, 2005, 11:19 AM	#1
mann95 Newbie Join Date: Dec 2005 Posts: 1 Rep Power: 0	Help needed with viewing shopping cart Hi guys I am trying to add a shopping cart to my website, so far I have managed to create a page which will insert items into a table called cart within my database. However I am getting an error message with the page I have created to allow users to view items within their cart. The error I am getting is: Microsoft VBScript compilation error '800a0401' Expected end of statement /n0253071/viewcart.asp, line 14 sql="SELECT * FROM Cart, Books WHERE Cart.BookID = Books.BookID AND Cart.user_id LIKE '" & UserNo & "'"; ---------------------------------------------------------------------------------------------------------------------------------------------------------^ At the moment all I want the cart to display is the user_id from the cart table where it matches that stored in cookie and where BookID is the same in both the books table and cart table. I am unsure if I constructed the join correctly. My code for this page is: (Toggle Plain Text) <% set UserNo = Request.Cookies("Name2") response.write(UserNo) %> <% set BookNo = Request.QueryString("BookID") set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("\n0253071\db\products.mdb")) set rs=Server.CreateObject("ADODB.recordset") sql="SELECT Books.BookID FROM Books, Cart WHERE (Books.BookID = Cart.BookID) AND (Cart.user_id='" & UserNo & "')" rs.Open sql,conn response.write("<p><font face=verdana size=2>" & rs.fields("BookID") & "</font></p>") rs.close conn.close %> <% set UserNo = Request.Cookies("Name2") response.write(UserNo) %> <% set BookNo = Request.QueryString("BookID") set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("\n0253071\db\products.mdb")) set rs=Server.CreateObject("ADODB.recordset") sql="SELECT Books.BookID FROM Books, Cart WHERE (Books.BookID = Cart.BookID) AND (Cart.user_id='" & UserNo & "')" rs.Open sql,conn response.write("<p><font face=verdana size=2>" & rs.fields("BookID") & "</font></p>") rs.close conn.close %> Any help is much appreciated. Thanks CM

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > ASP

Help needed with viewing shopping cart