User ( posted:


I have recorded a script that does a web_submit_form, but when play back the script I am getting a 500 error. What seems to be happening from time to time is that we lose some of the FORM variables that are coming from the previous page, causing our stored procedure to fail.

The actual error is:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
/web/private/en/forum/forum_save.asp, line 38

The code in the asp page is:
Line 38:
sResult = oConn.Execute("DECLARE @id INT EXECUTE @id=Forum_Insert " & Request.Form("forumtypeid") & "," & session("userid") & ",'" & replace(Request.Form("header"),"'","''") & "','" & replace(Request.Form("body"),"'","''") & "'," & Request.Form("thread_from") & "," & Request.Form("orig_thread") & " SELECT @id AS ID" )

Has anyone seen this before? Solutions?


Your use of Yahoo! Groups is subject to