The querynew() function accepts a second input which is a comma-delimited list of data types for your queries columns. You would have to examine the code inside of the structureToQuery udf to see what it is doing though. If you don't tell ColdFusion what to use, it guesses based on the first several rows of the query.
~Brad -----Original Message----- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Thursday, May 08, 2008 2:18 PM To: CF-Talk Subject: Re: whats wrong with my query!!! hi brad well i have first created a structure with the data and then used the structureToQuery function from cflib to convert it to a query. it should not be a date field - it is meant to be a varchar(5). should i do something to ensure that these columns are setup as a varchar so that it knows that this column is not mean to be a date field? if so how do i go about doing this? thanks for your help richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
