> > <CFQUERY name="Qmain"> > Select numberfield > From tbl > </CFQUERY> > > > <CFQUERY name="Qsub"> > Select numberfield > from qmain > WHERE qmain.numberfield > 45 > </CFQUERY>
you are missing DBTYPE="query" i.e. <CFQUERY name="Qmain" DBTYPE="query"> Select numberfield From tbl </CFQUERY> ----- Original Message ----- From: "Bruce, Rodney (SIGNAL)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 9:45 AM Subject: QoQ > 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 > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
