teresawhlr
Posts: 10
|
| Posted: 02/15/2006, 6:22 AM |
|
Here's what I'm attempting to do:
I would like to prompt the user with a yes/no question and execute a sql statement if the user chooses yes. This process will be executed from the same page as a search/report is located on. I've tried using a button, but could not get the MSGBOX function to be displayed using the Server OnClick event (nothing would be displayed). I do not have a problem with the execution of the sql statement itself if I do it in ASP. What I'm having a problem with is prompting the user and determining if yes/no has been clicked.
Any help would be greatly appreciated.
Thanks,
Teresa
|
 |
 |
Walter Kempees
|
| Posted: 02/15/2006, 9:10 AM |
|
Just an educated guess:
If you have a DeleteButton on a Form, you can add a Confirmation Action to
it.
So, on your SubmitButton, in Properties add the Confirmation Action, add the
Message you want and it will react to Yes/No.
(Not tested, just impromptu reaction)
"teresawhlr" <teresawhlr@forum.codecharge> schreef in bericht
news:643f339137e15d@news.codecharge.com...
> Here's what I'm attempting to do:
> I would like to prompt the user with a yes/no question and execute a sql
> statement if the user chooses yes. This process will be executed from the
> same
> page as a search/report is located on. I've tried using a button, but
> could not
> get the MSGBOX function to be displayed using the Server OnClick event
> (nothing
> would be displayed). I do not have a problem with the execution of the
> sql
> statement itself if I do it in ASP. What I'm having a problem with is
> prompting
> the user and determining if yes/no has been clicked.
>
> Any help would be greatly appreciated.
>
> Thanks,
> Teresa
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Paul Shearing
|
| Posted: 02/16/2006, 3:09 AM |
|
I can't claim to be an expert, but my understanding is that a call to MSGBOX in ASP code will result in the message box being displayed on the server, not the client.
Try Walter's solution it seems to be the simplest, otherwise you may have to resort to client-side scripting (JavaScript and/or VBScript) to both display the message and perform the SQL statement. 
|
|
|
|
|
