Syntax Error in INSERT INTO

[Kingmarl]

That's it. I've had enough of this darn program!!!

Has anyone had a problem when creating an INSERT INTO form with UD?
Here's the Error:-
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/new/sovtariffadmin.asp, line 131

I've only just started learning bits of ASP, and I use UD to sort out all my connections & SQLs. I don't claim to know any asp at all, but I do know Macromedia products like the back of my hand, I just don't know enough about ASP code to find or correct the error, and this is the 12th time it's happened.

Please help me..... Please....! ----------------------------------------
Don't forget to visit

http://www.sovereign2k.com/rob

for some banging new music from DJ Cumback

 

[Microbe]

Here's what I do when frustrated by a bad SQl statement.

Drop it into either a session variable or a javascript alert so you can see the string that it is trying to use.

I find that I have an incorrect string type somewhere or forgotten to declare somethign as a date or something.

If you can see the structure of the SQL statement you are 90% of the way to fixing it.
Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au