Wrox Programmer Forums
|
ASP Forms As of Oct 5, 2005, this forum is now locked. Please use "Classic ASP beginner" at http://p2p.wrox.com/forum.asp?FORUM_ID=54 or "Classic ASP Professional" http://p2p.wrox.com/forum.asp?FORUM_ID=56 instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP Forms section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 11th, 2005, 01:58 AM
Authorized User
 
Join Date: Feb 2005
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to kumarop
Default Which trigger will work

Hi,
There exist a trigger in Developer call "post commit",it fires just after commit command ? Similarly I want to do some work after submit button pressed(sucessful submission in database),I mean after commit on database (I guess both are same)? which asp event will suit me, or what is the best way to do it?
My requirement is when user submit the form say its product details, I save it into my database. I have written function for sending email. I want when form is successfully saved into database then one email should go to relevant user.
1) If record is not saved into database function should not run.
Else function should work.

I can use onSubmit, but I guess onSubmit fires before submit. is not it? Please guide.


Thanks in advance
Regards
__________________
om prakash kumar
 
Old May 10th, 2005, 03:39 AM
Authorized User
 
Join Date: May 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i suggest that you must put your code to the next asp page where the link is pointing to. then redirect back to page when data is invalid.
just dont use onSubmit on this page. maybe SQL will do.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Help on Trigger arnabghosh SQL Server 2000 3 August 21st, 2008 02:07 AM
Trigger fhillipo SQL Server 2000 1 March 20th, 2007 07:44 AM
Trigger Doesn't Work Arsi SQL Server 2000 8 December 13th, 2004 05:04 PM
Trigger ! minhtri Pro VB Databases 2 June 23rd, 2004 02:27 AM
Using instead of trigger dmr999 SQL Server 2000 1 November 29th, 2003 02:35 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.