Classic ASP DatabasesDiscuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
I want to create a database of articles for my customers to read. The articles include photos and videos.
What is the best way to store articles while still providing the security and organization that a database offers? I have found MS Access to be very limited in the amount of information a particular field can hold. Even using the Memo type, an article seems to be too large. The whole use of the database seems pretty cumbersome for storing large documents.
Judging by the various news sites (MSNBC, CNN, etc.), there must be some efficient way to do this.
How about using SQL server for storing data? You may think of using TEXT datatype there for storing article content.
I won't suggest you storing images in datbase, you can store the images and video files on the physical drives and use the path for that as URL in database, so that you can put up a link to that which corresponds to the article. On the maintenance part, you should ensure that you delete the files too when an article is removed.
Hope that helps.
- Vijay G Strive for Perfection
I know SQL is the standard for web based database work, but I've never had opportunity to work with it. How much data (bits or characters) does a single SQL text field allow? Some of my articles are actually chapters from some of my service manuals and tend to be pretty long. Needless to say, Access is really limited, but maybe SQL will work.
I agree with you on storing the videos and photos on the drive and simply pointing to them.