Removing 1 of 2 url parameters after inserting a record
Posted on 2003-03-20
Situation is, I have a detail page (vendor_detail.asp) for a particular vendor, displaying all of his equipment. This page has an existing url parameter for the vendor's specific id (vendor_id) so that only his equipment is displayed. You can click on each piece of equipment to go and edit the details of that equipment (equip_edit.asp). Currently, when you click on the equipment piece, it will create a new url parameter(equip_id) so that the edit page only displays that piece of equipement for editing. Additionally, I am passing the existing url parameter of vendor_id so that I can pass it back after submitting the edit equipment (and return to the same vendor_detail.asp page).
My problem is that after submitting the updated equipment record, it is passing back both url parameters (vendor_id and equip_id). This is a problem if I want to edit the equipment detail again as it will now have 3 url parameters (vendor_id and 2 equip_id's), and errors out the page, message included for giggles.
ADODB.Recordset.1 error '80004005'
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near ' 2' at line 1
I am using the built in functionality of Dreamweaver for "Go to Detail Page".
I guess my question has a couple parts:
a) I don't remember specifying in the first place that the equip_edit.asp should pass url parameters back after submitting the update record. Is this a default when using the "update record" behavior?
b) How can you selectively pass back url parameters? I don't see this as built in to dreamweaver. The only url parameter I want to pass back is the vendor_id one.
I have relatively meager hand coding skills, though I can certainly follow directions like a champ.
Any help here would be appreciated.