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 thatsame record, and I have all the fieldname/value pairs in the [replace] context equalto themselves (i.e. the values of the db fields are set to equal those found by thesearch context), but I want to replace a few of the db field's values WITHOUT havingto use names for the formvariables which are NOT the same as the db fieldname, thendo 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][FormVariablesname=ChangingVarValue1&exact=T][value][/FormVariables][/URL][/replace][/Founditems]Will that always ensure that I get the value that was passed from the form in forChangingVarValue1, rather than the value for ChangingVarValue1 that was already inthe 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 thatsame record, and I have all the fieldname/value pairs in the [replace] context equalto themselves (i.e. the values of the db fields are set to equal those found by thesearch context), but I want to replace a few of the db field's values WITHOUT havingto use names for the formvariables which are NOT the same as the db fieldname, thendo 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][FormVariablesname=ChangingVarValue1&exact=T][value][/FormVariables][/URL][/replace][/Founditems]Will that always ensure that I get the value that was passed from the form in forChangingVarValue1, rather than the value for ChangingVarValue1 that was already inthe 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:
[WebDNA] writing pdfs on the fly (Avery labels #5160) (2010)
WebDNS and RSS (2003)
Page Breaks (1999)
problem serving foreign languages text (1997)
Great product and great job ! (1997)
Using MySQL and WebDNA (2004)
pc (1997)
[WebDNA] Decode Base64 Image (2019)
summarizing multiple fields (2000)
Closing db's & caching templates (was: Shippingcalculations) (1997)
2.0 Beta (1997)
Database Upload (2000)
where to put code (1998)
Searching Multiple Databases (2000)
Location of Browser Info.txt file (1997)
WebCat2: Items xx to xx shown, etc. (1997)
blank page from template (1997)
5.0 Pricing (2003)
PCS Emailer's role ? (1997)
WebCatalog2 Feature Feedback (1996)