---------- 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
