Douglas Brown wrote:
> I think I have lost it and cannot seem to see the error of my ways..
>
> Invalid CFML construct found on line 156 at column 28. ColdFusion was looking
> at the following text:<p>Advertisements.zipcode
>
>
> <CFIF IsDefined("form.zip")
> and form.zip IS NOT ""
> and IsDefined("form.radius")
> and form.radius neq 0
> and len(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), "'")#)))>
> </CFIF>
>
>
> Thanks
>
> Doug
Well the first thing I see is that I have never ever tried to use a SQL
'IN' clause inside an <cfif...> conditional statement. Because I just
don't think that would work.
Personally I think I would try a listContains(), listContainsNoCase(),
listFind() or listFindNoCase() function for something like that.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327476
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
