Fw: help with CFIF conditions and sort orders
This is a multi-part message in MIME format. --=_NextPart_000_000F_01BE9435.DB17CC20 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 =20 --=_NextPart_000_000F_01BE9435.DB17CC20 Content-Type: text/html; charset="windows-1257" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD 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#ff DIVBR/DIV DIVFONT color=3D#ff size=3D2FONT face=3DSystem size=3D2 PFONT face=3DAriala couple of quick questions/FONT/P PSTRONGlocally 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 Pnbsp;/P PSTRONGlt;cfif sortorder =3D 1gt;/STRONG/P PSTRONGlt;CFQUERY DATASOURCE=3D"australianaccomm"=20 NAME=3D"properties"gt;/STRONG/P PSTRONGSELECT */STRONG/P PSTRONGFROM Properties /STRONG/P PSTRONGWHERE /STRONG/P PSTRONGRegion like '#form.region#%' /STRONG/P PSTRONGlt;cfif PropertyName is not ""gt;/STRONG/P PSTRONGAND PropertyName LIKE '#PropertyName#%'/STRONG/P PSTRONGlt;/cfifgt;/STRONG/P PSTRONGlt;cfif StarRating is not ""gt;/STRONG/P PSTRONGAND StarRating gt;=3D '#StarRating#%'/STRONG/P PSTRONGlt;/cfifgt;/STRONG/P PSTRONGORDER BY activestatus asc, propertyname asc/STRONG/P PSTRONGlt;/CFQUERYgt;/STRONG/P PSTRONGlt;/cfifgt;/STRONG/P PFONT face=3DArialalso 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 DIVFONT color=3D#ff size=3D2i look forward to your = reply/FONT/DIV DIVFONT color=3D#ff size=3D2BRKind Regards/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2Claude RaiolaBRE-Mail: A=20 href=3D"mailto:[EMAIL PROTECTED]"info@internetgold= coastproperties.com.au/ABRWebsite:=20 A=20 href=3D"http://www.internetgoldcoastproperties.com.au"www.internetgoldco= astproperties.com.au/A/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2/FONTnbsp;/DIV/BODY/HTML --=_NextPart_000_000F_01BE9435.DB17CC20-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
help with CFIF conditions and sort orders
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" HTMLHEAD 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#ff DIVFONT color=3D#ff size=3D2FONT face=3DSystem size=3D2 PFONT face=3DAriala couple of quick questions/FONT/P PSTRONGlocally 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 Pnbsp;/P PSTRONGlt;cfif sortorder =3D 1gt;/STRONG/P PSTRONGlt;CFQUERY DATASOURCE=3D"australianaccomm"=20 NAME=3D"properties"gt;/STRONG/P PSTRONGSELECT */STRONG/P PSTRONGFROM Properties /STRONG/P PSTRONGWHERE /STRONG/P PSTRONGRegion like '#form.region#%' /STRONG/P PSTRONGlt;cfif PropertyName is not ""gt;/STRONG/P PSTRONGAND PropertyName LIKE '#PropertyName#%'/STRONG/P PSTRONGlt;/cfifgt;/STRONG/P PSTRONGlt;cfif StarRating is not ""gt;/STRONG/P PSTRONGAND StarRating gt;=3D '#StarRating#%'/STRONG/P PSTRONGlt;/cfifgt;/STRONG/P PSTRONGORDER BY activestatus asc, propertyname asc/STRONG/P PSTRONGlt;/CFQUERYgt;/STRONG/P PSTRONGlt;/cfifgt;/STRONG/P PFONT face=3DArialalso 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 DIVFONT color=3D#ff size=3D2i look forward to your = reply/FONT/DIV DIVFONT color=3D#ff size=3D2BRKind Regards/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2Claude RaiolaBRE-Mail: A=20 href=3D"mailto:[EMAIL PROTECTED]"info@internetgold= coastproperties.com.au/ABRWebsite:=20 A=20 href=3D"http://www.internetgoldcoastproperties.com.au"www.internetgoldco= astproperties.com.au/A/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2/FONTnbsp;/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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: help with CFIF conditions and sort orders
= 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 TOor 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" HTMLHEAD 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#ff DIVFONT color=3D#ff size=3D2FONT face=3DSystem size=3D2 PFONT face=3DAriala couple of quick questions/FONT/P PSTRONGlocally 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 Pnbsp;/P PSTRONGlt;cfif sortorder =3D 1gt;/STRONG/P PSTRONGlt;CFQUERY DATASOURCE=3D"australianaccomm"=20 NAME=3D"properties"gt;/STRONG/P PSTRONGSELECT */STRONG/P PSTRONGFROM Properties /STRONG/P PSTRONGWHERE /STRONG/P PSTRONGRegion like '#form.region#%' /STRONG/P PSTRONGlt;cfif PropertyName is not ""gt;/STRONG/P PSTRONGAND PropertyName LIKE '#PropertyName#%'/STRONG/P PSTRONGlt;/cfifgt;/STRONG/P PSTRONGlt;cfif StarRating is not ""gt;/STRONG/P PSTRONGAND StarRating gt;=3D '#StarRating#%'/STRONG/P PSTRONGlt;/cfifgt;/STRONG/P PSTRONGORDER BY activestatus asc, propertyname asc/STRONG/P PSTRONGlt;/CFQUERYgt;/STRONG/P PSTRONGlt;/cfifgt;/STRONG/P PFONT face=3DArialalso 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 DIVFONT color=3D#ff size=3D2i look forward to your = reply/FONT/DIV DIVFONT color=3D#ff size=3D2BRKind Regards/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2Claude RaiolaBRE-Mail: A=20 href=3D"mailto:[EMAIL PROTECTED]"info@internetgold= coastproperties.com.au/ABRWebsite:=20 A=20 href=3D"http://www.internetgoldcoastproperties.com.au"www.internetgoldco= astproperties.com.au/A/FONT/DIV DIVnbsp;/DIV DIVFONT color=3D#ff size=3D2/FONTnbsp;/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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.