Also, you may want to investigate Reactor for ColdFusion or Transfer. These
two Object Relational Models (ORM) provide you the ability to execute query
objects that can be used in cfscript.
Teddy
On 1/21/07, Eric Roberts <[EMAIL PROTECTED]> wrote:
>
> 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:267129
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
