A dynamic database.
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12941
interpreted = N
texte = Hi guys,I'm still having problems with searching through a database ofEmail addresses.Here's what I'd like to do:I would like to have a visitor enter their Email address.I would [appendfile] that Email address to an account.log file.Then if they ordered something, I would [Search] the account.log.If the [Search] returned a [numFound] greater then one, I wouldshow them a so glad to see you again screen and not allow themthe to receive the First-Time-Shopper discount. If it returneda [numFound] less than or equal to one, I would show them a welcomeFirst-Time-Shopper screen and the big discount.Here's my problem:When I search the account.log, the search returns only the valuesthat were present in the account.log when WebSTAR last started up.If I open the account.log, I see the appended Email address.If I restart WebSTAR the search finds the new Email addresses butwill not find addresses entered thereafter.Below, is my test page. (It is named test6.tmpl so it collectsthe address on the first call then calls itself for the search/results.)--------------------------------snip-----------------------------------
[Search db=account.log&eqEMAILdata=[email]]The search found [NumFound] addresses.
On a search for [email][/Search][appendfile account.log][email] [name] [address1] [address2] [city][state] [zip] [ipaddress] [date] [TIME][/appendfile]--------------------------------snip-----------------------------------Here's my question:Can a database be appended, searched, appended, searched...and the results reflect the last update/append, be it only seconds ago?A dynamic database.-- Eddie SchriefferThe Creative EdgeSpartanburg, SC864.585.3343
Associated Messages, from the most recent to the oldest:
Hi guys,I'm still having problems with searching through a database ofEmail addresses.Here's what I'd like to do:I would like to have a visitor enter their Email address.I would
[appendfile] that Email address to an account.log file.Then if they ordered something, I would
[search] the account.log.If the
[search] returned a [numFound] greater then one, I wouldshow them a so glad to see you again screen and not allow themthe to receive the First-Time-Shopper discount. If it returneda [numFound] less than or equal to one, I would show them a welcomeFirst-Time-Shopper screen and the big discount.Here's my problem:When I search the account.log, the search returns only the valuesthat were present in the account.log when WebSTAR last started up.If I open the account.log, I see the appended Email address.If I restart WebSTAR the search finds the new Email addresses butwill not find addresses entered thereafter.Below, is my test page. (It is named test6.tmpl so it collectsthe address on the first call then calls itself for the search/results.)--------------------------------snip-----------------------------------
[Search db=account.log&eqEMAILdata=[email]]The search found [NumFound] addresses.
On a search for [email][/Search][appendfile account.log][email] [name] [address1] [address2] [city][state] [zip]
[ipaddress] [date] [time][/appendfile]--------------------------------snip-----------------------------------Here's my question:Can a database be appended, searched, appended, searched...and the results reflect the last update/append, be it only seconds ago?A dynamic database.-- Eddie SchriefferThe Creative EdgeSpartanburg, SC864.585.3343
Eddie Schrieffer
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Great product and great job ! (1997)
Simple Database close connection (2001)
Associative lookup style? + bit more (1997)
syntax question, not in online refernce (1997)
2.0 Info (1997)
How do I send a 404 HTTP header ? (2004)
Another Large Database Questions (1997)
iis 4.0 (1997)
cybercash on OSX - was Executing remote AppleScript (2000)
Re[2]: Support suggestions - long (was politeness, et al) (2000)
searching with if/then (2004)
Options for http uploading of files (1999)
Shared conversion under WebTen (1998)
Problems with Price field (1997)
Dreamweaver Extensions (2001)
my price won't move (1997)
File Upload (1997)
won't serve .tpl -index.tpl gone, made test.tpl (2000)
OT: Typhoon (1998)
WebCat Bulletin Board Solution ? (1998)