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:
Interfacing WebMerchant to www.fedex.com (1997)
Nested tags count question (1997)
Date Math broken on Mac OS X 10.4? (2007)
limitation found on group searching (1997)
Can this be done? (2003)
Inventory Control (2000)
NetSplat and WebCat2 (1997)
[Sum] function? (1997)
pop up menu's (1998)
docs for WebCatalog2 (1997)
pc (1997)
RE: strip .0 off off IPaddress (1998)
Striping Characters (1998)
Browser blocking (2002)
WebCatalog2 Feature Feedback (1996)
[OT] - See my site? (2004)
SSL, WebSTAR, WebCatalog (1998)
SiteEdit NewFile.html ? (1997)
totals (1997)
[shownext] and descending order (1997)