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:

Merging databases (1997) Separate SSL Server (1997) X etc.... (1999) Close-to Comparison Code (1998) [protect] on NT? (1997) Filemaker Pro Template for Orders (1999) Lookup Notfound (1998) Pre-flight public flag (1997) Multiple catalog databases and showcart (1997) Https not showing products (2004) lookup and two records? (1997) MATH PROBLEM (1997) Problem with Showif & Applescript (1997) MacAuthorize and WebMerchant (1997) [WebDNA] Fwd: RETS... HELP! (2009) Editing webDNA in a textarea (2007) Opinion: [input] should be called [output] ... (1997) Did you hear about this? (1997) Maximum characters in header? (1999) Chatroom (2000)