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:

country of origin from IPADDRESS??? (2001) problems with 2 tags (1997) I forgot (1998) Ken Grome (2006) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) MacActivity and PCS (1997) Help! Error: Help! I'm stuck: Can't open order file. Ignoring [OrderFile] context (2000) text variables... weigh much? (2004) [WebDNA] Creating XML on the fly (2011) Major Security Hole IIS NT (1998) [ListFiles] context & alias (1997) Shopping Cart variation... (1997) 4.02 release 10/1 (2001) Default contains WEBDNA (1998) default value from Lookup (was Grant, please help me) (1997) Support ?? (1997) WriteFile is there a max size? (1998) serial number generation (1997) Help name our technology! I found it (1997) question: search return in order (1997)