[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=:33984 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Added 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=:33984 Content-Type: text/html; charset=iso-8859-1 Content-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:

    
  1. Re: [WebDNA] unused database fields. . . . (Rich Kwas 2014)
  2. Re: [WebDNA] unused database fields. . . . (christophe.billiottet@webdna.us 2014)
  3. Re: [WebDNA] unused database fields. . . . (Rich Kwas 2014)
  4. Re: [WebDNA] unused database fields. . . . (Donovan Brooke 2014)
  5. [WebDNA] unused database fields. . . . (Rich Kwas 2014)
---256681777-1457687073-1403182813=:33984 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Added 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=:33984 Content-Type: text/html; charset=iso-8859-1 Content-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-- 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:

[WebDNA] TCPConnect w/ user:pass (2009) mac hack (1997) Lost and Recovered. (1998) problems with 2 tags (1997) change the number format (1997) WebCommerce: Folder organization ? (1997) Help name our technology! (1997) Tip for making barcharts (1997) PDF Writefile problem (2005) WebCatalog Features (1997) format and math on the fly (1998) flushdatabases (1997) Whats wrong with this???? (2001) WebDNA Book? (2003) Problem with webcat install (1998) ftp to webstar (2001) Preventing code execution (2003) Updating fields from different platforms (1998) b12 cannot limit records returned and more. (1997) shell problems again... (2003)