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