Re: [WebDNA] unused database fields. . . .

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111397
interpreted = N
texte = --387254751-1220872291-1403269130=:53583 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Donocan.=0A=0ALet me explain it again..............=0A=0AA somewhat simp= le form on a website where ad payment information is entered......=0ACC pay= ments are handled manually, so just info is gathered.....=0A=0AHere is the = beginning of the append to the database snippet:=0A[append db=3D^/membershi= p/advertising.db]uniqueID=3D[cart]&submit_date=3D[date]&submit_time=3D[time= ]&submit_ip=3D[ipaddress]&firstname=3D[url][firstname][/url]&lastname=3D[ur= l][lastname][/url]&ad_name=3D[url]ad_name[/url][/append]=0A=0Afirstname & l= astname will "not" be used anymore on the form, but they are being left in = advertising.hdr since they may come to life again sometime in the future...= .=0A=0AWhen form info is submitted and appended to advertising.db the 2 unu= sed fields (no longer in the form) are having their field names written int= o the database.=0A=0A[firstname] (the field name with the brackets)=0A[last= name] (the field name with the brackets)=0Aad_name information is being wri= tten just fine=0A=0A=0A=0A=0AI'm guessing I should just not have these old = field names in the append part?=0A=C2=A0(I should have thought of that earl= ier..)=0A=0A=0A=0ABUT=0Awhy would the field names get written if they are n= owhere on the form but still appear in the append part and are still in adv= ertising.hdr=0A=0A=0A=0A=0AOn Thursday, June 19, 2014 10:29 AM, Donovan Bro= oke wrote:=0A =0A=0A=0A=0AOn Jun 19, 2014, at 8:00 AM, Ri= ch Kwas wrote:=0A=0A> Added some new fields to = an existing database.=0A> on the website information is being entered into = a payment form.=0A> =0A> Some of the existing field names will not be used = anymore in an upcoming update.=0A> These unused fields will no longer appea= r on the form.=0A> BUT these old fields unused field names are being writte= n into the database.=0A> =0A> example:=0A> [type_of_ad]=0A> [travel]=0A> [c= ity_based_in]=0A> =0A> Why would this be happening?=0A=0A=0AUndefined varia= bles output as raw text. =0A=0A=0A=0A> I'm pretty sure I have unused fields= in other sites but never had this happen until this project.=0A> =0A> Narr= owed down all other possibilities causing this and its just the unused fiel= ds being written this way.=0A> =0A> These unused fields are still being "ap= pended" to the existing db, even though they don't appear on the form anymo= re and there is no actual data to append. =0A> =0A> Should these field name= s be written into the database if the field doesn't appear on the form BUT = that field name is still in the append code?=0A> =0A> =0A> Here is how two = of the unused fields are being appended:=0A> firstname=0A> lastname=0A> =0A= > [append db=3D^/membership/advertising.db]uniqueID=3D[cart]&submit_date=3D= [date]&submit_time=3D[time]&submit_ip=3D[ipaddress]&firstname=3D[url][first= name][/url]&lastname=3D[url][lastname][/url][/append]=0A> =0A> firstname & = lastname do not appear on this form anywhere.=0A=0A=0ARich, maybe restate y= our question clearer. I=E2=80=99m confused :-)=0A=0ASincerely,=0ADonovan=0A= =0A=0A---------------------------------------------------------=0AThis mess= age is sent to you because you are subscribed to=0Athe mailing list .=0ATo unsubscribe, E-mail to: =0Aarchives: = http://mail.webdna.us/list/talk@webdna.us=0ABug Reporting: support@webdna.u= s --387254751-1220872291-1403269130=:53583 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi Donocan.

Let me explain it again..............

A somewha= t simple form on a website where ad payment information is entered......
CC payments are handled manually= , so just info is gathered.....

Here is the beginning of the append to t= he database snippet:
[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]&ad_name=3D[url]= ad_name[/url][/append]

firstname & lastname will "not" be used anymore= on the form, but they are being left in advertising.hdr since they may com= e to life again sometime in the future....

When form info is submitted an= d appended to advertising.db the 2 unused fields (no longer in the form) ar= e having their field names written into the database.

