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:

Navigator Parsing (1997) Quit revisited (1997) possible, WebCat2.0 and checkboxes-restated (1997) A Global Variable (1997) getchars broken? (1997) possible bug in unix version? (2000) [Fwd: Rotating Banners ... (was LinkExchange)] (1997) Grouping search fields, etc. (1997) ASP and WebDNA (1998) What am I missing (1997) HELP WITH DATES (1997) [WebDNA] Processor usage off the charts (2008) Access Denied! But why? (1997) quotation marks (2004) Sendmail double space (2001) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WebCatalog 2.1b3 - Plugin or cgi ? (1997) [LOOKUP] (1997) Emailer choke (1997) textarea to page display (1998)