Re: Replace Statement
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13302
interpreted = N
texte = >Can anyone figure out why this is not replacing the record properly?>The 3 variables at the bottom are to show that they are getting the>right information (which they are), but it's not updating my db, its in>the right folder. I can't get it to replace any of the fields period.>>Any suggestions would be grateful. THANK YOU!>[search db=classifieds.db&eqUniqueIdData=[form.uniqueid]]> [founditems]> > [/founditems]>[/search]>[replace>db=classifieds.db&eqUniqueIdData=[form.UniqueId]]Yes=[math]newyes[/math][/repla>ce]Hi Damien,Here's a simplified version of your WebDNA that should work properlyand be faster, too:[replacedb=classifieds.db&equniqueiddata=[form.uniqueid]]Yes=[math][lookupdb=classifieds.db&value=[form.uniqueid]&lookinfield=uniqueid&returnfield=Yes¬found=]+1[/math][/replace]Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html
Associated Messages, from the most recent to the oldest:
>Can anyone figure out why this is not replacing the record properly?>The 3 variables at the bottom are to show that they are getting the>right information (which they are), but it's not updating my db, its in>the right folder. I can't get it to replace any of the fields period.>>Any suggestions would be grateful. THANK YOU!>[search db=classifieds.db&eqUniqueIdData=[form.uniqueid]]>
[founditems]> [math]NewYes=[Yes]+1[/math]>> [/founditems]>[/search]>[replace>db=classifieds.db&eqUniqueIdData=[form.UniqueId]]Yes=
[math]newyes[/math][/repla>ce]Hi Damien,Here's a simplified version of your WebDNA that should work properlyand be faster, too:[replacedb=classifieds.db&equniqueiddata=[form.uniqueid]]Yes=
[math][lookupdb=classifieds.db&value=[form.uniqueid]&lookinfield=uniqueid&returnfield=Yes¬found=]+1[/math][/replace]Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html
Kenneth Grome
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:
A little help on e-mail (HELP!!! :-) ) (1998)
[WebDNA] Crashing Database (2011)
A Global Variable (1997)
Custom WebCat Prefs ... (1997)
New Site Announcement (1998)
too many nested [xxx] (1997)
[OT] HTML lists and IE (2007)
Problems getting parameters passed into email. (1997)
email error msgs and log (2005)
Maybe off topic but how to charge (1997)
Secure Server (1997)
Sendmail problem (2002)
php vs WebCatalog (2000)
javascript newPopwin and webcat (1998)
Bug or syntax error on my part? (1997)
Can't Update records (1997)
Converting SQL Microtime to Date and Time (2003)
[WebDNA] limit found per row (2011)
Trouble with Netscape (1998)
user flush db (2002)