>- see footer for list info -<
haven't you got it the wrong way round, shouldn't it be:
SELECT *
FROM Table
WHERE FromBeds <= #val(beds)#
AND ToBeds >= #val(beds)#
? I'm assuming it's of the form From = 1, To = 3. So Beds has to be betwen
From and To, i.e. Beds >= From, Beds <= To???
Duncan Cumming
New Media Developer
Customer Relations Management / Education
Fife Council
08451 55 55 55, extension 44 44 65
My number changed on 23rd July to 08451 55 55 55, extension 44 44 65
Many other council numbers changed on that date - please go to
www.fifedirect.org.uk and click on the 'Big Number Change' link for details.
>>> [EMAIL PROTECTED] 24/08/2007 11:50 >>>
>- 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 -<
**********************************************************************
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed and
should not be disclosed to any other party.
If you have received this email in error please notify your system manager and
the sender of this message.
This email message has been swept for the presence of computer viruses but no
guarantee is given that this e-mail message and any attachments are free from
viruses.
Fife Council reserves the right to monitor the content of all incoming and
outgoing email.
Fife Council
Tel: 08451 55 00 00
************************************************
_______________________________________________
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 -<
