>- see footer for list info -< I would use BETWEEN just another note: CFQUERYPARAM is recommend in queries
On 24/08/07, Allan Cliff <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > Morning, > > A quick SQL question to keep your minds sharp before the weekend! > > I have 2 columns, FromBeds, ToBeds in an SQL db and I want to find the > records where my value falls between those values. > > So if I search for a property with 3 bedrooms I want to find all the > properties which fall in that range. > > This didn't work. > > SELECT * > FROM Table > WHERE FromBeds >= #val(beds)# AND/OR ToBeds <= #val(beds)# > > Thanks > Allan > > > --------------------------------- > 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 > -< > _______________________________________________ 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 -<
