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