August 11, 2008 at 1:47 pm
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!
August 11, 2008 at 2:01 pm
Do you have a table linking phone number to name?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 11, 2008 at 3:39 pm
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!
August 11, 2008 at 8:13 pm
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply