Skip to main content
Known Participant
October 4, 2008
Question

Zip Code Lookup

  • October 4, 2008
  • 11 replies
  • 1272 views
Hi guys,

Ok, I've had a project dumped on me that is ridiculously complicated given my level of ability. I've explained to them that I am NOT the guy for this. They're in a real jam though, so while they're trying to find someone else I told them I'd see what I can do.

Basically, it's a political action page. You watch a short flash video, then click a button to send email to the candidates running to represent you. It's been built (kind of) using PHP by someone else, but has so many bugs (and I don't know anything about PHP) that I think my only hope is to try and re-write the whole thing in Coldfusion (which I know the basics of).

Thankfully the mySQL database is already done and working. I just need to build the pages. The real sticking point: on the "tell a candidate" page, they want a user to fill out their street address, click a button, and have the application automatically find their full zipcode and then display a page listing the candidates running to represent that district (this is limited to one state, thank god).

I can handle the database-driven stuff to return email links for their candidates (I think)... but how can I use Coldfusion to find a person's full zipcode based on their street address?

Thanks for ANY ideas... the more dumbed-down the better!
Joe
    This topic has been closed for replies.

    11 replies

    Inspiring
    October 5, 2008
    > I can handle the database-driven stuff to return email links for their
    > candidates (I think)... but how can I use Coldfusion to find a person's
    > full
    > zipcode based on their street address?

    Well there are people that sell this type of information,
    http://www.zip-codes.com/zip-code-database.asp
    but these days, everyone knows their zip code (at least the first 5) and
    I would convince the client to skip the zip code look up and go straight to
    the candidate look up based on zip code.