Re: [WebDNA] [AddFields] Restrictions

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108748
interpreted = N
texte = Hi Mike! i do not want to get shouted at :-) but it seems to me that if = you just want to add some columns in a hdr description, a [writefile] = should do fine. [text show=3Df]old_hdr=3Dcolumn1column2column3column4[/text] [text show=3Df]new_hdr=3D[old_hdr]column5column6column7column8= column9column10 column11[/text] of course, you would use [include] to get the old_hdr and [writefile] to = write the new one. - chris =20 On Mar 1, 2012, at 13:00, Michael A. DeLorenzo wrote: > I understand the financial limitations. If it helps, I use the = addFields for > a .hdr file. Does that make a difference? >=20 > -----Original Message----- > From: christophe.billiottet@webdna.us > [mailto:christophe.billiottet@webdna.us]=20 > Sent: Wednesday, February 29, 2012 6:21 PM > To: talk@webdna.us > Subject: Re: [WebDNA] [AddFields] Restrictions >=20 > So far, it seems the columns limit has been added in 5.1 because of = previous > problems with this context. WebDNA has to calculate how big the new = buffer > needs to be to fit all the old data and the new, allocate the memory = that > will hold the new DB, then get pointer to the old and new buffers so = that it > can traverse both to copy the old data into the new buffer, increment = the > field count, free the old buffer, and set the field pointer to point = to the > new buffer. It will then copy the data to disk, reload the entire = contents > of the database into RAM, to give subclasses a chance to clean up and > reinitialize properly. It is a more complicated process than it = looks... >=20 > If we remove the limit, it will be necessary to rewrite parts of = WebDNA: > this would be a costly process. I am afraid we will keep this as it is = for > now... >=20 > - chris >=20 >=20 >=20 >=20 > On Feb 29, 2012, at 20:42, Michael A. DeLorenzo wrote: >=20 >> Chris, >>=20 >> If there is no reason to limit it then why do so? Is there a reason?=20= >> If not, then yes, it would be nice to be able to add a larger number=20= >> of fields to a database. It would be specifically helpful when=20 >> importing data from other programs on the fly....I currently have to=20= >> import a database file from another program, rename all of the field=20= >> names and create a new database on a subset of the data. The ability=20= >> to add multiple fields at once would help a lot. >>=20 >> Mike >>=20 >> -----Original Message----- >> From: christophe.billiottet@webdna.us >> [mailto:christophe.billiottet@webdna.us] >> Sent: Wednesday, February 29, 2012 4:55 PM >> To: talk@webdna.us >> Subject: Re: [WebDNA] [AddFields] Restrictions >>=20 >> Hi Mike! no, we did not change this behaviour. We did not consider it=20= >> as a bug, but a small limitation documented at >> http://www.webdna.us/page.dna?numero=3D195 >>=20 >> Columns could be added 4 at a time in consecutive operations without=20= >> adding much work. >>=20 >> However, if there is a serious reason to modify this, we will do it. >>=20 >> - chris >>=20 >>=20 >>=20 >> On Feb 29, 2012, at 19:26, Michael A. DeLorenzo wrote: >>=20 >>> It's been a while but I need to know if the AddFields bug has been=20= >>> fixed. I didn't want to assume.... >>>=20 >>> Thanks, >>> Mike >>>=20 >>> -----Original Message----- >>> From: Donovan Brooke [mailto:dbrooke@webdna.us] >>> Sent: Monday, October 13, 2008 6:49 PM >>> To: talk@webdna.us >>> Subject: Re: [WebDNA] [AddFields] Restrictions >>>=20 >>> Michael A. DeLorenzo wrote: >>>=20 >>>> Has anyone experienced a limitation on the number of fields that = can=20 >>>> be added to a database at one time? I'm currently only able to add = 4=20 >>>> fields at one time to my database. >>>=20 >>>=20 >>> Looks to me like that tag is a bit buggy... didn't see any=20 >>> limitations in the source and some of my tests had odd results (also=20= >>> confirming adding only >>> 4 fields on a *nix environment.) >>>=20 >>> So, consider this added to the bug list! Thanks Michael. >>>=20 >>> Donovan >>>=20 >>>=20 >>>=20 >>> --=20 >>> Donovan D. Brooke PH/FAX: 1 (608) 291-2024 >>> ---------------------------------------------- >>> VP >>> WebDNA Software Corporation >>> 16192 Coastal Highway >>> Lewes, DE 19958 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to the = mailing=20 >>> list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> old archives: http://dev.webdna.us/TalkListArchive/ >>>=20 >>>=20 >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to the = mailing=20 >>> list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to the mailing=20= >> list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >>=20 >>=20 >>=20 >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to the mailing=20= >> list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to the mailing = list > . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us >=20 >=20 >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] [AddFields] Restrictions (christophe.billiottet@webdna.us 2012)
  2. RE: [WebDNA] [AddFields] Restrictions ("Michael A. DeLorenzo" 2012)
  3. Re: [WebDNA] [AddFields] Restrictions (christophe.billiottet@webdna.us 2012)
  4. RE: [WebDNA] [AddFields] Restrictions ("Michael A. DeLorenzo" 2012)
  5. Re: [WebDNA] [AddFields] Restrictions (christophe.billiottet@webdna.us 2012)
  6. RE: [WebDNA] [AddFields] Restrictions ("Michael A. DeLorenzo" 2012)
  7. Re: [WebDNA] [AddFields] Restrictions (Donovan Brooke 2008)
  8. [WebDNA] [AddFields] Restrictions ("Michael A. DeLorenzo" 2008)
