| Posted By |
Discussion Topic: Syntax Error with INSERT Statement
|
|
mel77 |
03-11-2009 @ 12:27 PM |
|
|
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 |
|
|
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 |
|
|
Senior Member
Posts: 183
Joined: Apr 2004
|
Password is a reserved word
|
|
|
