Help with Error message
I am reusing a code that has been already working fine in another part of our website.
I am getting the following error message:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'CustomerID ='.
/test/ins_VIPPuserlinks.asp, line 183
This is the statement where the problem is:
user_id = session("user_id")
CustomerID = request("CustomerID")
set rs = cn.Execute("SELECT Supplier, Web_Address FROM VIPP WHERE CustomerID = " & CustomerID)
if not rs.EOF then
Supplier = rs("Supplier")
VIPP_URL = rs("Web_Address")
NOTE: Customer ID is an AutoNumber in my VIPP table and Number in my User_Links table.
Code from Links page to add link to favorits:
<% if session("user_id") <> "" then %>[<A href='ins_VIPPuserlinks.asp?CustomerID=<% =CustomerID %>' class='labelTD'>add to favorites</A>]<% end if %>
I can't figure out where I am missing the missing operator...please HELP!