"David Freeman" wrote in message
news:uN**************@TK2MSFTNGP11.phx.gbl...
: I'm developing a website for a software company. They want to publish
news,
: tip/tricks and other articles on company's news section.
:
: I would like to get advice on
: - how to name the individual article files? (There will be 1000s of them)
: - how to let the user query it? (i.e. news/index.asp?articleID=234544 or
: what?)
:
: I preffered a standard way to do all this. Pointer to any sample or
tutorial
: on this will be much appericated!!
Hi David...
You could use a database and a FSO to accomplish your goals. Use the
database to store specific information related to the files and text content
and files to store images with CSS templates used to format the data.
I'm sure there are numerous ways to accomplish what you want. IMHO,
assigning categories, as you would with a chart of accounts would be one
example for naming where characters in a filename represent a category.
Chart:
Category/Length:
Type: 1
SubType: 1
Article Number: 5
Types:
News: 1
Tip: 2
Other: 3
SubType:
Database: 1
Applications: 2
Support: 3
an ID of: 2101023 would be Article 1023 in the database tip area.
Your mileage will vary with your specific needs.
What I would not do is waste time using a category for data [current,
recent, archived] because you could just use a date column in your table and
use ranges when you query.
Current: 0-30 days
Recent: 31-90 days
Archived: 91+ days
If you use files to store your content then you can just test with
DateCreated, DateLastModified.
Aaron's site [aspfaq.com] appears to have what you're looking for. You
might want to see if he will provide you with some pointers to get you
going.
HTH...
--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center -
http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation -
http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library -
http://msdn.microsoft.com/library/default.asp