I am working on a shopping cart using ASP and an Access DB.  On the frist 
time through, the user selects an item and recipient and it is 
sucessfully added to the cart and DB.  If the user wants to keep shopping 
they can again select a recip and item but when the ASP page that 
processes the order gets called the second time I get a strange error:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (comma) in query expression '((([ORDER_HDR].[ORDER_NO])
=10199, 10199))'.

Which is strange for a couple reasons:

1.  The error this line is referring to only list the SessionID once 
where the error shows it appearing twice with a comma between:

'UpdateOrdHdrTime On Existing Order
		SQLTimeAppend = "UPDATE ORDER_HDR SET 
ORDER_HDR.ORDER_UPDATED =" & "'" & Date & "'"
		SQLTimeAppend = SQLTimeAppend & "WHERE ((([ORDER_HDR].
[ORDER_NO])=" & SessionID & "))"		
		RS.Open SQLTimeAppend, Conn, adOpenStatic, 
adLockOptimistic, adCmdText

2.  The exact same code works for a different page which runs fine.  The 
difference is the code I am working on is for shipping to many addresses 
and the cart that works is for shipping to one address only.

I have been spending countless hours trying to solve this error so if 
anyone could shed some light it would really make my day.

Thanks