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:
WEBDNA tags don't process in a .js file (2002)
Trouble with formula.db (1997)
Append probs, please help (2001)
RE: [WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019)
WebCat B13 Mac CGI -- Frames question (1997)
[SHOWIF] (1997)
Separate SSL Server (1997)
emails sent twice (2001)
Thanks Grant (1997)
PCS Frames (1997)
Re[2]: Re[2]: WebCatalog on Linux (2000)
Location of Browser Info.txt file (1997)
Date Formats (1997)
WebDNA Windows 5.0 sendmail bug (2003)
Frames and WebCat (1997)
New index for docs (1997)
WebCatb15 Mac CGI -- [purchase] (1997)
RePost: NAT and the CART (1999)
More NT encyption!! (1999)
Quickie question on the email templates (1997)