The problem is that CF is guessing the data type of the column by looking at the values in the first row. In this case CF thinks the column contains numeric data (because of the 10902 in the first row). This was discussed several times on this list and there should be solutions in the archives. Can't you extract the data directly from the XML? If you want to use QofQ, you can insert a bogus record on top with the correct data types in it. Just see that you don't extract it.
Pascal > -----Original Message----- > From: Andrew Dixon [mailto:[EMAIL PROTECTED] > Sent: 18 November 2004 11:16 > To: CF-Talk > Subject: QofQ Problem > > Hi Everyone. > > I have a strange QofQ problem. The error message I'm getting is: > > "USA" must be interprettable as a valid number in the current locale. > > The column that contains the word "USA" is a column that contains both > letters and numbers, for example: > > 10902 > 10909 > USA > HPH > NO2H32 > > It appears to be something to do with certain data sets are other with > similar data work ok. The original data comes from an XML data feed > that I have transformed into a query and that wish to extract only > some of the data from using a QofQ. > > Has anyone else come across that problem??? If so have you got a fix? > > BTW, using CFMX6.1 + updater. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184711 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
