Cold Fusion Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingCold Fusion Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old August 12th, 2005, 09:27 AM
telzen telzen is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2005
Posts: 1 telzen User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 m 46 sec
Reputation Power: 0
Exclamation Syntax error in INSERT INTO statement.

I am receiving the follwing error with ColdFustion Server MX7. The scripts were written in ColdFusion 5. Has something changed?

Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

The error occurred in K:\web\fsd145\fsdadmin\event_addAction.cfm: line 15

13 : </td></table></body></html>
14 : <cfelse>
15 : <cfinsert datasource="dbase" tablename="events">
16 : <cfoutput>
17 : <table width="50%">



--------------------------------------------------------------------------------

SQL insert into events (NAME,TIME,YEAR,MONTH,DETAILS,LOCATION,SUMMARY,DAY ) values ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) )
DATASOURCE dbase
VENDORERRORCODE -3502
SQLSTATE 42000

Please try the following:

Reply With Quote
  #2  
Old August 25th, 2005, 03:24 PM
wineandsun wineandsun is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2005
Posts: 1 wineandsun User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m
Reputation Power: 0
Cool DID you find a solution

I ahave the same problem anybody knows the solution

Thanks

Quote:
Originally Posted by telzen
I am receiving the follwing error with ColdFustion Server MX7. The scripts were written in ColdFusion 5. Has something changed?

Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

The error occurred in K:\web\fsd145\fsdadmin\event_addAction.cfm: line 15

13 : </td></table></body></html>
14 : <cfelse>
15 : <cfinsert datasource="dbase" tablename="events">
16 : <cfoutput>
17 : <table width="50%">



--------------------------------------------------------------------------------

SQL insert into events (NAME,TIME,YEAR,MONTH,DETAILS,LOCATION,SUMMARY,DAY ) values ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) )
DATASOURCE dbase
VENDORERRORCODE -3502
SQLSTATE 42000

Please try the following:

Reply With Quote
  #3  
Old August 26th, 2005, 05:23 AM
MichaelSoft MichaelSoft is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2005
Location: The Netherlands
Posts: 120 MichaelSoft User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 h 20 sec
Reputation Power: 14
I guess the database is changed between versions.
If so, there is not much else to do than updating the script to version MX7

Reply With Quote
  #4  
Old October 6th, 2005, 06:08 PM
DAspider DAspider is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2005
Posts: 1 DAspider User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 m 36 sec
Reputation Power: 0
Reserved Name

I believe "name" is a reserved name that will often cause errors, so you may want to rename your fields with a prefix like eventName, eventDate, etc.

Here's some more technical info: http://www.macromedia.com/go/14622

Reply With Quote
  #5  
Old April 4th, 2006, 09:49 PM
tat3m tat3m is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2006
Posts: 1 tat3m User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 m 10 sec
Reputation Power: 0
Thank You

Was Stumped with the exact same message... I couldn't understand why. I had changed my Table Field Names to simple names. ie Name, Date, ect....

Just Change the field names in you Database... Duh!

After Reading the above thread. This resolved my errors. Thank You!!!!!!!!!!!!!!!!!!!

Reply With Quote
  #6  
Old May 10th, 2007, 09:45 PM
ldexterldesign ldexterldesign is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2007
Posts: 1 ldexterldesign User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 31 sec
Reputation Power: 0
'update' is a reserved word in access
'update' is a reserved word in access
'update' is a reserved word in access
'update' is a reserved word in access
'update' is a reserved word in access
...

i won't forget that in a hurry. 2hrs down the drain.

THANKING YOU!

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingCold Fusion Development > Syntax error in INSERT INTO statement.


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap