LEAVE OUT THE TV???? No way, throw some eggs in there and you've got some pancakes :OD
Show us some code Ade -----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 19 September 2002 17:55 To: CF-Talk Subject: Run a check before an insert Ok I need to make a check on one table before I do an insert into another table. (Kind of similar to a login where the 1st query checks the username/2nd query checks the group). But I want to be able to have the 1st table be able to check for several rows in the first query and only insert the matches into the second query. So an example is: I am restricted to only ordering food items. I order sugar, milk, a tv and flour. I want the first query to look at the order then send to the 2nd query the order for sugar, milk and sugar, leaving out the tv. (and maybe sending a message to the user...sorry you can't order that...) I can't seem to get my loops right on this one- I either seem to be able to add all or nothing. Thanks in advance, Janine ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
