Topic: Syntax Error with INSERT Statement


mel77    -- 03-11-2009 @ 12:27 PM
  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
 
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
  Password is a reserved word


EasyCFM.COM ColdFusion Forums : http://archive.easycfm.com/forums
Topic: http://archive.easycfm.com/forums/viewmessages.cfm?Forum=30&Topic=14166