Ask a Question related to Coldfusion Database Access, Design and Development.
-
burnsaster@gmail.com #1
HELP SQL Update syntax error in windows2003 but works fine in NT4???
We upgraded our production server to windows 2003 and have been seeing
this error when trying to update the database through a cfquery tag:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax
near ','.
SQL = "UPDATE documents SET catid = , moduleid = WHERE document_id =
21122"
Data Source = "EONET2"
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (9:1) to (9:57).
Here is the code on the NT4 box:
<cfset itemId = #listFirst(docs.node)#>
<CFQUERY NAME="UpdateDoc" datasource="#application.DSN#">
UPDATE documents
SET catid = #itemID#, moduleid = #listLast(docs.node)#
WHERE document_id = #documentID#
</CFQUERY>
I've tried restructuring the query many ways but nothing seems to work?
What am I missing here?
burnsaster@gmail.com Guest
-
Syntax Error Update Statement
Can someone tell me what's wrong with this code? I need help. Thanks! It is an update page. FIRST PAGE: LOGIN CHECK <!--- Filename: ... -
Syntax error in update
I'm using the update record form wizard in Dreamweaver, and am getting this error when I try to submit changes. <cfparam name='FORM.buildnumber'... -
Error 80004005 when creating recordset object in ASP file, but works fine in Global.ASA
For some reason I am getting an error when trying to open a recordset on an Access database on my Win2K3 machine from my INDEX.ASP page, but the... -
Getting a SQL Update syntax error...really shouldn't be?
Try putting round the password column in the UPDATE statement. I think that SQL might be seeing that as a reserved word. Hope it helps... ... -
syntax error on update
ugh, thanx for the help guess there's more than one way this syntax works as well rs("firstname")=blahblah i'm just learning sql so i tend to...



Reply With Quote

