Are you using CFMX? I believe this issue relates to the fact that QofQ makes assumptions based on the data in the original query. In your data below - your first row in the column custom 1 has a data. Later on, you have a non date value. Therefore, when you QofQ against it - the system gets confused. All I can suggest is perhaps using another column to signify the non-date version of the custom1 column.
======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 8:58 AM > To: CF-Talk > Subject: query of query question > > > I'm querying a search resultset and getting an error. It > must be some kind > of syntax thing but I don't see it. Does anyone see a > problem with this > query. > > The first query returns the following: > > CUSTOM1 CUSTOM2 KEY RECORDSSEARCHED SCORE > SUMMARY > April 2002 article 970 1421 0.7742 > ....... > -100 25 25 1421 0.7742 > ....... > > When I query this query result with the following I get error. > > select * from results > where custom1 = "-100" > > I get error: Can't find symbol: " > > Without quotes I get: Error: April 2002 is not a number > > Thanks for any help. > > Daron J. Smith > PSEA > [EMAIL PROTECTED] > > PS does anyone know of a good Query of Queries reference? > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
