Re: Limit to Field Length in DB
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16735
interpreted = N
texte = >Is there a limit to the number of characters for any one field in a database? > >I'm in the process of creating a story upload database to allow our editors >to post stories on our web site. In my testing, all of the stories have >been short. But knowing some of my editors, if there is a limit, they will >reach it. > >If there is a limit, my guess would be to create mutliple fields for >different sections of the article. Or is there another way? > >MarkOur engineering dept writes long tech articles, and what we did is have them ftp them into a folder. Lets say tech1.txt and tech2.txt is the names of the files they uploaded via ftp. The they fill out a form that lists the date, writer, subject, file name and a bunch of other search words and so forth. Then when somebody searches for an article on the display template right after the header we have something close to this[include /tech/[filename]]where the [filename] comes from the searchable data base.I know this is not do what you want to do. But it is a sloution that works.=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com ===============================================
Associated Messages, from the most recent to the oldest:
>Is there a limit to the number of characters for any one field in a database? > >I'm in the process of creating a story upload database to allow our editors >to post stories on our web site. In my testing, all of the stories have >been short. But knowing some of my editors, if there is a limit, they will >reach it. > >If there is a limit, my guess would be to create mutliple fields for >different sections of the article. Or is there another way? > >MarkOur engineering dept writes long tech articles, and what we did is have them ftp them into a folder. Lets say tech1.txt and tech2.txt is the names of the files they uploaded via ftp. The they fill out a form that lists the date, writer, subject, file name and a bunch of other search words and so forth. Then when somebody searches for an article on the display template right after the header we have something close to this[include /tech/[filename]]where the [filename] comes from the searchable data base.I know this is not do what you want to do. But it is a sloution that works.=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com ===============================================
grichter@panavise.com (Gary Richter)
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:
webmerchant/ Mac Auth. and CC refunds (1998)
Formating found categories (1997)
Append problem w/" (1999)
PIXO support (1997)
emailer error -108 (1997)
WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997)
Unknown error: OrderNotCreated (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
BR (1997)
problems with 2 tags (1997)
webdna+post+WinIE6 (2004)
4D Database (1997)
WebTen? (1997)
RAM variables (1997)
A dynamic database. (1997)
wrong input values? (1997)
[append] and SSL (1997)
Re:Emailer and encryption (1997)
autocommit problem (1998)
email error 159 (1998)