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:
RE: [WebDNA] Libmysql.dll error (2009)
Re:2nd WebCatalog2 Feature Request (1996)
Why does the following crash WebCat? (2000)
Part Html part WebDNA (1997)
[ListFiles] context & alias (1997)
Download URL & access on the fly ? (1997)
WebStar CGI Version (2005)
cybercash (1997)
Email Line Breaks (2003)
Re:ListFields and [name] (1997)
WebCat2 Append problem (B14Macacgi) (1997)
How to append text after the sign & (1997)
re: [addlineitem] working almost (1997)
RE: WebDNA-Talk searchable? (1997)
Database Fields (1997)
WebCat for mass emailings (1997)
[append] (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
Cart # Starting at 1000 (2000)
browser info.txt and SSL (1997)