Zip Code Lookup

Thank you sir. You guys are great!

That's close to what I was thinking, but you've simplified a step. I'll probably be back with more questions on the details, but I think I can get most of the way there.

Thanks again!
Joe

how's this for a logic flow:

user enters an address into the form field and submits the form.

the form;s action page looks up the zip code for the submitted address,
and if, found, looks up all candidates in your db based on that zip.
you either output 'sorry, no zip/candidates found' or a form with a
textarea to enter/edit the message to be sent. in a hidden field in the
form store the list of candidate ids retrieved from your db.

the user edits the message text and submits the form.

you use the candidate ids from the form;s hidden field to lookup their
emails and send them the user's message using cfmail.

you can substitute session var for the hidden form field if you want to.
you can even just store the retrieved zip code in the session var/hidden
form fields instead of candidates' ids and just do another db lookup for
candidates' emails based on the zip code after the user submits the
message to be sent.

form variables (field values) are accessed on the action page using
#form.fieldname#. i suggest you stick to form variables instead of url
variables (use method=post instead of get in your forms).

hth

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

<cfset zipCode =
replace(addressObj["ResultSet"]["Result"]["Zip"].XmlText, '-', '', 'all')>

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

All right, I was hoping I could figure out the application flow here, but in the interest of saving time I'm gonna ask for suggestions on that too... No code examples needed (unless you want), I'm just looking for basic ideas. I need to:

1. Take a form-entered street address and find zipcode (got this part working already.)
2. Use that zipcode in a sql query that returns a recordset of all candidates for that district.
3. Use cfmail to send an email to all those candidates with one click.

I'm naturally using URL variables to pass the street address to a results page now. How do I turn that zip code result into another variable that I can use in a sql query? Would I make it another URL variable and pass it to another page? That'd be ok, but how can I do that without requiring the user to click another button?

I've got an idea of where to go from there, though there's probably a more elegant way. I was just gonna set those returned email addys as variables, and use them in a hidden form field of the form with the sample email message. Users can alter that as they wish, and when they click "submit" all that stuff will pass as URL variables to the "thank you" page which will run the cfmail and send the message to those addresses.

What do you think?

Thanks again for any suggestions...
Joe

Ok... I'm having trouble making the replace() function work with the #zipcode# variable. Any chance someone could post an example using BKBK's original code from above:

<cfhttp url=" http://local.yahooapis.com/MapsService/V1/geocode?appid=vmuNNhtDEr32Ms8pmwEyvoAdClQQabcploMMth2iY_GXMK456Mruav56P09iuQk7.BBFtC--&street=65+Commercial+St&city=Portland&state=ME" method="get" throwonerror="false" timeout="5">
<!--- <cfdump var="#cfhttp.FileContent#"> --->
<cfxml variable="addressObj">
<cfoutput>#cfhttp.FileContent#</cfoutput>
</cfxml>
<cfset zipCode = addressObj["ResultSet"]["Result"]["Zip"].XmlText>
Zip Code (Hilton Garden Inn Hotel, Portland, Maine): <cfoutput>#zipCode#</cfoutput>

Thanks...

Well... I have now, thanks! I knew there'd be a simple way.

I apologize for the dumb questions. I'd ordinarily research this stuff on my own, but this app is pretty time-critical. I'm just doing it as a favor but I still feel responsible for getting it done quickly... so I really appreciate everyone's help.

have you heard the cf's replace() function?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

Ok, I've got a basic version of this working. Thanks again, BK.

Is there a way to strip the hyphen out of the zip code by chance? The database the last developer built has the zips as 9 digit intgers with no formatting. It'd be easier to match if I could pull the hyphen out of the Yahoo result.

If not, they're close enough and I'll make it work.
Thanks again!
Joe

Hey, THANKS, BK.

I was doing a little digging myself into the Yahoo APIs, and you've answered my next question before I even asked it.

I don't 100% understand your post because I'm not real familiar with xml, but it looks pretty straightforward. I'm gonna study up on it tonight and see where I'm at.

It's funny... the PHP code that accomplishes basically the same as your example is like 3 pages long. I don't know if that's due to the developer who wrote it, or just the fact that it's PHP, but the CF looks soo much simpler.

One question, before I get too far into this and then realize I'm chasing a dead end: can you confirm that this Yahoo service will return a full zipcode with JUST a street address entered, and NO zipcode? For instance, in your example, "65 Commercial st., Portland, ME" run through the service will return the full zip?

If so, awesome, I might actually be able to do this!

Joe

Yeah, see, that's the problem. The districts in Maine don't always fracture along 5 digit zip codes... you need the WHOLE thing or you risk people sending email to candidates that don't represent them. The page is currently designed to run a PHP script that actually works: you enter your street address: "1234 My St., Portland, ME" and it automatically finds your full zipcode and displays your candidates. Apparently the client is stuck on this functionality.

So the PHP script is working. It looks to use an online database or service here: " http://local.yahooapis.com/MapsService/V1/geocode".

The problem is, so much of the rest of the site is a mess, and I can't fix the PHP, that I was hoping to port this capability over to CF. I'd gladly buy a CF component to do this, if someone has one.

Thanks for ANY ideas...
Joe