Insert data into multiple tables from same email - Event Date: 28 Nov 2005 - 29 Nov 2005

Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic

   How can I solve the following?

Incoming email contains form data from web server. All incoming forms are scanned for all its data and the data is inserted into one table of a database. I also want to insert a subset of the same data from the same email into another table in the same database but only if specific condition exists.

How can this be achieved?

Author	Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic
Webslave Members Profile Send Private Message Find Members Posts Add to Buddy List New User Joined: 28 Nov 2005 Posts: 3	Post Options Post Reply Quote Webslave Report Post Quote Reply Calendar Event: Insert data into multiple tables from same email Posted: 28 Nov 2005 at 12:25pm
	How can I solve the following? Incoming email contains form data from web server. All incoming forms are scanned for all its data and the data is inserted into one table of a database. I also want to insert a subset of the same data from the same email into another table in the same database but only if specific condition exists. How can this be achieved?

Stephen Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Admin Group Joined: 21 Oct 2005 Location: Stoke on Trent Posts: 1389	Post Options Post Reply Quote Stephen Report Post Quote Reply Posted: 29 Nov 2005 at 7:12pm
	This can be done using a script.. I will post a sample script that shows a simple method of updating a database based on specific criteria.. I will post it in the scripts section..