Re: [WebDNA] unused database fields. . . .
This WebDNA talk-list message is from 2014
It keeps the original formatting.
numero = 111395
interpreted = N
texte = On Jun 19, 2014, at 8:00 AM, Rich Kwas
= wrote: > Added some new fields to an existing database. > on the website information is being entered into a payment form. >=20 > Some of the existing field names will not be used anymore in an = upcoming update. > These unused fields will no longer appear on the form. > BUT these old fields unused field names are being written into the = database. >=20 > example: > [type_of_ad] > [travel] > [city_based_in] >=20 > Why would this be happening? Undefined variables output as raw text.=20 > I'm pretty sure I have unused fields in other sites but never had this = happen until this project. >=20 > Narrowed down all other possibilities causing this and its just the = unused fields being written this way. >=20 > These unused fields are still being "appended" to the existing db, = even though they don't appear on the form anymore and there is no actual = data to append.=20 >=20 > Should these field names be written into the database if the field = doesn't appear on the form BUT that field name is still in the append = code? >=20 >=20 > Here is how two of the unused fields are being appended: > firstname > lastname >=20 > [append = db=3D^/membership/advertising.db]uniqueID=3D[cart]&submit_date=3D[date]&su= bmit_time=3D[time]&submit_ip=3D[ipaddress]&firstname=3D[url][firstname][/u= rl]&lastname=3D[url][lastname][/url][/append] >=20 > firstname & lastname do not appear on this form anywhere. Rich, maybe restate your question clearer. I=92m confused :-) Sincerely, Donovan
Associated Messages, from the most recent to the oldest:
On Jun 19, 2014, at 8:00 AM, Rich Kwas = wrote: > Added some new fields to an existing database. > on the website information is being entered into a payment form. >=20 > Some of the existing field names will not be used anymore in an = upcoming update. > These unused fields will no longer appear on the form. > BUT these old fields unused field names are being written into the = database. >=20 > example: > [type_of_ad] > [travel] > [city_based_in] >=20 > Why would this be happening? Undefined variables output as raw text.=20 > I'm pretty sure I have unused fields in other sites but never had this = happen until this project. >=20 > Narrowed down all other possibilities causing this and its just the = unused fields being written this way. >=20 > These unused fields are still being "appended" to the existing db, = even though they don't appear on the form anymore and there is no actual = data to append.=20 >=20 > Should these field names be written into the database if the field = doesn't appear on the form BUT that field name is still in the append = code? >=20 >=20 > Here is how two of the unused fields are being appended: > firstname > lastname >=20 > [append = db=3D^/membership/advertising.db]uniqueID=3D[cart]&submit_date=3D[date]&su= bmit_time=3D[time]&submit_ip=3D[ipaddress]&firstname=3D[url][firstname][/u= rl]&lastname=3D[url][lastname][/url][/append] >=20 > firstname & lastname do not appear on this form anywhere. Rich, maybe restate your question clearer. I=92m confused :-) Sincerely, Donovan
Donovan Brooke
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:
[input] [/input] (1997)
Dark Horse Comics success story (1997)
[WebDNA] Write uploaded file with same name (2020)
Linux Install Question (2000)
Why isn't this working (1999)
Hard Questions ? (1997)
Upgrading old WebCat Database Files (1997)
Word search (1997)
New NT beta available (1997)
showcart is slow (1998)
Nesting WebDNA in JavaScript (2003)
frames & carts (1997)
Emailer Error 550 (Was Strange Crash) (1998)
Practical Uses (2003)
WebCatalog2 Feature Feedback (1996)
[include] and v.email (1998)
NetSplat and WebCat2 (1997)
Where can I download to test? (2003)
Sku numbers (1997)
webcat2b12 CGI -- Date comparisons (1997)