Hey Shaggy,
I implemented this with your change spec'd above and I am getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 's'.
/ComplainToModerator.asp, line 100
My code lines look like:
SQL = "INSERT INTO FORUM_COMPLAINTS(ForumID, TopicID, CatID, Message, ReporterID, IsTopic, ReplyID, Solved)"
SQL = SQL & " VALUES(" & ForumID & ", " & TopicID & ", " & CatID & ", '" & message & "', " & ReporterID & ", " & IsTopic & ", " & ReplyID & ", " & 0 & ")"
And, I told it to output my SQL line and it says it's this:
INSERT INTO FORUM_COMPLAINTS(ForumID, TopicID, CatID, Message, ReporterID, IsTopic, ReplyID, Solved) VALUES(7, 6, 1, 'This guy's a jerk!', 2, 1, 0, 0)
I tried it with a bunch of combos of ", "", """, '", etc., but none seem to work. Any ideas for me?
Thanks!
h
Topic Locked
Posted - 08 March 2005 : 09:14:28
