Hi,

I am using Coldfusion 7 on MS Vista w/Dreamweaver 8 using MSAccess 2007 saving my database as MSACCESS 2003.

When I use the insert record wizzard in Dreamweaver, I get the following error message on half of my tables in my database.

I suspect my syntax is wrong, but I cant figure out how to edit it. I have created test tables (like the one I am describing here) with only a few fields and no relationships. I have read lots of strings on this topic, so that is why I simply created test tables with all text fields except the primary key and a potential relation field.

I think one of my troubleshooting problems is that I dont know how to enter my sql statement into the Access query builder regarding the value of my (param) statements. But I can enter data fine from within Access, either directly into the tables or from a custom query.

What should I try next?



==================================================
Error Executing Database Query.
Syntax error in INSERT INTO statement.

The error occurred in C:\CFusionMX7\wwwroot\admin\users\adduser.cfm: line 22

20 : <cfelse>
21 : ''
22 : </cfif>
23 : )
24 : </cfquery>



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

SQL INSERT INTO customers (usertypeid, username, password) VALUES ( (param 1) , (param 2) , (param 3) )
DATASOURCE DaytonFSBO
VENDORERRORCODE 3092
SQLSTATE &nbsp;

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; InfoPath.2)
Remote Address 127.0.0.1
Referrer http://localhost:8500/admin/users/adduser.cfm
Date/Time 28-Mar-07 03:32 PM

Stack Trace (click to expand)
==========================================================

Well, out of all the cfqueries I have in my application, every one of them has a name. This one does not have a name, however.

I'm having exactly this same error pop up. And, it's not consistant. I've compared the code between pages where the insert is working just fine and those that give this error and there doesn't seem to be a problem with the code. I've even written the values into a SQL query string that runs perfectly in the database but even with a perfectly acceptable query string handcoded into the <cfquery> the page can't execute the insert query. If anyone else has experienced this and can provide some direction it would be greatly appreciated!

This is what I'm stuck on:
+++++++++++++++++++++++
Error Occurred While Processing Request
Error Executing Database Query.
Syntax error in INSERT INTO statement.

The error occurred in C:\CFusionMX7\wwwroot\blastfree\DRR_CreateLogin.cfm: line 49

47 : <cfelse>
48 : ''
49 : </cfif>
50 : )
51 : </cfquery>



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

SQL INSERT INTO tblPasswordInfo (FirstName, UserName, Password, UserGroup, ContactID, RemQuestion, RemAnswer) VALUES ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) )
DATASOURCE access_BlastFree
VENDORERRORCODE 3092
SQLSTATE  

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2; NET_mmhpset)
Remote Address 127.0.0.1
Referrer http://localhost:8500/blastfree/DRR_CreateLogin.cfm
Date/Time 07-Aug-08 05:40 AM

That's a good test.

I suspect you are using a reserved word as table or column name. That would cause a syntax error because the database is not treating it as an object name. My first guess would be the "Password" column. Try adding [ ] around it in your query.



If that fixes the syntax error, rename the column. If it is not possible to rename it, you will need to add [] to every query containing the "password" column.

Hi sansclue!
I actually stayed up all night and found that Password was a reserved word. I logged back in to post the solution. It's so simple and I saw how many folks looked at this thread. It's important to share even the easy answers and save others a bit of a headache. Thanks very much for posting!

spinner

Absolutely! I am glad everything is working now spinner.