Ask a Question related to Coldfusion Database Access, Design and Development.
-
jdeline #1
Re: user page creation
I presume you are using a database to hold the user IDs and passwords. If
there is only one category of stuff a user can look at, put the category name
in the user's record in the database.
If there are categories of "stuff" the user can access (news, sports, comics,
etc.) and a user can subscribe to multiple categories, you will need a new
table listing all the stuff. Then another table will map users to stuff
categories in a many-to-many relationship. Use a SELECT query with a JOIN to
retrieve all the stuff for a particular user. See sample below.
<!--- user table tblUser --->
id user password
3 harry ihsne56
8 sally cwhr74nd
<!--- mapping table tblMap --->
userId stuffId
3 22
3 43
3 25
8 43
8 56
<!--- stuff table tblStuff--->
id stuff
22 news
25 comics
43 sports
56 weather
jdeline Guest
-
Question about new page creation from template
Hello everyone! I'm relatively new to using Contribute (v3.11) and have an issue. I've created and uploaded a client's site, using DW8, to a... -
Dynamic Page Creation
I would like to be able to create pages dynamicly. The page name would dynamicly appear in the menu with a link to the page. All pages would work... -
Creation of ASPNET user in Active Directory 203
Hello, I unable to see ASPNET user in Active directory 2003. I installed asp.net on windows 2003 & IIS. So please tell me how to create ASPNET... -
Bizarre User Creation Problem
Hi All, I really hope someone out there can help me with this problem. I created a user and tested that they could connect to the server, they... -
Variables in html and user creation
im literate in html and im still wondering how a site like that neo pets game http://www.neopets.com has users create there own names, be able to...



Reply With Quote

