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...
WebDNA ModulesA list of the currently available modules...
[biotype]BioType is a behavioral biometrics WebDNA function based on ADGS research and development (from version 8...
Tips and TricksA list of user-submitted tips ...
Technical Change HistoryThis Technical Change History provides a reverse chronological list of WebDNA changes...
Reuse the same code over and over again on your site with the [include] context...
WebDNA Google Map MashupGenerate a Google map with pins on your database addresses...
Check the Federal Government's Social Security databaseThe script on the page will check the federal government's social security database...
Removing whitespaceHow can I remove all whitespace entered by a user from an input box (ie card number)...
Database backupHow to make a backup of your databases...
How to setup CODA to work with WebDNA?This page will show graphically how to setup CODA as a WebDNA partner :-)...