EasyCFM.COM ColdFusion Forums / MS Access Related Issues / Syntax Error with INSERT Statement

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Syntax Error with INSERT Statement

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

mel77
03-11-2009 @ 12:27 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 4
Joined: Mar 2009

I am hosting on Go daddy. I have been having problem with my hosting for the past five weeks. I really need help with Inserting Record to my MS access driver database.

The table contains the following:INSERT INTO Users (UserID, Username, Password, FirstName, LastName, Telephone, EmailAddress, RegisterDate, UserTypeID)

I can only log on from the database eg "login". My reviews table doesn't display when post a review.

It appears on the Admin index page and i check the Online box for it to display for members to view. The update doesn't work too.

I have allowed the Permission to be Read and Write into database.

Go daddy people said they are not seeing any problem with setup, that is everything is working fine, yet new members can not add record. Please can anyone help me.



I love you all

cfSearchin
03-11-2009 @ 1:33 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 608
Joined: Feb 2008

quote:


(UserID, Username, Password, FirstName, LastName, Telephone, EmailAddress, RegisterDate, UserTypeID)



It is best to post the full error message from CF. But without more details, my guess would be usage of a reserved keyword as a column name.  Possibly the "Password" column.  Try renaming it or failing that, escape it with [ ].  

But

weathermanfsu
06-09-2009 @ 12:17 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 183
Joined: Apr 2004

Password is a reserved word


Website Designed and Developed by Pablo Varando.