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:

Protect (1997) autosensing lanague selection (1997) stripping extra spaces from form fields (2000) Email within tmpl ? (1997) EMailer - WebSTAR V - OSX - WebDNA (2003) formula??? (2000) WebCat 3.04-3.07 plug-in dying on server.... (2000) Email Format (1998) [OT] Templates (For Sale) sites (2004) Search Context Strips URL chrs.? (1999) Am I going senile? (Price recalc based on quantity) (1997) Append problem w/" (1999) [WebDNA] Cent 7 - FCGI version 8.5 - NGINX (2016) funky character (2002) Setting up shop (1997) WebDNA with WebStar V (2003) Re:no [search] with NT (1997) Zeroing out shipping costs (2000) [WebDNA] [ot-security] Heartbleed bug (2014) Using Eudora instead of Emailer, and cron facility (1998)