I am really not a big fan of it, but I think maybe in this situation the <cfinsert> tag can be useful. You would not have to list the column name with it.
Tracy On Fri, Jun 13, 2008 at 4:13 PM, Ian Skinner <[EMAIL PROTECTED]> wrote: > It's a trick I do not like to use, but listing the column names in an > insert statement is optional. > > If you wrote it like this. > > INSERT INTO LS07DATA > (aValue,bValue,cValue) > > The database should (I am not sure about Access) insert the values into > the first three columns of the table. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
