Oops, I guess I should have read the entire statement and I would have seen
the passedradius variable.

-----Original Message-----
From: Scott Weikert [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 25, 2003 3:18 PM
To: SQL
Subject: Re: zipcode search problem

At 03:05 PM 8/25/2003 -0500, you wrote:
>I read the zip code radius article here http://tutorial153.easycfm.com/ 
>. I can now query the database and get records back but not within the 
>specified miles. I'm sure it has something to do with this part of the
statement.
>(#form.passedradius#/111) Any ideas of what I need to change?

You forgot the / after the variable and before the '111'.

>(#form.passedradius#//111)


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:6
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

                        

Reply via email to