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:
Big Databases (1997)
Porting to NT (2001)
Can a database get stomped by simultaneous access? (1997)
Chatroom (2000)
Database field limit? (1998)
Languages (1997)
creator code (1997)
2.1b3 --> way slow (1997)
show all problem (1997)
What Country (2004)
groupfields .. again... (2000)
formatting dates from a field ... (1997)
Secure server question (1997)
uhm? (2003)
Press Release hit the NewsWire!!! (1997)
Math Problem - Format? (1997)
[OT] Democratic Code (2002)
Major bug report on rootbeer (1997)
Search context not finding recent entries (1998)
Problem (1997)