= and >= are not the proper syntax for a cfif statement
check page 96 of the ColdFusion "Developing Web Applications with ColdFusion
(manual that came with program)
= is represented by IS
>= is represented by GREATER THAN OR EQUAL TO or GTE, GE
See other examples on page 96
Good luck
Gary
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_000B_01BE93C0.DB208CE0
> Content-Type: text/plain;
> charset="windows-1257"
> Content-Transfer-Encoding: quoted-printable
>
> a couple of quick questions
>
> locally when I test it the results are fine when I upload it to the =
> server and run it off the web I get an error message saying is should =
> have used eq or is instead of =3D then when I do and I test it locally =
> using either is or eq I get the error locally saying cf cannot determine =
> the value of sortorder ????????????????
>
>
>
> <cfif sortorder =3D 1>
>
> <CFQUERY DATASOURCE=3D"australianaccomm" NAME=3D"properties">
>
> SELECT *
>
> FROM Properties=20
>
> WHERE=20
>
> Region like '#form.region#%'=20
>
> <cfif PropertyName is not "">
>
> AND PropertyName LIKE '#PropertyName#%'
>
> </cfif>
>
> <cfif StarRating is not "">
>
> AND StarRating >=3D '#StarRating#%'
>
> </cfif>
>
> ORDER BY activestatus asc, propertyname asc
>
> </CFQUERY>
>
> </cfif>
>
> also to add to the confusion when i select a value for star rating to =
> outputs values greater than my selection and seems to ignore the =3D =
> component of >=3D
>
> i look forward to your reply
>
> Kind Regards
>
> Claude Raiola
> E-Mail: [EMAIL PROTECTED]
> Website: www.internetgoldcoastproperties.com.au
>
>
>
> ------=_NextPart_000_000B_01BE93C0.DB208CE0
> Content-Type: text/html;
> charset="windows-1257"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Dwindows-1257" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT color=3D#0000ff size=3D2><FONT face=3DSystem size=3D2>
> <P><FONT face=3DArial>a couple of quick questions</FONT></P>
> <P><STRONG>locally when I test it the results are fine when I upload it =
> to the=20
> server and run it off the web I get an error message saying is should =
> have used=20
> eq or is instead of =3D then when I do and I test it locally using =
> either is or eq=20
> I get the error locally saying cf cannot determine the value of =
> sortorder=20
> ????????????????</STRONG></P>
> <P> </P>
> <P><STRONG><cfif sortorder =3D 1></STRONG></P>
> <P><STRONG><CFQUERY DATASOURCE=3D"australianaccomm"=20
> NAME=3D"properties"></STRONG></P>
> <P><STRONG>SELECT *</STRONG></P>
> <P><STRONG>FROM Properties </STRONG></P>
> <P><STRONG>WHERE </STRONG></P>
> <P><STRONG>Region like '#form.region#%' </STRONG></P>
> <P><STRONG><cfif PropertyName is not ""></STRONG></P>
> <P><STRONG>AND PropertyName LIKE '#PropertyName#%'</STRONG></P>
> <P><STRONG></cfif></STRONG></P>
> <P><STRONG><cfif StarRating is not ""></STRONG></P>
> <P><STRONG>AND StarRating >=3D '#StarRating#%'</STRONG></P>
> <P><STRONG></cfif></STRONG></P>
> <P><STRONG>ORDER BY activestatus asc, propertyname asc</STRONG></P>
> <P><STRONG></CFQUERY></STRONG></P>
> <P><STRONG></cfif></STRONG></P>
> <P><FONT face=3DArial>also to add to the confusion when i select a value =
> for star=20
> rating to outputs values greater than my selection and seems to ignore =
> the =3D=20
> component of >=3D</FONT></P></FONT></FONT></DIV>
> <DIV><FONT color=3D#0000ff size=3D2>i look forward to your =
> reply</FONT></DIV>
> <DIV><FONT color=3D#0000ff size=3D2><BR>Kind Regards</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT color=3D#0000ff size=3D2>Claude Raiola<BR>E-Mail: <A=20
> href=3D"mailto:[EMAIL PROTECTED]">info@internetgold=
> coastproperties.com.au</A><BR>Website:=20
> <A=20
> href=3D"http://www.internetgoldcoastproperties.com.au">www.internetgoldco=
> astproperties.com.au</A></FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT color=3D#0000ff size=3D2></FONT> </DIV></BODY></HTML>
>
> ------=_NextPart_000_000B_01BE93C0.DB208CE0--
>
> --------------------------------------------------------------------------
----
> 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.
------------------------------------------------------------------------------
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.
