Does anybody know what might be causing this error

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Microsoft OLE DB Provider for ODBC Drivers error 
'80040e14' 
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the 
keyword 'AND'. 
/cart/pc/SmallShoppingCart.asp, line 175

It happens on the view cart page and when it happens the only option the customers has is to either clear their cookies or swap browsers. It seems like it is a corruption of the users session.

Edited by razor150 - 10-August-2009 at 7:38pm

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
razor150 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 29-May-2008 Status: Offline Points: 7	Post Options Post Reply Quote razor150 Report Post Thanks(0) Quote Reply Topic: Does anybody know what might be causing this error Posted: 10-August-2009 at 7:29pm
	Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'. /cart/pc/SmallShoppingCart.asp, line 175 It happens on the view cart page and when it happens the only option the customers has is to either clear their cookies or swap browsers. It seems like it is a corruption of the users session. Edited by razor150 - 10-August-2009 at 7:38pm

intour Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 30-June-2006 Location: United Kingdom Status: Offline Points: 0	Post Options Post Reply Quote intour Report Post Thanks(0) Quote Reply Posted: 14-August-2009 at 7:43am
	The error message appears to be suggesting you have a coding error in line 175 of smallshoppingcart.asp. Have you modified this file in any way or have you tried reloading it? Nigel
	Innerview Productcart Platinum Reseller Web Design/Hosting/Virtual Tours

razor150 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 29-May-2008 Status: Offline Points: 7	Post Options Post Reply Quote razor150 Report Post Thanks(0) Quote Reply Posted: 14-August-2009 at 12:31pm
	Outside of some HTML, it hasn't been modified at all, I just added a link to a list of our catalogs. I have tried reverting to an unmodified version and it still has popped up on our test site. This error doesn't happen that often, it just seems to pop up every now and again. The frustrating part is that it only clears out with the removal of the store's cookie. It doesn't clear the error if the customer logs out and logs back in, effectively emptying their cart. The session has to be completely removed from their cookies. Could this error be caused by another modified page? Edited by razor150 - 14-August-2009 at 12:32pm

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 14-August-2009 at 1:01pm
	Sure, the issue could be due to other modifications to the source code. What does line 175 read like in your version of the file? (might be different from what we see in the default file, since you have modified it)
	The ProductCart Team Home of ProductCart shopping cart software

razor150 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 29-May-2008 Status: Offline Points: 7	Post Options Post Reply Quote razor150 Report Post Thanks(0) Quote Reply Posted: 14-August-2009 at 3:52pm
	Line 175 looks like this set rsGcVcObj=conTempSC.execute(query)