The three uses of APPLICATION.DBPRE are invalid; hash-wrapped juxtaposition is not valid for concatenation except within quoted strings.
cheers, barneyb On Wed, Oct 21, 2009 at 2:20 PM, Douglas Brown <[email protected]> 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
