Query Syntax Error?

[Newbie311]

sql="insert into users (username,password) values('"&request("text1")&"','"&request("text2")&"')"


Hi there the query above is giving me the following syntax error,any ideas why?


Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/main/test/new.asp, line 19

 

[ChrisHirst]

write out the sql string see if it's what you expect.



Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
Nightclub counting systems

So long, and thanks for all the fish.

 

[DotNetGnat]

password is a keyword...try wrapping it inside the []

something like this...

sql="insert into users ([username],[password]) values('"&request("text1")&"','"&request("text2")&"')"

hope that helps

-DNG

 

[Newbie311]

Much appreciated that fixed the problem
cheers!!

 

[DotNetGnat]

great...always remember that it is not suggested to use keywords as field names...if you do so wrap them in the square breaces

-DNG