I want to pass 2 values called 'delOrder' and 'delOrder2' on the URL, and then delete records from a table based upon them. I'm having trouble getting the second value recognized using code along the lines of:
<!--- Code to pass the values on the URL line --->
<td>[ <a href="Order_Delete.cfm?delOrder=#URLEncodedFormat(ResultField1)#,delOrder2=#URLEncodedFormat(ID_Field)#" onClick="return confirm('Are you SURE you want to DELETE this record?')">DELETE</a>
<!--- Code to delete the record from the database table --->
<cfquery name="deleteOrderSKUs" datasource="mparam">
DELETE FROM skialberta_Orders
WHERE SKU = '#url.delOrder#' .and. UID = '#url.delOrder2#'
The error I get tells me that Cold Fusion cannot find a value for url.delOrder2, althoug you can see it being passed along in the URL. I wonder if the problem is with my ',' as the delimiter is example 1, and the '.and.' in example 2. I've tried some variation in syntax with no luck.