Added: November/18/2004 at 3:38pm | IP Logged

I am trying to run a serverside function to delete an order & then redirect to another page. It does not seem to work. Below is ther relevant part of the page:

'Cancel the Order **************
Function CancelOrder()
Dim SQLDelOrd
SQLDelOrd = "DELETE tblOrders_temp.OrderID, * FROM tblOrders_temp WHERE (((tblOrders_temp.OrderID)=" & OrdID & "));"

objConn.Execute(SQLDelOrd)

Response.Clear
Response.Redirect "MenuForRegisteredUsers.asp"
End Function
%>

<table Width = 100%>
<tr>
<td width="30%" valign="top" height="38">&nbsp;</td>
<td width="20%" valign="top"  align=Center height="38"><BUTTON TYPE="SUBMIT" NAME="Sub" >View Your Order</BUTTON>
 </td>
<td width="20%" valign="top" align=Center height="38">
<BUTTON TYPE="Button" onClick ="CancelOrder()"> Cancel - Back to Registered Accounts Menu</BUTTON>
 </td>
<td width="30%" valign="top" height="38">&nbsp;</td>
</tr>
</table>
</FORM>

Thanks,

Alan

Added: November/18/2004 at 7:09pm | IP Logged

Thanks Chris. I understand. Is there not a way to run serverside code from a button? At least I would like to open an asp page so I could run the code there & redirect to the next page. How coul I do that from a button?

The reason I am asking about a button is that I already have a submit type button on the form. This button will make the two field values available for the next page. However, with this button, I need to initiate a delete query on the server and redirect to an earlier menu page. Any suggestions?

Thanks for your help.

Added: November/18/2004 at 10:32pm | IP Logged

In thinking about it, I think the answer is just to use two submit buttons, each doing its own thing.

Thanks again for being patient with newbie stumblings.