Try
<CFSCRIPT>
If (IsDefined("form.zip") and form.zip neq 0 and IsDefined("form.radius")
and form.radius neq 0 and len(trim(form.zip)) eq 5)
and ( #APPLICATION.DBPRE#Advertisements.zipcode in
(#ListQualify(ValueList(results.zip),"'")#)or
(#APPLICATION.DBPRE#Advertisements.city in
(#listQualify(ValueList(results.city),"'")#) and
#APPLICATION.DBPRE#Advertisements.State in
(#listqualify(valuelist(results.State), "'")#)));
{insert action here...}
</CFSCRIPT>
You had a curly brace before the and...
-----Original Message-----
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Sunday, 21 January 2007 08:52
To: CF-Talk
Subject: <cfscript>?
I am screwing around with<cfscript> for the first time and had a question.
Is this possible in a query? It looks like it does not like the "AND"
portion.
<CFSCRIPT>
If (IsDefined("form.zip") and form.zip neq 0 and IsDefined("form.radius")
and form.radius neq 0 and len(trim(form.zip)) eq 5){
and ( #APPLICATION.DBPRE#Advertisements.zipcode in
(#ListQualify(ValueList(results.zip),"'")#)or
(#APPLICATION.DBPRE#Advertisements.city in
(#listQualify(ValueList(results.city),"'")#) and
#APPLICATION.DBPRE#Advertisements.State in
(#listqualify(valuelist(results.State), "'")#)));
}
</CFSCRIPT>
Doug B.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267101
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
