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:

RE: IIS4b2 and WebCatalog b19 (1997) [WebDNA] Dead line Time Math (2017) Moment of Thanks (1997) TCPconnect in a DB? (1999) Generating unique SKU from [cart] (1997) Sorting Results (1999) Multiply prices (1997) Practice runs ? (1997) WebCatalog for Postcards ? (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Secured Order Forms (1998) New public beta available (1997) Laying an egg. (1998) So many lookers, hey smith micro (2003) send people in a database an email (2001) Help with Grep exchange (2005) Running _every_ page through WebCat ? (1997) Re:[input] context (1999) Harvesting invalid email addresses from bounced emails??? (2000) WebCat2 - [include] tags (1997)