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

This WebDNA talk-list message is from

2014


It keeps the original formatting.
numero = 111399
interpreted = N
texte = ---485831647-836750856-1403270277=:24566 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Gotcha.....=0A=0AI can easily remove unused fields from the append part.=0A= Left it all intact while form elements were being changed and tweaked.=0A= =0AThanks=0A=0A=0A=0A=0AOn Friday, June 20, 2014 8:13 AM, "christophe.billi= ottet@webdna.us" wrote:=0A =0A=0A=0AHi Ri= ch! if you append fields that do not exist in a form, something like &first= name=3D[url][firstname][/url] then =E2=80=9C[firstname]=E2=80=9D (with the = brackets) will be added to the database. WebDNA is just expecting the field= content, and since this one does not exist, then the code [firstname] that= should be replaced by the field content will appear instead. This is norma= l behaviour.=0A=0A- chris=0A=0A=0A=0A=0AOn Jun 20, 2014, at 15:58, Rich Kwa= s wrote:=0A=0A> Hi Donocan.=0A> =0A> Let me exp= lain it again..............=0A> =0A> A somewhat simple form on a website wh= ere ad payment information is entered......=0A> CC payments are handled man= ually, so just info is gathered.....=0A> =0A> Here is the beginning of the = append to the database snippet:=0A> [append db=3D^/membership/advertising.d= b]uniqueID=3D[cart]&submit_date=3D[date]&submit_time=3D[time]&submit_ip=3D[= ipaddress]&firstname=3D[url][firstname][/url]&lastname=3D[url][lastname][/u= rl]&ad_name=3D[url]ad_name[/url][/append]=0A> =0A> firstname & lastname wil= l "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> =0A> = When form info is submitted and appended to advertising.db the 2 unused fie= lds (no longer in the form) are having their field names written into the d= atabase.=0A> =0A> [firstname] (the field name with the brackets)=0A> [lastn= ame] (the field name with the brackets)=0A> ad_name information is being wr= itten just fine=0A> =0A> =0A> =0A> I'm guessing I should just not have thes= e old field names in the append part?=0A>=C2=A0 (I should have thought of t= hat earlier..)=0A> =0A> =0A> BUT=0A> why would the field names get written = if they are nowhere on the form but still appear in the append part and are= still in advertising.hdr=0A> =0A> =0A> =0A> =0A> On Thursday, June 19, 201= 4 10:29 AM, Donovan Brooke wrote:=0A> =0A> =0A> =0A> On J= un 19, 2014, at 8:00 AM, Rich 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 appear on the form.=0A> > BUT these old = fields unused field names are being written into the database.=0A> > =0A> >= example:=0A> > [type_of_ad]=0A> > [travel]=0A> > [city_based_in]=0A> > =0A= > > Why would this be happening?=0A> =0A> =0A> Undefined variables output a= s raw text.=0A> =0A> =0A> =0A> > I'm pretty sure I have unused fields in ot= her sites but never had this happen until this project.=0A> > =0A> > Narrow= ed down all other possibilities causing this and its just the unused fields= being written this way.=0A> > =0A> > These unused fields are still being "= appended" to the existing db, even though they don't appear on the form any= more and there is no actual data to append. =0A> > =0A> > Should these fiel= d names be written into the database if the field doesn't appear on the for= m 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]&fir= stname=3D[url][firstname][/url]&lastname=3D[url][lastname][/url][/append]= =0A> > =0A> > firstname & lastname do not appear on this form anywhere.=0A>= =0A> =0A> =0A> Rich, maybe restate your question clearer. I=E2=80=99m conf= used :-)=0A> =0A> Sincerely,=0A> Donovan=0A> =0A> =0A> --------------------= -------------------------------------=0A> This message is sent to you becau= se you are subscribed to=0A> the mailing list .=0A> To unsu= bscribe, E-mail to: =0A> archives: http://mail.webdna= .us/list/talk@webdna.us=0A> Bug Reporting: support@webdna.us=0A> =0A> -----= ---------------------------------------------------- This message is sent t= o you because you are subscribed to the mailing list . To unsubscribe, E-ma= il to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: s= upport@webdna.us=0A=0A=0A--------------------------------------------------= -------=0AThis message is sent to you because you are subscribed to=0Athe m= ailing list .=0ATo unsubscribe, E-mail to: =0Aarchives: http://mail.webdna.us/list/talk@webdna.us=0ABug Reportin= g: support@webdna.us ---485831647-836750856-1403270277=:24566 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Gotcha.....

