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=:53583Content-Type: text/plain; charset=utf-8Content-Transfer-Encoding: quoted-printableHi 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=:53583Content-Type: text/html; charset=utf-8Content-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..)