RE: Urgent:coldfusion report

2004-10-08 Thread Pascal Peters
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,

Re: Urgent:coldfusion report

2004-10-08 Thread vishnu prasad
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:

RE: Urgent:coldfusion report

2004-10-08 Thread Pascal Peters
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

RE: Urgent:coldfusion report

2004-10-08 Thread Pascal Peters
> 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

Re: Urgent:coldfusion report

2004-10-08 Thread vishnu prasad
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):

RE: Urgent:coldfusion report

2004-10-08 Thread Pascal Peters
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

RE: Urgent:coldfusion report

2004-10-08 Thread Mark A Kruger
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

Re: Urgent:coldfusion report

2004-10-08 Thread Don
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