You can use XPath with XMLSearch(). Pascal
> -----Original Message----- > From: Andrew Dixon [mailto:[EMAIL PROTECTED] > Sent: 18 November 2004 11:44 > To: CF-Talk > Subject: Re: QofQ Problem > > 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:184714 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
