The script on the page will check the federal government's social security database
numero = 206<html><head><title>Who's Dead?</title></head><body>[search db=people.db&geskudata=0][founditems][text]the_variables=stat=a[!][/!]&lastname=[lastName]&[!][/!]nt=exact&[!][/!]firstname=[firstName]&[!][/!]middlename=[middle]&[!][/!]ssn=[ssn]&[!][/!]zip=[zip]&[!][/!]ls=[state]&[!][/!]lc=[county]&[!][/!]lct=[city]&[!][/!]birth=[birthYear]&[!][/!]bmo=[birthMonth]&[!][/!]bda=[birthDay]&[!][/!]death=[deathYear]&[!][/!]dmo=[deathMonth]&[!][/!]issue=[issueState][/text][text show=F]strippedDown=[removeHTML][middle startafter=full-featured&endbefore=(initial)][!][/!][tcpconnect host=ssdi.rootsweb.ancestry.com&port=80][!][/!][tcpsend skipheader=T]POST /cgi-bin/ssdi.cgi?[the_variables] HTTP/1.0[UnURL]%0D%0A[/UnURL][!][/!]USER-AGENT: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)[UnURL]%0D%0A[/UnURL][!][/!][/TCPSend][!][/!][/tcpconnect][/middle][/removeHTML][/text]<br />[firstName] [lastName] is [showif [strippedDown]^foundCheck]alive![/showif][!][/!][hideif [strippedDown]^foundCheck]dead.[!][/!][replace db=people.db&eqskudatarq=[sku]]status=dead[/replace][/hideif]<br />[/founditems][/search]</body></html>---------------------------- Fields for people.db ----------------------------skufirstNamemiddlelastNamecitystatezipcountyssnstatusbirthYearbirthMonthbirthDaydeathYeardeathMonthissueStateHere's a handy page and database. The script on the page will go through every database record and Check the Federal Government's Social Security database and update the list to indicate which people in the database are deceased. Great for maintaining mailing lists.
<html>Patrick Mac Cormick
<head>
<title>Who's Dead?</title>
</head>
<body>
[search db=people.db&geskudata=0][founditems]
[text]the_variables=stat=a[!]
[/!]&lastname=[lastName]&[!]
[/!]nt=exact&[!]
[/!]firstname=[firstName]&[!]
[/!]middlename=[middle]&[!]
[/!]ssn=[ssn]&[!]
[/!]zip=[zip]&[!]
[/!]ls=[state]&[!]
[/!]lc=[county]&[!]
[/!]lct=[city]&[!]
[/!]birth=[birthYear]&[!]
[/!]bmo=[birthMonth]&[!]
[/!]bda=[birthDay]&[!]
[/!]death=[deathYear]&[!]
[/!]dmo=[deathMonth]&[!]
[/!]issue=[issueState][/text]
[text show=F]strippedDown=[removehtml][middle startafter=full-featured&endbefore=(initial)][!]
[/!][tcpconnect host=ssdi.rootsweb.ancestry.com&port=80][!]
[/!][tcpsend skipheader=T]POST /cgi-bin/ssdi.cgi?[the_variables] HTTP/1.0[unurl]%0D%0A[/UnURL][!]
[/!]USER-AGENT: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
[unurl]%0D%0A[/UnURL][!]
[/!][/TCPSend][!]
[/!][/tcpconnect][/middle][/removeHTML][/text]<br />
[firstName] [lastName] is [showif [strippedDown]^foundCheck]alive![/showif][!]
[/!][hideif [strippedDown]^foundCheck]dead.[!]
[/!][replace db=people.db&eqskudatarq=[sku]]status=dead[/replace][/hideif]<br />
[/founditems][/search]
</body>
</html>
---------------------------- Fields for people.db ----------------------------
sku
firstName
middle
lastName
city
state
zip
county
ssn
status
birthYear
birthMonth
birthDay
deathYear
deathMonth
issueState
DOWNLOAD WEBDNA NOW!
A list of available libraries for WebDNA...
AWS Raw WebDNA LAMP-Plus WebServerAmazon Web Services (AWS) README for Machine Image ID...
Download WebDNA ApplicationsWebDNA applications...
WebDNA reference...
Tips and TricksA list of user-submitted tips ...
Technical Change HistoryThis Technical Change History provides a reverse chronological list of WebDNA changes...
How to get rid of very long search strings...
How many working days?This small script finds the number of working days between two dates...
How to keep the text variable after a function has finishedBy default...
How old am I?You want to express an age in years given the dob (mm/dd/yyyy) and today's date...
How to create a RSS feedHow to create a RSS feed from yourdatabase on formation...
Find duplicate recordsFind duplicate records and do something with them...