Re: logic help

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 17995
interpreted = N
texte = >I have a list of found records that I want to update all at once. I have>them listed seperately where mid=member id number>>[founditems]>>>Active>Inactive>>[/founditems]>>form submits>>Now I need to update each mid and my logic is failing.>>[loop start=1&end=[records]&advance=1]>[replace>db=memberinfo.db&eqmiddata=[math][mid[index]][/math]]status=[status][/repla>ce]>[Name] updated>[/loop]Hi Bob,You're creating several mid[index] and status[index] values in the form, but you're only using the mid[index] values in the replace context. I also think this is one of those situations where you need to put your nested varuables into [interpret] contexts instead of that [math] context. I believe this should work for you:[loop start=1&end=[records]][replace db=memberinfo.db&eqmiddata=[interpret][mid[index]][/interpret]]status=[interpret][status[index]][/interpret][/replace][Name] updated
[/loop]Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net Associated Messages, from the most recent to the oldest:

Re: Logic Help Needed (Tim Robinson 2003) Re: Logic Help Needed (Clint Davis 2003) Re: Logic Help Needed (John Peacock 2003) Logic Help Needed (Clint Davis 2003) Re: logic help (Kenneth Grome 1998) logic help (bob 1998) Re: logic help (Rob Marquardt 1998)

>I have a list of found records that I want to update all at once. I have>them listed seperately where mid=member id number>>[founditems]>>>Active>Inactive>>[/founditems]>>form submits>>Now I need to update each mid and my logic is failing.>>[loop start=1&end=[records]&advance=1]>[replace>db=memberinfo.db&eqmiddata=[math][mid[index]][/math]]status=[status][/repla>ce]>[Name] updated>[/loop]Hi Bob,You're creating several mid[index] and status[index] values in the form, but you're only using the mid[index] values in the replace context. I also think this is one of those situations where you need to put your nested varuables into [interpret] contexts instead of that [math] context. I believe this should work for you:[loop start=1&end=[records]][replace db=memberinfo.db&eqmiddata=[interpret][mid[index]][/interpret]]status=[interpret][status[index]][/interpret][/replace][Name] updated
[/loop]Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net 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:

upgrading (1997) Draft Manual, Tutorial, and more (1997) Searching for Email Address (2004) Suffix Mapping (1998) Shared conversion under WebTen (1998) Grouping search fields, etc. (1997) Navigator 4.01 (1997) more info on [setlineitems] (1997) Cookies and webcat (1997) [OT] DOD again *MYSTERY SOLVED* (2003) 2nd WebCatalog2 Feature Request (1996) Frames and WebCat (1997) Next X hits (1996) Web*3 virtual hosting Webcatalog problem (1998) html delivery (1997) Images in Globals? (2003) WebDNA Solutions ... (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Just Started (1998) To Do list (2003)