Semi colon?????

[Calmaris]

I've never had to put a semi-colon at the end of these statements.

Exception Details: System.Runtime.InteropServices.COMException: [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement.

Source Error:


Line 45:
Line 46: query = " Insert INTO comments(User_ID, Comments) VALUES('" & User_ID & "', '" & comment & "') WHERE User_Id = '" & User_Id & "' "
Line 47: addcom = dbconn.execute(query)
Line 48:
Line

[CardboardHammer]

".InteropServices.COMException"

I can't be certain, but are you mixing ASP.NET with old ADO instead of using ADO.NET?

Thou shalt not use COM with .NET if thou can avoid it, lest the execution of thy code be slowed for no good reason.

[Calmaris]

Just a stupid mistake..... I should of paid more attention. My apologize.

[PeOfEo]

Originally posted by CardboardHammer
".InteropServices.COMException"

I can't be certain, but are you mixing ASP.NET with old ADO instead of using ADO.NET?

Thou shalt not use COM with .NET if thou can avoid it, lest the execution of thy code be slowed for no good reason. old english for new technologies