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:267080
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
