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 properly and be faster, too:[replace db=classifieds.db&equniqueiddata=[form.uniqueid]]Yes=[math][lookup db=classifieds.db&value=[form.uniqueid]&lookinfield=uniqueid&returnfield=Yes¬ found=]+1[/math][/replace] Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html Associated Messages, from the most recent to the oldest:

    
  1. Re: Replace Statement (Damien Joldersma 1997)
  2. Re: Replace Statement (Kenneth Grome 1997)
  3. Re: Replace Statement (Grant Hulbert 1997)
  4. Re: Replace Statement (Damien Joldersma 1997)
  5. Re: Replace Statement (Kenneth Grome 1997)
  6. Replace Statement (Damien Joldersma 1997)
>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 properly and be faster, too:[replace db=classifieds.db&equniqueiddata=[form.uniqueid]]Yes=[math][lookup db=classifieds.db&value=[form.uniqueid]&lookinfield=uniqueid&returnfield=Yes¬ found=]+1[/math][/replace] Sincerely, Ken Grome WebDNA Solutions http://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:

PCS Frames (1997) multiple front end servers (2004) [URL] around a [sendmail] recipient? (2000) Practice runs ? (1997) [LOOKUP] (1997) Not really WebCat- (1997) [taxRate] [TaxTotal] ? (1997) vs (1997) VeriSign News (2002) PCS Emailer's role ? (1997) Loops and [index] (1998) [WebDNA] Search using CL (2017) Showif ~ Netscape : Showif ~ MSIE (2001) [WebDNA] behavior of [thisurl] in the context of 'mod_rewrite' (2012) Search for 20 finds 2000, 200 Why? (1997) Emailer (1997) WCS Newbie question (1997) Default admin bug and how tech support reacted to it. (2000) no global [username] or [password] displayed ... (1997) No luck with taxes (1997)