Richard White wrote: > i have 2 queries and am running a query on query to joi n them together but > the error message i am getting is: > > A1001 must be interpretable as a valid number in the current locale. > > and i have no idea what that means
I would guess it is a column type problem. I would bet that the first record in the query with 'A1001' does not have a letter in it. When this happens ColdFusion guesses that the column type is a number and it expects all the rest of the values in that column to be a number. If this is the problem, you need to use the mechanisms built into ColdFusion to define the column types so that CF does not have to make guesses at it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304948 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
