[WebDNA] unused database fields. . . .
This WebDNA talk-list message is from 2014
It keeps the original formatting.
numero = 111393
interpreted = N
texte = ---256681777-1457687073-1403182813=:33984Content-Type: text/plain; charset=iso-8859-1Content-Transfer-Encoding: quoted-printableAdded some new fields to an existing database.=0Aon the website information= is being entered into a payment form.=0A=0ASome of the existing field name=s will not be used anymore in an upcoming update.=0AThese unused fields wil=l no longer appear on the form.=0ABUT=A0these old fields unused field names= are being written into the database.=0A=0Aexample:=0A[type_of_ad]=0A[trave=l]=0A[city_based_in]=0A=0AWhy would this be happening?=0A=0AI'm pretty sure= I have unused fields in other sites but never had this happen until this p=roject.=0A=0ANarrowed down all other possibilities causing this and its jus=t the unused fields being written this way.=0A=0AThese unused fields are st=ill being "appended" to the existing db, even though they don't appear on t=he form anymore and there is no actual data to append.=A0=0A=0AShould these= field names be written into the database if the field doesn't appear on th=e form BUT that field name is still in the append code?=0A=0A=0AHere is how= two of the unused fields are being appended:=0Afirstname=0Alastname=0A=0A[=append db=3D^/membership/advertising.db]uniqueID=3D[cart]&submit_date=3D[da=te]&submit_time=3D[time]&submit_ip=3D[ipaddress]&firstname=3D[url][firstnam=e][/url]&lastname=3D[url][lastname][/url][/append]=0A=0Afirstname & lastnam=e do not appear on this form anywhere.=0A=0A=0A=0ARichard---256681777-1457687073-1403182813=:33984Content-Type: text/html; charset=iso-8859-1Content-Transfer-Encoding: quoted-printable
Added some new fields to an existi=ng database.
on the website information is =being entered into a payment form.
Some of the existing fie=ld names will not be used anymore in an upcoming update.
These unused fields will no longer appear on the form.
<=div class=3D"" style=3D"">BUT
these old fields unused field names are being written into the databa=se.<=span style=3D"font-size: 10pt;" class=3D"">
example:
[type_of_ad]
[travel]
[city_based_in]
Why would this be happening?<=br class=3D"" style=3D""> I'm pretty sure I have= unused fields in other sites but never had this happen until this project.=
Narrowed down a=ll other possibilities causing this and its just the unused fields being wr=itten this way.
These unused fields are still being "appended" to the exist=ing db, even though they don't appear on the form anymore and there is no a=ctual data to append.
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 a=ppend code?
=
Here is how two of the unused fields are being appended:
firstname
lastname
[append db=3D^/membership/advertising.db]uniqueID=3D[cart]&submit_date=3D[date=]&submit_time=3D[time]&submit_ip=3D[ipaddress]&firstname=3D[url=][firstname][/url]&lastname=3D[url][lastname][/url][/append]
firstname & lastname do not appear on this form anywhere.
<=br>
Richard<=/div>
---256681777-1457687073-1403182813=:33984--
Associated Messages, from the most recent to the oldest:
---256681777-1457687073-1403182813=:33984Content-Type: text/plain; charset=iso-8859-1Content-Transfer-Encoding: quoted-printableAdded some new fields to an existing database.=0Aon the website information= is being entered into a payment form.=0A=0ASome of the existing field name=s will not be used anymore in an upcoming update.=0AThese unused fields wil=l no longer appear on the form.=0ABUT=A0these old fields unused field names= are being written into the database.=0A=0Aexample:=0A[type_of_ad]=0A[trave=l]=0A[city_based_in]=0A=0AWhy would this be happening?=0A=0AI'm pretty sure= I have unused fields in other sites but never had this happen until this p=roject.=0A=0ANarrowed down all other possibilities causing this and its jus=t the unused fields being written this way.=0A=0AThese unused fields are st=ill being "appended" to the existing db, even though they don't appear on t=he form anymore and there is no actual data to append.=A0=0A=0AShould these= field names be written into the database if the field doesn't appear on th=e form BUT that field name is still in the append code?=0A=0A=0AHere is how= two of the unused fields are being appended:=0Afirstname=0Alastname=0A=0A[=append db=3D^/membership/advertising.db]uniqueID=3D[cart]&submit_date=3D[da=te]&submit_time=3D[time]&submit_ip=3D[ipaddress]&firstname=3D[url][firstnam=e][/url]&lastname=3D[url][lastname][/url][/append]=0A=0Afirstname & lastnam=e do not appear on this form anywhere.=0A=0A=0A=0ARichard---256681777-1457687073-1403182813=:33984Content-Type: text/html; charset=iso-8859-1Content-Transfer-Encoding: quoted-printableAdded some new fields to an existi=ng database.
on the website information is =being entered into a payment form.
Some of the existing fie=ld names will not be used anymore in an upcoming update.
These unused fields will no longer appear on the form.
<=div class=3D"" style=3D"">BUT
these old fields unused field names are being written into the databa=se.<=span style=3D"font-size: 10pt;" class=3D"">
example:
[type_of_ad]
[travel]
[city_based_in]
Why would this be happening?<=br class=3D"" style=3D"">I'm pretty sure I have= unused fields in other sites but never had this happen until this project.=
Narrowed down a=ll other possibilities causing this and its just the unused fields being wr=itten this way.
These unused fields are still being "appended" to the exist=ing db, even though they don't appear on the form anymore and there is no a=ctual data to append.
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 a=ppend code?
=
Here is how two of the unused fields are being appended:
firstname
lastname
[append db=3D^/membership/advertising.db]uniqueID=3D
[cart]&submit_date=3D[date=]&submit_time=3D
[time]&submit_ip=3D
[ipaddress]&firstname=3D[url=][firstname][/url]&lastname=3D
[url][lastname][/url]
[/append]
firstname & lastname do not appear on this form anywhere.
<=br>
Richard<=/div>
---256681777-1457687073-1403182813=:33984--
Rich Kwas
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:
can WC render sites out? (1997)
RE:It just Does't add up!!! (1997)
Almost a there but..bye bye NetCloak (1997)
Pull Down Search (2000)
Folder modify times (2003)
Problem with a search context (2005)
Replacing entry (1998)
[WebDNA] Delete of Expire a cookie (2014)
WebCat2: multiple currency support (1997)
OLD ORDERS (1998)
WebCatalog Plug-in for Webstar. (1997)
can WC render sites out? (1997)
Less than or equal to........ (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Credit card processing - UK (1997)
version history page for webcat on the SM site? (2000)
Size limit for tmpl editor ? (1997)
Blacklisted (2002)
WebCat2 Append problem (B14Macacgi) (1997)
This is probably a stupid question... (2004)