var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Trouble converting ASP page to work with SQL Server
Until now, it's worked flawlessly while running on an Access database. Imported all the structure and data to SQL Server, and now the query is failing... I'm assuming there's a slight syntax change that needs to be made, but I can't find it for the life of me. Maybe another set of eyes will help.
UPDATE Carts SET UserNameFull='asasdfasdfasdfa',
CartModified='4/1/2004 06:36:54 PM'
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
/collegecrib/checkout.asp, line 187
Last edited by ataxia1; 04-01-04 at
the problem is in this line...
You need to specify a value... something like
Looks like it will be a late night...
Thanks for the quick reply, but that was one of the first things I tried.
A CartUser=null peacefully sits nestled among the rest of the SQL. : )
huh?? What do you mean by that???
As I made the post, I noticed the missing value and added a null to my code, but it still didn't fix the error.
The craziest part of all this is that if I copy the query directly into my Enterprise Manager console and execute it directly on the server, it works perfectly.
Thanks again for your help, and anything else you notice would be greatly appreciated.
Okie, well that is a bit strange. Do you want to post the code you are using to execute the query?
Do you still get the same error or is it something different??
Last edited by rokslide; 04-01-04 at
Just realized what's happening...
Two queries in the page, fixed the first one--probably hours ago--and the line number of the error changed. After 3 hours of debugging this 1300 line script, I guess I stopped reading the line #s.
Thanks again for your help.
Help to be of assistance... plus it gets my number of post up.