Hi Mike! i do not want to get shouted at :-) but it seems to me that if = you just want to add some columns in a hdr description, a [writefile] = should do fine. [text show=3Df]old_hdr=3Dcolumn1column2column3column4[/text] [text show=3Df]new_hdr=3D[old_hdr]column5column6column7column8= column9column10 column11[/text] of course, you would use [include] to get the old_hdr and [writefile] to = write the new one. - chris =20 On Mar 1, 2012, at 13:00, Michael A. DeLorenzo wrote: > I understand the financial limitations. If it helps, I use the = addFields for > a .hdr file. Does that make a difference? >=20 > -----Original Message----- > From: christophe.billiottet@webdna.us > [mailto:christophe.billiottet@webdna.us]=20 > Sent: Wednesday, February 29, 2012 6:21 PM > To: talk@webdna.us > Subject: Re: [WebDNA] [addfields] Restrictions >=20 > So far, it seems the columns limit has been added in 5.1 because of = previous > problems with this context. WebDNA has to calculate how big the new = buffer > needs to be to fit all the old data and the new, allocate the memory = that > will hold the new DB, then get pointer to the old and new buffers so = that it > can traverse both to copy the old data into the new buffer, increment = the > field count, free the old buffer, and set the field pointer to point = to the > new buffer. It will then copy the data to disk, reload the entire = contents > of the database into RAM, to give subclasses a chance to clean up and > reinitialize properly. It is a more complicated process than it = looks... >=20 > If we remove the limit, it will be necessary to rewrite parts of = WebDNA: > this would be a costly process. I am afraid we will keep this as it is = for > now... >=20 > - chris >=20 >=20 >=20 >=20 > On Feb 29, 2012, at 20:42, Michael A. DeLorenzo wrote: >=20 >> Chris, >>=20 >> If there is no reason to limit it then why do so? Is there a reason?=20= >> If not, then yes, it would be nice to be able to add a larger number=20= >> of fields to a database. It would be specifically helpful when=20 >> importing data from other programs on the fly....I currently have to=20= >> import a database file from another program, rename all of the field=20= >> names and create a new database on a subset of the data. The ability=20= >> to add multiple fields at once would help a lot. >>=20 >> Mike >>=20 >> -----Original Message----- >> From: christophe.billiottet@webdna.us >> [mailto:christophe.billiottet@webdna.us] >> Sent: Wednesday, February 29, 2012 4:55 PM >> To: talk@webdna.us >> Subject: Re: [WebDNA] [addfields] Restrictions >>=20 >> Hi Mike! no, we did not change this behaviour. We did not consider it=20= >> as a bug, but a small limitation documented at >> http://www.webdna.us/page.dna?numero=3D195 >>=20 >> Columns could be added 4 at a time in consecutive operations without=20= >> adding much work. >>=20 >> However, if there is a serious reason to modify this, we will do it. >>=20 >> - chris >>=20 >>=20 >>=20 >> On Feb 29, 2012, at 19:26, Michael A. DeLorenzo wrote: >>=20 >>> It's been a while but I need to know if the AddFields bug has been=20= >>> fixed. I didn't want to assume.... >>>=20 >>> Thanks, >>> Mike >>>=20 >>> -----Original Message----- >>> From: Donovan Brooke [mailto:dbrooke@webdna.us] >>> Sent: Monday, October 13, 2008 6:49 PM >>> To: talk@webdna.us >>> Subject: Re: [WebDNA] [addfields] Restrictions >>>=20 >>> Michael A. DeLorenzo wrote: >>>=20 >>>> Has anyone experienced a limitation on the number of fields that = can=20 >>>> be added to a database at one time? I'm currently only able to add = 4=20 >>>> fields at one time to my database. >>>=20 >>>=20 >>> Looks to me like that tag is a bit buggy... didn't see any=20 >>> limitations in the source and some of my tests had odd results (also=20= >>> confirming adding only >>> 4 fields on a *nix environment.) >>>=20 >>> So, consider this added to the bug list! Thanks Michael. >>>=20 >>> Donovan >>>=20 >>>=20 >>>=20 >>> --=20 >>> Donovan D. Brooke PH/FAX: 1 (608) 291-2024 >>> ---------------------------------------------- >>> VP >>> WebDNA Software Corporation >>> 16192 Coastal Highway >>> Lewes, DE 19958 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to the = mailing=20 >>> list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> old archives: http://dev.webdna.us/TalkListArchive/ >>>=20 >>>=20 >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to the = mailing=20 >>> list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to the mailing=20= >> list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >>=20 >>=20 >>=20 >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to the mailing=20= >> list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to the mailing = list > . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us >=20 >=20 >=20 >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us christophe.billiottet@webdna.us

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 I invoke an ssi plugin from within a webcat page (1997) Multiple 'Users.db' files not possible (1997) Error 551 in Emailer (2000) No luck with taxes (1997) Corruption in images (2004) Redirect and passing more than one variable... (2002) Fun with dates (1997) How to include weather (2000) Emailer errors (1997) JavaScript Image Problem (1998) MacActivity and PCS (1997) F3 crashing server (1997) WC2f3 (1997) creating a 60 fields database (1997) Possible Shownext from Listfiles???? (2000) God's Truth (1998) Summary search -- speed (1997) WebCat2_Mac RETURNs in .db (1997) unable to launch acgi in WebCat (1997) SendTo more emails (1998)