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:
HELP WITH DATES (1997)
Make sure I understand this??? (1997)
Email Format (1998)
Text data with spaces in them... (1997)
Thanks ! (1997)
WebCat2b13MacPlugIn - [include] (1997)
search form problem.. (1997)
extended ASCII with middle command (1999)
New Beta Documentation (1997)
For those of you not on the WebCatalog Beta... (1997)
Possible Shownext from Listfiles???? (2000)
webcat crashes when using groups (1999)
multiple record replace (2001)
Close-to Comparison Code (1998)
Form and Context Searching -Hideif/Showif (2000)
Request for page test (2003)
Separate SSL Server (1997)
IE problems persist (2004)
Multiple prices (1997)
Appending space (1998)