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!

It looks like the customerID isn't making it into the query. You'll have to troubleshoot whether CustomerID = request("CustomerID") is working right, and work your way back to see where the customerID is getting dropped.

Peter

As you suggested I tried to trace back where the CustomerID gets dropped, but by now I am more lost than I was when I started looking for it. I uploaded the whole file into a textfile here:
http://cliq-on.com/test/vipp.txt

Can someone please point out mistakes for me?
Thanks

I took a look at that code, and I can't see what the problem is. Everything looks ok. Without being to actually witness the code running it's hard to say.

Can you take a look at the HTML of the page before you post it and get the error? Confirm that your hidden CustomerID field is getting populated correctly and that the action field is set right. Otherwise, there's little I can get out of looking at the code. Maybe you are getting returned bad data.

Peter