You don't need the wild cards in your table update commands.
General syntax is update [table], [table] Generally I don't update more than one table per SQL statement. _____ From: John Eubanks [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 07, 2007 2:58 PM To: CF-Newbie Subject: Extreme Help I need help on this asap, if possible: http://inside.3i-online.com/reps_test/ Step 1. Choose Edit Step 2. Choose a region Step 3. Choose a name from the list Step 4. Check any number of the boxes (1 or however many you like) Step 5. Edit a text field Step 6. Click the submit button The problem: I can't get it to perform the update, as you will notice. I am exactly sure how to do this. I know it is not rocket science or anything. The plea: Please help. In a nutshell: I have two tables: one with a list of reps, another with a list of territories assigned to those reps. The one thing the two tables have in common is a RepId. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2489 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