I can easily remove unused fields from the append par= t.
Left it= all intact while form elements were being changed and tweaked.
=
Thank= s


On Friday, June 20, 2014 8:13 AM, "christoph= e.billiottet@webdna.us" <christophe.billiottet@webdna.us> wrote:
=


Hi Rich! if you app= end fields that do not exist in a form, something like &firstname=3D[ur= l][firstname][/url] then =E2=80=9C[firstname]=E2=80=9D (with the brackets) = will be added to the database. WebDNA is just expecting the field content, = and since this one does not exist, then the code [firstname] that should be= replaced by the field content will appear instead. This is normal behaviou= r.

- chris



On Jun 20, 2014, at 1= 5:58, Rich Kwas <richkwasniewski@yahoo.com= > wrote:

> Hi Donocan.
>
> Let me explain it again..........= ....
>
> A somewhat 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 app= end to the database snippet:
> [append db=3D^/membersh= ip/advertising.db]uniqueID=3D[cart]&submit_date=3D[date]&submit_tim= e=3D[time]&submit_ip=3D[ipaddress]&firstname=3D[url][firstname][/ur= l]&lastname=3D[url][lastname][/url]&ad_name=3D[url]ad_name[/url][/a= ppend]
> > firstname & lastname will "not" be used anymore on= the form, but they are being left in advertising.hdr since they may come t= o life again sometime in the future....
>
> When form info is submitted and appended to advertising.db the = 2 unused fields (no longer in the form) are having their field names writte= n into the database.
>
> [firstn= ame] (the field name with the brackets)
> [lastname] (= the field name with the brackets)
> ad_name informatio= n is being written just fine
>
>=
>
> I'm guessing I should just= not have these old field names in the append part?
>&= nbsp; (I should have thought of that earlier..)
>
>
> BUT
> why = would the field names get written if they are nowhere on the form but still appear in the append par= t and are still in advertising.hdr
>
>
>
>
&= gt; On Thursday, June 19, 2014 10:29 AM, Donovan Brooke <dbroo= ke@euca.us> wrote:
>
> >
> On Jun 19, 2014, at 8:00 AM, = Rich Kwas <richkwasniewski@yahoo.com&g= t; wrote:
>
> > Added some ne= w fields to an existing database.
> > on the websit= e information 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 app= ear on the form.
> > BUT these old fields unused fi= eld names are being written into the database.
> > =
> > example:
> > [type_of_= ad]
> > [travel]
> > [city_= based_in]
> >
> > Why woul= d this be happening?
>
>
> Undefined variables output as raw text.
= >
>
>
>= ; > I'm pretty sure I have unused fields in other sites but never had th= is 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 still being "appended" to the existing db, even though t= hey don't appear on the form anymore and there is no actual data to append.=
> >
> > Should these fie= ld names be written into the database if the field doesn't appear on the fo= rm BUT that field name is still in the append code?
> = >
> >
> > Here is how = two of the unused fields are being appended:
> > fi= rstname
> > lastname
> > > > [append db=3D^/membership/advertising.db]uniqueI= D=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.
> >
>
> Rich, = maybe restate your question clearer. I=E2=80=99m confused :-)
>
> Sincerely,
> Donovan=
>
>
> ---= ------------------------------------------------------
&g= t; This message is sent to you because you are subscribed to
> the mailing list <talk@webdna.us>.
> To unsubscribe, E-mail to: <talk-leave@web= dna.us>
> archives: http://mail.web= dna.us/list/talk@webdna.us
> Bug Reporting: support@webdna.us
= >
> ----------------------------------------------= ----------- This message is sent to you because you are subscribed to the m= ailing list . To unsubscribe, E-mail to: archives: http://mai= l.webdna.us/list/talk@webdna.us Bug Reporting: support@we= bdna.us


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

