This is a multi-part message in MIME format.
------=_NextPart_000_0049_01BFD480.D92BEC20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
the following code=20
<CFQUERY DATASOURCE=3D"australianaccomm" NAME=3D"properties">
SELECT *
FROM Properties=20
WHERE=20
Regionid like '#form.regionid#'=20
<cfif PropertyName is not "Search All Properties">
AND PropertyName LIKE '#PropertyName#%'
</cfif>
<cfif StarRating is not "">
AND StarRating >=3D '#StarRating#%'
</cfif>
=20
the if statement above is used as one of the conditional codes to =
extract those properties who's star rating is greater than or equal to =
the value selected by the user for some reason the output generated is =
only ever greater than the value selected by the user and seems to =
ignore the equal to component do you have any ideas as to why this is =
the case and how I can rectify it.
=20
Kind Regards
Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]
------=_NextPart_000_0049_01BFD480.D92BEC20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2722.2800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>the following code </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> <FONT face=3DArial =
size=3D2><CFQUERY=20
DATASOURCE=3D"australianaccomm" NAME=3D"properties"><BR> SELECT=20
*<BR> FROM Properties <BR> WHERE <BR> =
Regionid like=20
'#form.regionid#' <BR> <cfif PropertyName is not "Search All=20
Properties"><BR> AND PropertyName LIKE=20
'#PropertyName#%'<BR> </cfif></FONT></DIV>
<DIV><FONT face=3DArial size=3D2> <cfif StarRating is not=20
""><BR> AND StarRating >=3D=20
'#StarRating#%'<BR></cfif></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>the if statement above is used as one =
of the=20
conditional codes to extract those properties who's star rating is =
greater than=20
or equal to the value selected by the user for some reason the output =
generated=20
is only ever greater than the value selected by the user and seems to =
ignore the=20
equal to component do you have any ideas as to why this is the case and =
how I=20
can rectify it.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> <FONT face=3DArial=20
size=3D2></FONT></DIV></DIV>
<DIV><FONT face=3DArial size=3D2>Kind Regards</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Claude Raiola=20
(Director)<BR>AustralianAccommodation.com Pty. Ltd.<BR>Website: <A=20
href=3D"http://www.AustralianAccommodation.com">www.AustralianAccommodati=
on.com</A><BR>Email:=20
<A=20
href=3D"mailto:[EMAIL PROTECTED]">Director@AustralianA=
ccommodation.com</A></FONT></DIV></BODY></HTML>
------=_NextPart_000_0049_01BFD480.D92BEC20--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Help with If Statement to generate certain output results
AustralianAccommodation.com Pty. Ltd. Mon, 12 Jun 2000 02:13:14 -0700
