>- see footer for list info -< and b4 Big Kev says anything: may the SCOTCH be with you!
:-) On 24/08/07, Snake <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > Or NOT BETWEEN > > Russ > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Allan Cliff > Sent: 24 August 2007 13:05 > To: Coldfusion Development > Subject: RE: [CF-Dev] SQL question > > >- 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 > >-< > > > _______________________________________________ > > 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 -<
