[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:

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)