Ok... I will take a look at that. Thanks.
On Thu, 18 Nov 2004 11:47:18 +0100, Pascal Peters <[EMAIL PROTECTED]> wrote: > 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:184716 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