Hello all need a little help with QoQs.
How can I compare numbers in the QoQ? Example: <CFQUERY name="Qmain"> Select numberfield >From tbl </CFQUERY> <CFQUERY name="Qsub"> Select numberfield from qmain WHERE qmain.numberfield > 45 </CFQUERY> IF I use the ">" I get a PCODERUNTIME..... error If I use GT I get the error that numberfield is not a number. I even tried #qmain.numberfield#, but then it only compares the first record. I have ran numberfield through the ISNUMBER function and get true so it is a number. Thanks for any help Rodney ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
