| Author |
Topic |
|
jaycupw
Starting Member
12 Posts |
 Posted - 2006-04-17 : 14:01:22
|
| Hi,I need some advice regarding displaying data from my SQL db in a web page. What I would like to do is this (think "job site" or similar when reading):1. Create a list of registrated users (in db) where2. every user listed is a hyperlink to3. a profile page which uses 4. a read-only template for viewing purposes onlyAll items above are for read-only purposes - no data input of any kind. The "template" will only contain certain fields from the registration. The ultimate goal is to have a web page (or section) for each 'category' where a list of members matching that category are displayed.I'm familiar with SQL query langauge but not with what would be "good practices" to accomplish the above. I have read some threads where people suggest using XML/XSLT to do similar tasks. What I would love is advice on how to approach the above. If there's any sample code (or similar) as a reference, I would be MOST grateful.Thanks a lot in advance! |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-17 : 14:33:31
|
| U want to create SL server / DB users orU want to create some users in a table as records for ur application ?Srinika |
 |
|
|
jaycupw
Starting Member
12 Posts |
Posted - 2006-04-17 : 14:45:51
|
| Hi,I have the db (SQL Express) + data in it. I need a way to display the data (per my original mesage).So, yes, create a user list in a html table would be a great start!Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-17 : 14:49:01
|
quote:
Originally posted by jaycupw
Hi,I have the db (SQL Express) + data in it. I need a way to display the data (per my original mesage).So, yes, create a user list in a html table would be a great start!Thanks.
What programming language are you familiar with?Tara Kizeraka tduggan |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-04-17 : 14:54:10
|
| jaycupw,Do u already have users in a table?If so give the table name / field names and the data u want to see.Also tell what is the language u use to interact with DB (is it ASP or ASP.Net or any other ?)Srinika |
|
|
|
jaycupw
Starting Member
12 Posts |
Posted - 2006-04-17 : 14:57:26
|
| Hi Tara,I've done stuff in Python and VB. Know HTML pretty well. Some ASP but not a lot. The core of my web site is based on DOTNETNUKE (ver 3.2.2). |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-17 : 15:01:23
|
| So which part do you need help with? The SQL queries, the application that executes the queries, ...?Tara Kizeraka tduggan |
|
|
|
jaycupw
Starting Member
12 Posts |
Posted - 2006-04-17 : 15:31:13
|
| Srinika and Tara,Since I'm using DOTNETNUKE, I believe it's ASP.NET.The process, currently only in thought, I envision is for each PAGE is1. select all entries from column "OnCallCat" from table "dnn_UCanUseUA_Fields" where "Category" = xxx2. produce a list of all entries matched with UserName, FirstName, LastName, etc, fields (username field hyperlink to profile template)3. create a display profile template to display selected user attributes (FirstName, LastName, contact info, etc).Thanks so much for your help! |
|
|
|
jaycupw
Starting Member
12 Posts |
Posted - 2006-04-17 : 15:35:39
|
| Tara,I'm not sure "how" to accomplish any of this in a good way.... :-(If I had a sample of required web components and their code, I think I would understand the process (!) better. It might be a lot simpler than I think but I have no references as to how to proceed...Thanks! |
|
|
|
jaycupw
Starting Member
12 Posts |
Posted - 2006-04-17 : 15:40:26
|
| Sorry - I'm not very clear in my descriptions. When I mention "display", it means RESULTS of query AND in a web page (table). |
|
|
|
|
Newbie need some advice