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...
Technical Change HistoryThis Technical Change History provides a reverse chronological list of WebDNA changes...
Download WebDNA ApplicationsWebDNA applications...
F.A.QA compilation of some user's questions...
[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 ...
The [interpret] context is very powerful command in the hands of a skilled WebDNA programmer...
PayPal gateway...
Find duplicate recordsFind duplicate records and do something with them...
WebDNA interaction with zipI have a project where I'm allowing several people to upload images...
Database backupHow to make a backup of your databases...
How to create a RSS feedHow to create a RSS feed from yourdatabase on formation...