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:
Multi Actions (1999)
[Announce]: Web server security and password protection (1997)
Another bug -- in the docs ... (2002)
too many nested tags ... (1997)
All of a Sudden Type 2 errors (1999)
Running _every_ page through WebCat ? (1997)
Using [Include] Context (1999)
Pithy questions on webcommerce & siteedit (1997)
Creating comums (1998)
Summing fields (1997)
WebCommerce: Folder organization ? (1997)
Communigate (2001)
[WebDNA] ICECAT crawler (2018)
Unix Timestamp using WebDNA [code req] (2003)
Sort Order on a page search (1997)
Secure Server (1997)
Contexts and Ampersands (1997)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
Rhapsody? (1997)
Cart Question (1998)