Answered
Cfquery Update Syntax Suddenly bad???
The following code has been working for 2yrs or so;
And suddenly I get the following error;
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
The error occurred in C:\Inetpub\wwwroot\seaboard\CartweaverPO.cfm: line 61
Called from C:\Inetpub\wwwroot\seaboard\ProcessOrder.cfm: line 36
Called from C:\Inetpub\wwwroot\seaboard\CartweaverPO.cfm: line 61
Called from C:\Inetpub\wwwroot\seaboard\ProcessOrder.cfm: line 36
59 : ,howUheard='#form.howUheard#'
60 : ,'mailCheck='#form.mailCheck#'
61 : WHERE CustomerID=#form.CustomerID#;
62 : </cfquery>
63 : </cfif>
SQL UPDATE Customers SET CompanyName = 'The Visual Spectrum' ,FirstName = 'Henry' ,LastName = 'Silvia' ,Address1 = '4432 Commercial Way' ,Address2 = '' ,City = 'Spring Hill' ,StateOrProv = 'FL' ,Zip = '34608' ,Country = 'United States' ,ShpAddress1 = '14567 Hoobi Doobi Lane' ,ShpCity = 'Brooksville' ,ShpStateOrProv = 'FL' ,ShpZip = '34606' ,ShpCountry = 'United States' ,PhoneNumber = '352-597-4395' ,FaxNumber = '597-5991' ,EmailAddress = 'hgs@visualspectrum.com' ,Notes = '' ,CCardType = 'v' ,CCNumber = '411111111111' ,ExprMonth = '01' ,ExprYr = '2008' ,permission = 'no' ,poNumber='' ,howUheard='Customer did not answer' ,'mailCheck='no' WHERE CustomerID=2201;
Every line has a comma except the last. The WHERE does referrence a ID field (Number, MSAccess) and yet I get Syntax error with no clue what is syntactically wrong. Any clues?
And suddenly I get the following error;
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
The error occurred in C:\Inetpub\wwwroot\seaboard\CartweaverPO.cfm: line 61
Called from C:\Inetpub\wwwroot\seaboard\ProcessOrder.cfm: line 36
Called from C:\Inetpub\wwwroot\seaboard\CartweaverPO.cfm: line 61
Called from C:\Inetpub\wwwroot\seaboard\ProcessOrder.cfm: line 36
59 : ,howUheard='#form.howUheard#'
60 : ,'mailCheck='#form.mailCheck#'
61 : WHERE CustomerID=#form.CustomerID#;
62 : </cfquery>
63 : </cfif>
SQL UPDATE Customers SET CompanyName = 'The Visual Spectrum' ,FirstName = 'Henry' ,LastName = 'Silvia' ,Address1 = '4432 Commercial Way' ,Address2 = '' ,City = 'Spring Hill' ,StateOrProv = 'FL' ,Zip = '34608' ,Country = 'United States' ,ShpAddress1 = '14567 Hoobi Doobi Lane' ,ShpCity = 'Brooksville' ,ShpStateOrProv = 'FL' ,ShpZip = '34606' ,ShpCountry = 'United States' ,PhoneNumber = '352-597-4395' ,FaxNumber = '597-5991' ,EmailAddress = 'hgs@visualspectrum.com' ,Notes = '' ,CCardType = 'v' ,CCNumber = '411111111111' ,ExprMonth = '01' ,ExprYr = '2008' ,permission = 'no' ,poNumber='' ,howUheard='Customer did not answer' ,'mailCheck='no' WHERE CustomerID=2201;
Every line has a comma except the last. The WHERE does referrence a ID field (Number, MSAccess) and yet I get Syntax error with no clue what is syntactically wrong. Any clues?
AdChoices