Hi Pascal Thanks for that, inserting the dummy record works. Can I extract the data directly from the XML? I need to query the data to extract only certain records, is there a CF function to do this?
Andrew. On Thu, 18 Nov 2004 11:28:15 +0100, Pascal Peters <[EMAIL PROTECTED]> wrote: > 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:184713 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
