MarkMeerten
Programmer
Hello,
I made an asp page to insert a record to a SQL DB. The server behavior "insert record" has an option "After inserting, Go To:"
I entered another asp page and clicked on the "Parameters" button. I entered the parameter's name and a value of the recordset.
This other page uses the URL parameter to build a new recorset.
The code generated by dreamweaver is the folowing:
MM_editRedirectUrl = "/personeel/verlof_bevestiging.asp?persnr=" + (rsVerlof.Fields.Item("Tpers_nr").Value) + ""
When i test the application i get the following fault:
"Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Tpers_nr'.
/personeel/verlof_bevestiging.asp, line 20"
I think this is caused by the messed up URL. It looks like this:
What's wrong? I presumed that the code wich is generated by DW is always correct?
What should be the correct syntax to pass this parameter?
Greetz,
I made an asp page to insert a record to a SQL DB. The server behavior "insert record" has an option "After inserting, Go To:"
I entered another asp page and clicked on the "Parameters" button. I entered the parameter's name and a value of the recordset.
This other page uses the URL parameter to build a new recorset.
The code generated by dreamweaver is the folowing:
MM_editRedirectUrl = "/personeel/verlof_bevestiging.asp?persnr=" + (rsVerlof.Fields.Item("Tpers_nr").Value) + ""
When i test the application i get the following fault:
"Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Tpers_nr'.
/personeel/verlof_bevestiging.asp, line 20"
I think this is caused by the messed up URL. It looks like this:
What's wrong? I presumed that the code wich is generated by DW is always correct?
What should be the correct syntax to pass this parameter?
Greetz,