Yeah, change this line here: <cfset q_atty = queryNew("atty_id, first_name, middle_name, last_name, suffix, atty_type, bus_number, office_id, keyCOUNT")>
Read up here: http://livedocs.adobe.com/coldfusion/7/htmldocs/00000600.htm Change the line to: <cfset q_atty = queryNew("atty_id, first_name, middle_name...","varchar,varchar,varchar...")> See if that helps keep ColdFusion straight. (Again, note this was added in CF7) ~Brad -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2008 1:57 PM To: CF-Talk Subject: Re: Odd results with error - ideas? Brad Wood wrote: > I think your problem may stem from the old behavior of ColdFusion query > columns guessing what type they are based on values in the first several > rows. Ugly because of line breaks, but here ya go: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4