---485831647-836750856-1403270277=:24566-- 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)
---485831647-836750856-1403270277=:24566 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Gotcha.....=0A=0AI can easily remove unused fields from the append part.=0A= Left it all intact while form elements were being changed and tweaked.=0A= =0AThanks=0A=0A=0A=0A=0AOn Friday, June 20, 2014 8:13 AM, "christophe.billi= ottet@webdna.us" wrote:=0A =0A=0A=0AHi Ri= ch! if you append fields that do not exist in a form, something like &first= name=3D[url][firstname][/url] then =E2=80=9C[firstname]=E2=80=9D (with the = brackets) will be added to the database. WebDNA is just expecting the field= content, and since this one does not exist, then the code [firstname] that= should be replaced by the field content will appear instead. This is norma= l behaviour.=0A=0A- chris=0A=0A=0A=0A=0AOn Jun 20, 2014, at 15:58, Rich Kwa= s wrote:=0A=0A> Hi Donocan.=0A> =0A> Let me exp= lain it again..............=0A> =0A> A somewhat simple form on a website wh= ere ad payment information is entered......=0A> CC payments are handled man= ually, so just info is gathered.....=0A> =0A> Here is the beginning of the = append to the database snippet:=0A> [append db=3D^/membership/advertising.d= b]uniqueID=3D[cart]&submit_date=3D[date]&submit_time=3D[time]&submit_ip=3D[= ipaddress]&firstname=3D[url][firstname][/url]&lastname=3D[url][lastname][/u= rl]&ad_name=3D[url]ad_name[/url][/append]=0A> =0A> firstname & lastname wil= l "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> =0A> = When form info is submitted and appended to advertising.db the 2 unused fie= lds (no longer in the form) are having their field names written into the d= atabase.=0A> =0A> [firstname] (the field name with the brackets)=0A> [lastn= ame] (the field name with the brackets)=0A> ad_name information is being wr= itten just fine=0A> =0A> =0A> =0A> I'm guessing I should just not have thes= e old field names in the append part?=0A>=C2=A0 (I should have thought of t= hat earlier..)=0A> =0A> =0A> BUT=0A> why would the field names get written = if they are nowhere on the form but still appear in the append part and are= still in advertising.hdr=0A> =0A> =0A> =0A> =0A> On Thursday, June 19, 201= 4 10:29 AM, Donovan Brooke wrote:=0A> =0A> =0A> =0A> On J= un 19, 2014, at 8:00 AM, Rich 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 appear on the form.=0A> > BUT these old = fields unused field names are being written into the database.=0A> > =0A> >= example:=0A> > [type_of_ad]=0A> > [travel]=0A> > [city_based_in]=0A> > =0A= > > Why would this be happening?=0A> =0A> =0A> Undefined variables output a= s raw text.=0A> =0A> =0A> =0A> > I'm pretty sure I have unused fields in ot= her sites but never had this happen until this project.=0A> > =0A> > Narrow= ed down all other possibilities causing this and its just the unused fields= being written this way.=0A> > =0A> > These unused fields are still being "= appended" to the existing db, even though they don't appear on the form any= more and there is no actual data to append. =0A> > =0A> > Should these fiel= d names be written into the database if the field doesn't appear on the for= m 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]&fir= stname=3D[url][firstname][/url]&lastname=3D[url][lastname][/url][/append]= =0A> > =0A> > firstname & lastname do not appear on this form anywhere.=0A>= =0A> =0A> =0A> Rich, maybe restate your question clearer. I=E2=80=99m conf= used :-)=0A> =0A> Sincerely,=0A> Donovan=0A> =0A> =0A> --------------------= -------------------------------------=0A> This message is sent to you becau= se you are subscribed to=0A> the mailing list .=0A> To unsu= bscribe, E-mail to: =0A> archives: http://mail.webdna= .us/list/talk@webdna.us=0A> Bug Reporting: support@webdna.us=0A> =0A> -----= ---------------------------------------------------- This message is sent t= o you because you are subscribed to the mailing list . To unsubscribe, E-ma= il to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: s= upport@webdna.us=0A=0A=0A--------------------------------------------------= -------=0AThis message is sent to you because you are subscribed to=0Athe m= ailing list .=0ATo unsubscribe, E-mail to: =0Aarchives: http://mail.webdna.us/list/talk@webdna.us=0ABug Reportin= g: support@webdna.us ---485831647-836750856-1403270277=:24566 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Gotcha.....

I can easily remove unused fields from the append par= t.
Left it= all intact while form elements were being changed and tweaked.
=
Thank= s


On Friday, June 20, 2014 8:13 AM, "christoph= e.billiottet@webdna.us" <christophe.billiottet@webdna.us> wrote:
=


