"....error in INSERT INTO ...." 2

[Karl Blessing]

2147217900
Syntax error in INSERT INTO statement.
Microsoft JET Database Engine
INSERT INTO UserLogon (UserName, Password, Email) values ('kbkby', 'kbkbk','kb@kb.com')

that above is the error I get when I check my Err object.
and the SQL string it tried to execute is also posted, the three sections in that table are all text types.

this is the table structure

UserName - Text
Password - Text
Email - Text
UserID - AutoNumber (also Primary Key)
UserStatus - Text

I type the above SQL String into the Query mode in Access, and it adds it just fine. But in ASP it says that Error, and I cant figure out, what it means by syntax error, since everything seems just perfect. Karl Blessing aka kb244{fastHACK}

 

[foxbox]

Can you show the ASP that is producing:

INSERT INTO UserLogon (UserName, Password, Email) values ('kbkby', 'kbkbk','kb@kb.com')




br
Gerard

 

[jonscott8]

Try encapsulating the field names in brackets. Username, password, or email may be an access reserved word, and IIRC, username() is an access function to retrieve the username of the current connection, which would explain the syntax error.

INSERT INTO UserLogon ([UserName], [Password], ) values ('kbkby', 'kbkbk','kb@kb.com') Jon Hawkins

 

[IonelBurtan]

Try the following:
INSERT INTO [UserLogon] ([UserName], [Password], , [UserStatus]) values ('kbkby', 'kbkbk','kb@kb.com','')

or

INSERT INTO [dbo].[UserLogon] ([UserName], [Password], [Email], [UserStatus]) values ('kbkby', 'kbkbk','kb@kb.com','')

Hope this helps,s-) Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...
[URL unfurl="true"]http://home.domaindlx.com/ionelb[/URL]