replace the double quotes around "Yes" with single quotes 'Yes' and it should run OK.
Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm ----- Original Message ----- From: "W Luke" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, October 04, 2002 7:20 PM Subject: Re: Making use of cached queries > "Ken Brocx" <[EMAIL PROTECTED]> wrote in message > news:<[EMAIL PROTECTED]>... > > >> Does it have a problem in calling "TOP 2" records? For instance: > > > Try > > > > <Cfquery name="mytest" dbtype="query" maxrows="2"> > > SELECT ProductName > > FROM AllPaid > > WHERE ProductID = 5 > > </CFQUERY> > > Thanks Ken. And last but not least, how should I treat Yes/No fields in > a QoQ? For example something like "WHERE ProductID = 2 AND approved = > Yes" causes a "The select column reference [Yes] is not a column in any > of the tables of the FROM table list." error. Is this a task for > <cfqueryparam>? > > Will > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
