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:
No Subject Line (2000)
[SQL] & ODBC on Mac (2000)
New commands in Final candidate (1997)
Directory Overload (1998)
Online reference (1997)
Bug Report, maybe (1997)
[movefile] (1999)
Emailer problem....still (1997)
Cart questions (1997)
WC2b15 File Corruption (1997)
WebCatalog for Postcards ? (1997)
off topic