>- 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 -<
