You shouldn't have a list in the username table, but you should create a
related table:
Table User (user_id,username)
Table UserDpt (user_id,dpt_id)
Table Dpt (dpt_id,dptname)
With the appropriate PK, FK and relational integrity set up.
Then
SELECT u.username, d.dptname
FROM User u, UserDpt ud,
Hi
i cannot change the DB design ,i have to do with the current DB Structure
noproblem if the query take time ,without using cfqueryparam i am using 4.5 so i cannot use cfqueryparam
regards
Vishnu Prasad
>You shouldn't have a list in the username table, but you should create a
>related table:
ROM department
#qUsers.username#
#stDpt[i]#
#i#
Pascal
> -Original Message-
> From: vishnu prasad [mailto:[EMAIL PROTECTED]
> Sent: 08 October 2004 13:49
> To: CF-Talk
> Subject: Re: Urgent:coldfusion report
>
> Hi
>
> i cannot change the DB desi
> Sent: 08 October 2004 13:49
> To: CF-Talk
> Subject: Re: Urgent:coldfusion report
>
> Hi
>
> i cannot change the DB design ,i have to do with the current DB
Structure
> noproblem if the query take time ,without using cfqueryparam i am
using
> 4.5 so i cannot use cfq
Hi i need an SQL Query
cos i am building report in Crystal report so i cant have structure and cfqueryparam
it would be nice if i can it in SQL query
regards
vishnu
>If you want to know what tags ( & attributes) or functions you can use
>in the different versions of CF (starting from CF4):
With that DB design, I don't think you can. If you need sql only, change
the db structure.
> -Original Message-
> From: vishnu prasad [mailto:[EMAIL PROTECTED]
> Sent: 08 October 2004 14:40
> To: CF-Talk
> Subject: Re: Urgent:coldfusion report
>
> Hi i ne
bad design using only
SQL.
-Mark
Mark A. Kruger, CFG, MSCE
www.cfwebtools.com
www.necfug.com
-Original Message-
From: vishnu prasad [mailto:[EMAIL PROTECTED]
Sent: Friday, October 08, 2004 7:40 AM
To: CF-Talk
Subject: Re: Urgent:coldfusion report
Hi i need an SQL Query
cos i am bu
To rephrase Pascal Peters's words, the username table does not even pass 1NF to begin with, re-design the db, imho.
> Hi All
>
> i have a prblme in a displaying a report
> Table username
> username dep_code
> --
> testuser Sal,Pur
> testuser1 sal,Acc
> testuser
8 matches
Mail list logo