Certainly has not been my experience. Rick
-----Original Message----- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 February, 2003 16:22 To: CF-Talk Subject: RE: Whats wrong with this code? ---------- Original Message ---------------------------------- From: "Kennerly, Rick H CIV" <[EMAIL PROTECTED]> >Unlike update, input requires that the order of the input be the same as the >order the columns are found in the database. Ummm . . . not really. The ordering issues with SQL's INSERT come about because you list the columns and THEN list the values, so it's easy to screw up the order. Unlike UPDATE, where you pair off the names/values. You can insert them in any order you wish (at least with Access, SQL Server, and Oracle). Scott -------------------------------- Scott Brady http://www.scottbrady.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
