Update multiple records on the List page |
10/13/2013 5:43:51 AM |
ASPRunnerPro General questions | |
K
kleanthis author
I want to update multiple records on the list page, and I try to use the update button that described in the manual, but it doesn't work. I get a syntax error on line 5 (sql = "Update employees set ReportsTo='Bob Smith' )
|
|
admin 10/13/2013 | |
Step one - check your code for syntax errors. There is a built-in syntax checker in ASPRunnerPro. |
K
|
kleanthis author 10/13/2013 |
Step one - check your code for syntax errors. There is a built-in syntax checker in ASPRunnerPro. Step two - make sure all table and field names are correct in your code.
|
admin 10/13/2013 | |
Are you saying you getting error right after pasting code from the manual or after you applied your changes? |
K
|
kleanthis author 10/14/2013 |
Are you saying you getting error right after pasting code from the manual or after you applied your changes?
|
lefty 10/14/2013 | |
I getting error after pasting code from the manual. The error is "Microsoft VBScript compilation error: Unterminated string constant in line" I have ASPRunner 7.2
|
admin 10/14/2013 | |
It looks like syntax checked doesn't understand multiline statements or there is syntax error in the manual sql = "Update employees set ReportsTo='Bob Smith' _
sql = "Update employees set ReportsTo='Bob Smith' where KeyField=" & keys(i)(KeyField)
|