>>Hmmm, download voter registration? Not aware of that. Off duty policemen can do anything they want within the law. I already had the voter registration file, which was purchased by a candidate. Try again.<g>
>
>And your not comparing to to confidential info in the DMV database or other taxpayer owned databases? (is this a good try:-)
Nope passing the address to a webpage and parseing the returning html.
Heck, it ain't rocket science so here's the gist of it:
lcurl=[http://www.whitepages.com/10692/search/Reverse_Address?housenumber=]+ALLTRIM(m.house_num)+[&street=]+ALLTRIM(m.vstrname)+[&city_zip=bartlett&state_id=TN]
oie.Navigate(lcurl)
DO WHILE oie.readystate<>4
enddo
DO WHILE oie.document.readystate<>'complete'
enddo
lc=oie.document.body.innertext
IF OCCURS('901)',lc)>0
m.phone= SUBSTR(lc,AT('901',lc)+5,8)
?M.PHONE+' '+ALLTRIM(first_name)+' '+ALLTRIM(LAST_NAME)
GATHER MEMVAR FIELD PHONE
ENDIF
RETURN m.phone
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright