reverse phone number lookup as part of a query?

• ericb1

  SSCrazy

  Points: 2354

  More actions

  August 11, 2008 at 1:47 pm

  #70635

  Not sure if this is possible, but I thought it would be cool. I have a db table of received faxes (date, time, number of pages, callerID, etc). But it only lists the number, not the callerID name.

  Is there a way as part of a query that I show back to my users to do a reverse phone number lookup somwhere, and then be able to search on not just the phone number, but the name also?

  Any suggestions are welcome, thanks!

• Greg Snidow

  SSCoach

  Points: 16108

  More actions

  August 11, 2008 at 2:01 pm

  #856358

  Do you have a table linking phone number to name?

  Greg
  _________________________________________________________________________________________________
  The glass is at one half capacity: nothing more, nothing less.

• ericb1

  SSCrazy

  Points: 2354

  More actions

  August 11, 2008 at 3:39 pm

  #856411

  Thanks for the reply, no I don't have a name table at all, just the phone number. I was thinking of somehow using a reverse phone number site like Google's phonebook function to return the name based off the number, so

  First I do some sort of google query:

  http://www.google.com/search?hl=en&pb=r&q=phonebook%3A+6105551212&btnG=Search+PhoneBook

  and get the result of the name, and put it into my query results so that my sql has this result matched to the name.

  I guess getting the name out of google and into my query is the hard part. Thanks again!

• Greg Snidow

  SSCoach

  Points: 16108

  More actions

  August 11, 2008 at 8:13 pm

  #856457

  I do know that the incument telcos provide this data to third party companies, like 411.com, and CLECs, for a fee. If you are in the US, You might try finding out if you could get it.

  Greg
  _________________________________________________________________________________________________
  The glass is at one half capacity: nothing more, nothing less.