selectively replacing records within a [founditems]
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26296
interpreted = N
texte = If I want to replace a record of a db within a [founditems] context which finds that same record, and I have all the fieldname/value pairs in the [replace] context equal to themselves (i.e. the values of the db fields are set to equal those found by the search context), but I want to replace a few of the db field's values WITHOUT having to use names for the formvariables which are NOT the same as the db fieldname, then do you think using the following technique is reliable and recommended? -(extra carriage returns thrown in for readability)[Founditems] [replace db=Orders.db&eqOrderIDdatarq=[OrderID]] StaticVar1=[StaticVar1] &StaticVar2=[StaticVar2] &StaticVar3=[StaticVar3] &ChangingVarValue1=[URL][FormVariables name=ChangingVarValue1&exact=T][value][/FormVariables][/URL] [/replace] [/Founditems]Will that always ensure that I get the value that was passed from the form in for ChangingVarValue1, rather than the value for ChangingVarValue1 that was already in the db?-John ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
If I want to replace a record of a db within a [founditems] context which finds that same record, and I have all the fieldname/value pairs in the [replace] context equal to themselves (i.e. the values of the db fields are set to equal those found by the search context), but I want to replace a few of the db field's values WITHOUT having to use names for the formvariables which are NOT the same as the db fieldname, then do you think using the following technique is reliable and recommended? -(extra carriage returns thrown in for readability)[founditems] [replace db=Orders.db&eqOrderIDdatarq=[OrderID]] StaticVar1=[StaticVar1] &StaticVar2=[StaticVar2] &StaticVar3=[StaticVar3] &ChangingVarValue1=[url][FormVariables name=ChangingVarValue1&exact=T][value][/FormVariables][/URL] [/replace] [/Founditems]Will that always ensure that I get the value that was passed from the form in for ChangingVarValue1, rather than the value for ChangingVarValue1 that was already in the db?-John ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
John Butler
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:
Two submit buttons ? (1997)
Summary search -- speed (1997)
[urgent] Phone number at SM (2006)
Running _every_ page through WebCat ? (1997)
emailer (1997)
Multiple catalog databases and showcart (1997)
RE: New WebCatalog Version !!! (1997)
Webcat/Webmerchant part II (1998)
This is probably a stupid question... (2004)
Database Fields (1997)
Anyone using WebCat UNIX on a busy server yet? (1999)
GuestBook example (1997)
email messages (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
Redirect from Domain1 to Domain2 (2004)
WCS Newbie question (1997)
Thanks ! (1997)
SendNews (1999)
Fuzzy on [url] context (1998)
pop up building with summarize (1998)