Hi,

I keep receiving the following error. Can anyone help :

Syntax error (missing operator) in query expression '[tblCartItems].[intCartID] ='.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression '[tblCartItems].[intCartID] ='.

Source Error:


Line 42:
Line 43: dbConnection.Open
Line 44: Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(System.Data.CommandBehavio r.CloseConnection)
Line 45:
Line 46: Return dataReader


The issue lies around the following select statement :

Dim queryString As String = "SELECT tblCartItems.intCartitemID, tblCartItems.intProductID, tblMake.strMake, " & _
        "tblProducts.strProductName, tblType.strTypeDetails, tblColour.strColour, tblCartItems.intQuantityOrder, tblCartItems.curSalePrice " & _
        "FROM tblType INNER JOIN ((tblMake INNER JOIN (tblColour INNER JOIN tblProducts ON tblColour.intColourID = tblProducts.intColourID) " & _
        "ON tblMake.intMakeID = tblProducts.intMakeID) INNER JOIN tblCartItems ON tblProducts.intProductID = tblCartItems.intProductID) " & _
        "ON tblType.intTypeID = tblProducts.intTypeID " & _
        "WHERE [tblCartItems].[intCartID] = " & Session("CartID") & " ; "

If I remark out the last line i.e. "WHERE [tblCartItems].[intCartID] = " & Session("CartID") & " ; "

the error disappears. However I still need to reference the CartID session object. I've tried combining the entire section of code, but the error remains. The issues lies around the part :


 = " & Session("CartID") & " ; "

I'm using asp.net 1.1 with vb2003 -

Thanks,

hi there...

are you sure you have something inside session("CartID"), b/c that the error you are getting. Maybe you are not filling the session variable properly or it have another name????

HTH

Gonzalo

I agree with gonzalo; are you certain that Session("CartID") contains a value? It seems very likely that the value is empty. I would step through the code and verifiy that the query string is what you expect it to be.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Thanks Both.

This is a checkout page and you're right that the cartID is blank. Therefore should I use an if statement to say if value is nothing......etc ?

Thanks,

Yes you could do:

if(Convert.ToString(Session("cartID")) == "")
{
     //do something
}
else
{
    //process order
}

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Thanks both - now got it working....