>- see footer for list info -< Thanks for all the ideas although I don't think any will work.
Between is fine if i supply 2 values and i want a column value to be BETWEEN those. SELECT * FROM Table WHERE CreatedDate BETWEEN #FromDate# AND #ToDate# the solution i think that will work for me is to negate being outside that range SELECT * FROM Table WHERE NOT FromBeds < #beds# AND NOT ToBeds > #beds# (with cfqueryparam of course) Allan Snake <[EMAIL PROTECTED]> wrote: >- see footer for list info -< Although you can on CF8 :-) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Woods Sent: 24 August 2007 12:12 To: Coldfusion Development Subject: Re: [CF-Dev] SQL question >- see footer for list info -< > WHERE FromBeds >= #val(beds)# AND/OR ToBeds <= #val(beds)# use BETWEEN as suggested or just change to WHERE #int(val(beds))# >= FromBeds AND #int(val(beds))# <= ToBeds cfqueryparam is indeed recommended, but you can't use query caching with cfqueryparam. Lots of supposed best pratices are frequently ignored by people in the real world. Mark _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< --------------------------------- Yahoo! Answers - Get better answers from someone who knows. Tryit now. _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
