[thelist] Help with SQL/CF
ted serbinski
tss24 at cornell.edu
Tue Jan 15 21:11:02 CST 2002
Ok I've finally decided to dive into the backend of web development, but
I have a few questions. For starters, I'm using Windows XP, with SQL
2000, and Cold Fusion 4.5 installed.
Basically I need to create an application the first setups X number of
databases to hold records for each school entered (or are they called
tables?). Once setup, I need to be able to have a new user signup in
whatever school they want. Then they can login and see a list of events
in the database for that school only. Also a user can signup as an admin
person if they have the correct password and page view/ect.
So that's what I'm doing. But now where do I begin? First off, is there
a way in Cold Fusion to create a database? Or do I have to do this
manually? If so, how do I set this up manually in SQL? Also if so, would
I then only need to create a new table for each school entered? I think
this is what I have to do but I'm not too sure.
I know Cold Fusion is supposed to simplify this stuff greatly so is
there a quick tutorial of how I can enter stuff in a database,
retrieve/delete stuff?
And one last thing, structuring data, I know this is key, so I want to
do it right the first time. Basically I have to keep track a few things.
-how many schools I have and under each school, one of these 3 types of
people:
a. student name, gender, age, grade, and few other relate items.
b. activity supervisor, password
c. admin name, password
-depending on their status above, they are to view only certain pages,
ect.
Now what would be the best way to setup my data in a table? I was
thinking somewhere along the lines:
ID# Name UserName Password Gender Age Grade School Restrict
43 Joe Joe3 sky M 15 10 NSHS YES
Would something like above work? Is there an easy way to assign ID #s to
people? What if I were to delete a person? Just delete their ID# and
that line?
Any help /comments are greatly appreciated.
Thanks
ted
More information about the thelist
mailing list