help with CFIF conditions and sort orders

Sun, 30 Apr 2000 17:50:56 -0700 

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>&nbsp;</P>
<P><STRONG>&lt;cfif sortorder =3D 1&gt;</STRONG></P>
<P><STRONG>&lt;CFQUERY DATASOURCE=3D"australianaccomm"=20
NAME=3D"properties"&gt;</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>&lt;cfif PropertyName is not ""&gt;</STRONG></P>
<P><STRONG>AND PropertyName LIKE '#PropertyName#%'</STRONG></P>
<P><STRONG>&lt;/cfif&gt;</STRONG></P>
<P><STRONG>&lt;cfif StarRating is not ""&gt;</STRONG></P>
<P><STRONG>AND StarRating &gt;=3D '#StarRating#%'</STRONG></P>
<P><STRONG>&lt;/cfif&gt;</STRONG></P>
<P><STRONG>ORDER BY activestatus asc, propertyname asc</STRONG></P>
<P><STRONG>&lt;/CFQUERY&gt;</STRONG></P>
<P><STRONG>&lt;/cfif&gt;</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 &gt;=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>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT color=3D#0000ff size=3D2></FONT>&nbsp;</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.

Reply via email to