Sorry... Please Ignore!

[Brian Basquille]

Apologies... was meant to sent this to ASP Newsgroup

"Brian Basquille" <re**********@please.com> wrote in message
news:Oq**************@TK2MSFTNGP15.phx.gbl...

Hello all.

Just a quick question.

Can anyone see what's wrong with this ASP page? Am creating it in
WebMatrix and it's giving me the error: "System.Data.OleDb.OleDbException:
Syntax error in INSERT INTO statement."

It's to do the Insert SQL statement in the btnSubmit_Click() method.

It worked fine up until i added the text boxes for a password -
txtPassword and txtConfirmPassword. And now it's saying the syntax is
incorrect but i've studied SQL and i can't see what's wrong with it.

Anyone care to help me out to see what's wrong with it?

[Cor Ligthert]

Brian,

I was not ignoring it.

Have whatever the errror can be a look at this page.

http://msdn.microsoft.com/library/de...eterstopic.asp

This is the better way to add the parameters.

And the newsgroup for this is not aspnet however adonet.

Adonet
news://msnews.microsoft.com/microsof...amework.adonet

Web interface:
http://communities2.microsoft.com/co...amework.adonet

When you see this, than I hope this helps

Cor

[Brian Basquille]

Cheers for the reply, Cor.

I discovered the actual problem i was having was i was using a reserved word
in Access (password) in my SQL query.

I have corrected it now so it uses the Parameters.Add syntax.

Thank you for the advice.

Brian