[firstname] (the field name with the bracket= s)
[lastname= ] (the field name with the brackets)
ad_n= ame information is being written just fine


=

I'= m guessing I should just not have these old field names in the append part?=
 (I should have = thought of that earlier..)


BUT
why would the field names get written if they are n= owhere on the form but still appear in the append part and are still in adv= ertising.hdr




On Thursday, June 19, 2014 10:29 AM, Donovan Brooke = <dbrooke@euca.us> wrote:


On Jun 19, 2014, at 8:00 AM, Ri= ch Kwas <richkwasnie= wski@yahoo.com> wrote:

> Added some new fields to an existi= ng database.
> on the website in= formation is being entered into a payment form.
>
> 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.
>
> example:
> [type_of_ad]<= br clear=3D"none" class=3D"" style=3D"">> [travel]
> [city_based_in]
>
> Why would this be = happening?


Undefined variabl= es output as raw text.


=
> I'm pretty sure I have unused= fields in other sites but never had this happen until this project.
>
> = Narrowed down all other possibilities causing this and its just the unused = fields being written this way.
>=
> These unused fields are stil= l being "appended" to the existing db, even though they don't appear on the= form anymore and there is no actual data to append.
>
> Shoul= d these field names be written into the database if the field doesn't appea= r on the form BUT that field name is still in the append code?
>
&= gt;
> Here is how two of the un= used 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 ap= pear on this form anywhere.

<= br clear=3D"none" class=3D"" style=3D"">
Rich, maybe restate your question clearer. I=E2=80=99m confused :-)
Sincerely,
Donovan

------------------------------------= ---------------------
This message = is sent to you because you are subscribed to
the mailing list= <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.we= bdna.us/list/talk@webdna.us
Bug= Reporting: support@webdna.us

= --387254751-1220872291-1403269130=:53583-- 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)
--387254751-1220872291-1403269130=:53583 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Donocan.=0A=0ALet me explain it again..............=0A=0AA somewhat simp= le form on a website where ad payment information is entered......=0ACC pay= ments are handled manually, so just info is gathered.....=0A=0AHere is the = beginning of the append to the database snippet:=0A[append db=3D^/membershi= p/advertising.db]uniqueID=3D[cart]&submit_date=3D[date]&submit_time=3D[time= ]&submit_ip=3D[ipaddress]&firstname=3D[url][firstname][/url]&lastname=3D[ur= l][lastname][/url]&ad_name=3D[url]ad_name[/url][/append]=0A=0Afirstname & l= astname will "not" be used anymore on the form, but they are being left in = advertising.hdr since they may come to life again sometime in the future...= .=0A=0AWhen form info is submitted and appended to advertising.db the 2 unu= sed fields (no longer in the form) are having their field names written int= o the database.=0A=0A[firstname] (the field name with the brackets)=0A[last= name] (the field name with the brackets)=0Aad_name information is being wri= tten just fine=0A=0A=0A=0A=0AI'm guessing I should just not have these old = field names in the append part?=0A=C2=A0(I should have thought of that earl= ier..)=0A=0A=0A=0ABUT=0Awhy would the field names get written if they are n= owhere on the form but still appear in the append part and are still in adv= ertising.hdr=0A=0A=0A=0A=0AOn Thursday, June 19, 2014 10:29 AM, Donovan Bro= oke wrote:=0A =0A=0A=0A=0AOn Jun 19, 2014, at 8:00 AM, Ri= ch Kwas wrote:=0A=0A> Added some new fields to = an existing database.=0A> on the website information is being entered into = a payment form.=0A> =0A> Some of the existing field names will not be used = anymore in an upcoming update.=0A> These unused fields will no longer appea= r on the form.=0A> BUT these old fields unused field names are being writte= n into the database.=0A> =0A> example:=0A> [type_of_ad]=0A> [travel]=0A> [c= ity_based_in]=0A> =0A> Why would this be happening?=0A=0A=0AUndefined varia= bles output as raw text. =0A=0A=0A=0A> I'm pretty sure I have unused fields= in other sites but never had this happen until this project.=0A> =0A> Narr= owed down all other possibilities causing this and its just the unused fiel= ds being written this way.=0A> =0A> These unused fields are still being "ap= pended" to the existing db, even though they don't appear on the form anymo= re and there is no actual data to append. =0A> =0A> Should these field name= s be written into the database if the field doesn't appear on the form BUT = that field name is still in the append code?=0A> =0A> =0A> Here is how two = of the unused fields are being appended:=0A> firstname=0A> lastname=0A> =0A= > [append db=3D^/membership/advertising.db]uniqueID=3D[cart]&submit_date=3D= [date]&submit_time=3D[time]&submit_ip=3D[ipaddress]&firstname=3D[url][first= name][/url]&lastname=3D[url][lastname][/url][/append]=0A> =0A> firstname & = lastname do not appear on this form anywhere.=0A=0A=0ARich, maybe restate y= our question clearer. I=E2=80=99m confused :-)=0A=0ASincerely,=0ADonovan=0A= =0A=0A---------------------------------------------------------=0AThis mess= age is sent to you because you are subscribed to=0Athe mailing list .=0ATo unsubscribe, E-mail to: =0Aarchives: = http://mail.webdna.us/list/talk@webdna.us=0ABug Reporting: support@webdna.u= s --387254751-1220872291-1403269130=:53583 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi Donocan.

