all groups > sql server programming > november 2004 >
You're in the

sql server programming

group:

How tough a project is this?



How tough a project is this? fwells11 NO[at]SPAM hotmail.com
11/25/2004 11:28:00 PM
sql server programming: Hi there. First let me apologize for attempting to post this message
a minute ago and somehow posting it before I had finished writing it.

I want to create a web based software rating database. I have a
number of objectives that I would need to achieve to make this a
useable tool and some are not easy figure out considering my
begginning level of db and asp knowledge. I am hoping that with an
asp code generator and some occasional feedback from the talent that
roams this newsgroup, I may be able to accomplish my goal.

Here are the objectives of this tool:

1. Authenticated visitors must to be able to create Sub-Categories
under a drop down list of pre-defined Categories. The drop down list
also needs to be dynamically updated as new Categories are added to
it.

2. Authenticated visitors must be able to add software titles (and
other attributes) under the Sub-Categories.

3. Non authenticated visitors (public) need to be able to search and
browse the list of titles and add a rating to them.

4. The ratings will be on a number of criterion and the actual rating
figures need to be averaged and then displayed as a graphic on the end
of each search result line item etc.

There are tens of thousands of software titles and this tool would be
available to the Internet so this has the potential of becoming a
large database. This makes poorly scaleable MSAccess out of the
question. My next two realistic database choices are MSSQL 2000 or
MySQL. I have a preference for MSSQL 2000 because I am pretty
familiar with it and I already have a environment where I can build my
project.

What I am hoping for out of this post is some feedback as to how
difficult a project this really is. Feedback appreciated.

RE: How tough a project is this? John Bell
11/26/2004 12:09:03 AM
Hi Frank

You m,ay want to browse http://www.aspfaq.com/categories.asp and if you
decide to use a .NET implementation then you ,may get a head start with

http://www.asp.net/Default.aspx?tabindex=9&tabid=47

Other useful .NET sites are listed:
http://www.aspfaq.com/show.asp?id=2103


John

[quoted text, click to view]
Re: How tough a project is this? fwells11 NO[at]SPAM hotmail.com
11/26/2004 11:54:34 PM
[quoted text, click to view]
Thanks for the feedback John. I have thrown together my thoughts and
what little work I have done on this so far into a collection of web
pages that can be accessed here until my IP address changes.

http://24.24.175.182/rating/ratings.htm

Take a look if you would be so kind and offer up anything else that
springs to mind please.

Thanks again,
AddThis Social Bookmark Button