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:
Pithy questions on webcommerce & siteedit (1997)
Re:WebCatalog/WebMerchant III (1998)
WCS Newbie question (1997)
All choices on IE different than Netscape (1997)
Keep away (1997)
[BULK] [WebDNA] [BULK] WebDNA AJAX example wanted! (2010)
[ot] Raid Cards for RH ES (2004)
Not really WebCat- (1997)
Million product store (2003)
HTTP header line is too long? (1997)
For those of you not on the WebCatalog Beta... (1997)
Date Question (2002)
email error 159 (1998)
calculating tax rates, mail order solutions and version 2 (1997)
PIXO (1997)
Help with Repost Data msg from form (1997)
Sample Email Catalog Order? (1998)
Shipcost update problem (1997)
Pirated WebCat? NOT... (2003)
TCP/IP connect (1998)