Hello Dave, Are your sure your getting to the insert query? Can you orderby a column that is not in your select query? I don't see any glaring issues with the insert. 11 fields, 11 updates no missing quotes??
Kind Regards, Mike Randolph At 11:51 PM 5/29/2003 -0400, you wrote: ><cfquery name="qfr" datasource="#dsn#"> >SELECT FRID >FROM fr >ORDER BY subjectID DESC ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
