Can anyone see the problem here?

2009-10-21 Thread Douglas Brown
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:pAdvertisements.zipcode CFIF IsDefined(form.zip) and form.zip IS NOT and IsDefined(form.radius) and form.radius

Re: Can anyone see the problem here?

2009-10-21 Thread Barney Boisvert
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 mistobr...@gmail.com wrote: I think I have lost it and cannot seem to see the error of my

Re: Can anyone see the problem here?

2009-10-21 Thread Ian Skinner
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:pAdvertisements.zipcode CFIF IsDefined(form.zip) and form.zip IS NOT and

Re: Can anyone see the problem here?

2009-10-21 Thread s. isaac dealey
Try this: cfset ads = evaluate(#application.dbpre#Advertizements) / 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 ( listfind(valuelist(results.zip),ads.zipcode) or