Hi Rich! if you app= end fields that do not exist in a form, something like &firstname=3D[ur= l][firstname][/url] then =E2=80=9C[firstname]=E2=80=9D (with the brackets) = will be added to the database. WebDNA is just expecting the field content, = and since this one does not exist, then the code [firstname] that should be= replaced by the field content will appear instead. This is normal behaviou= r.

- chris



On Jun 20, 2014, at 1= 5:58, Rich Kwas <richkwasniewski@yahoo.com= > wrote:

> Hi Donocan.
>
> Let me explain it again..........= ....
>
> A somewhat 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 app= end to the database snippet:
> [append db=3D^/membersh= ip/advertising.db]uniqueID=3D[cart]&submit_date=3D[date]&submit_tim= e=3D[time]&submit_ip=3D[ipaddress]&firstname=3D[url][firstname][/ur= l]&lastname=3D[url][lastname][/url]&ad_name=3D[url]ad_name[/url][/a= ppend]
> > firstname & lastname will "not" be used anymore on= the form, but they are being left in advertising.hdr since they may come t= o life again sometime in the future....
>
> When form info is submitted and appended to advertising.db the = 2 unused fields (no longer in the form) are having their field names writte= n into the database.
>
> [firstn= ame] (the field name with the brackets)
> [lastname] (= the field name with the brackets)
> ad_name informatio= n is being written just fine
>
>=
>
> I'm guessing I should just= not have these old field names in the append part?
>&= nbsp; (I should have thought of that earlier..)
>
>
> BUT
> why = would the field names get written if they are nowhere on the form but still appear in the append par= t and are still in advertising.hdr
>
>
>
>
&= gt; On Thursday, June 19, 2014 10:29 AM, Donovan Brooke <dbroo= ke@euca.us> wrote:
>
> >
> On Jun 19, 2014, at 8:00 AM, = Rich Kwas <richkwasniewski@yahoo.com&g= t; wrote:
>
> > Added some ne= w fields to an existing database.
> > on the websit= e information 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 app= ear on the form.
> > BUT these old fields unused fi= eld names are being written into the database.
> > =
> > example:
> > [type_of_= ad]
> > [travel]
> > [city_= based_in]
> >
> > Why woul= d this be happening?
>
>
> Undefined variables output as raw text.
= >
>
>
>= ; > I'm pretty sure I have unused fields in other sites but never had th= is 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 still being "appended" to the existing db, even though t= hey don't appear on the form anymore and there is no actual data to append.=
> >
> > Should these fie= ld names be written into the database if the field doesn't appear on the fo= rm BUT that field name is still in the append code?
> = >
> >
> > Here is how = two of the unused fields are being appended:
> > fi= rstname
> > lastname
> > > > [append db=3D^/membership/advertising.db]uniqueI= D=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.
> >
>
> Rich, = maybe restate your question clearer. I=E2=80=99m confused :-)
>
> Sincerely,
> Donovan=
>
>
> ---= ------------------------------------------------------
&g= t; This message is sent to you because you are subscribed to
> the mailing list <talk@webdna.us>.
> To unsubscribe, E-mail to: <talk-leave@web= dna.us>
> archives: http://mail.web= dna.us/list/talk@webdna.us
> Bug Reporting: support@webdna.us
= >
> ----------------------------------------------= ----------- This message is sent to you because you are subscribed to the m= ailing list . To unsubscribe, E-mail to: archives: http://mai= l.webdna.us/list/talk@webdna.us Bug Reporting: support@we= bdna.us


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

---485831647-836750856-1403270277=:24566-- 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:

Problem (1997) ShoppingCart Woes (1998) RE: Nesting [ListFiles] (1998) WebDNA Running Out of RAM? (2004) limitation found on group searching (1997) Is the Finder required? (1998) How flexible is Shipping? (1997) Date Range Search not working (2000) WebCat2b12 - nesting [tags] (1997) searchable list archive (1997) WCS Newbie question (1997) Other then credit cards-how? (1997) Re:no [search] with NT (1997) Carts & cookies (1999) no word on MacAuthorize... (1997) 'Carting' into Frames (2000) carriage returns in data (1997) question on max variable in searching... (2000) Appending current [date] to a database (1997) Location of Webcat site in folder hierarchy (1997)