Let me explain it again..............

A somewha= t simple form on a website where ad payment information is entered......
CC payments are handled manually= , so just info is gathered.....

Here is the beginning of the append to t= he database snippet:
[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]&ad_name=3D[url]= ad_name[/url][/append]

firstname & lastname will "not" be used anymore= on the form, but they are being left in advertising.hdr since they may com= e to life again sometime in the future....

When form info is submitted an= d appended to advertising.db the 2 unused fields (no longer in the form) ar= e having their field names written into the database.

[firstname] (the field name with the bracket= s)
[lastname= ] (the field name with the brackets)
ad_n= ame information is being written just fine


=

I'= m guessing I should just not have these old field names in the append part?=
 (I should have = thought of that earlier..)


BUT
why would the field names get written if they are n= owhere on the form but still appear in the append part and are still in adv= ertising.hdr




On Thursday, June 19, 2014 10:29 AM, Donovan Brooke = <dbrooke@euca.us> wrote:


On Jun 19, 2014, at 8:00 AM, Ri= ch Kwas <richkwasnie= wski@yahoo.com> wrote:

> Added some new fields to an existi= ng database.
> on the website in= formation is being entered into a payment form.
>
> 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.
>
> example:
> [type_of_ad]<= br clear=3D"none" class=3D"" style=3D"">> [travel]
> [city_based_in]
>
> Why would this be = happening?


Undefined variabl= es output as raw text.


=
> I'm pretty sure I have unused= fields in other sites but never had this happen until this project.
>
> = Narrowed down all other possibilities causing this and its just the unused = fields being written this way.
>=
> These unused fields are stil= l being "appended" to the existing db, even though they don't appear on the= form anymore and there is no actual data to append.
>
> Shoul= d these field names be written into the database if the field doesn't appea= r on the form BUT that field name is still in the append code?
>
&= gt;
> Here is how two of the un= used 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 ap= pear on this form anywhere.

<= br clear=3D"none" class=3D"" style=3D"">
Rich, maybe restate your question clearer. I=E2=80=99m confused :-)
Sincerely,
Donovan

------------------------------------= ---------------------
This message = is sent to you because you are subscribed to
the mailing list= <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.we= bdna.us/list/talk@webdna.us
Bug= Reporting: support@webdna.us

= --387254751-1220872291-1403269130=:53583-- 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:

Email notification to one of multiple vendors ? (1997) Live server problems (1999) WebCat2 - Getting to the browser's username/password data (1997) Error reading data -1 (1997) IE Cache Problems... (1999) f2 download problems (1997) Sort Order on a page search (1997) Busted at the Border (1998) SiteGuard Admin Feature ? (1997) Repost: [convertwords] to convert carriage return? (2000) Searching multiple criteria (2000) quantity minimum problem (1997) Firesite cache vs webcat cache (1997) multiple search commands (1997) showif and cart (1997) Commas in search (1998) Tip: Debug: See what your [Search...] is doing (2003) Quit revisited (1997) Email Not Going out (OS X Jag Client) (2002) Bug? (1997)