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:
Email within tmpl ? (1997)
Error: this shopping cart has already been submittedm (2004)
[WriteFile] problems (1997)
WriteFile Command (1998)
Proper file locations (1997)
Slightly OT - SQL- Clustering (2006)
Setting up shop (1997)
RE: automatic reload of frameset (1997)
listing [text] variables? (1999)
[COMMITDATABASE FileName] (2000)
[WebDNA] Show next..... (2010)
Aaron kant add (or whatever it was) (2000)
Is this possible in simple search? question? (1998)
WebCat2 beta 11 - new prefs ... (1997)
Greater then less then (2001)
Using Webcatalog to write a search engine.... (2001)
Mem per threads (1998)
emailer w/F2 (1997)
Javascript Stored in a Database (2003)
WebDNA dying or ... ? (2005)