Getting 4 results where there should be only 2

2004-10-25 Thread Phillip Perry
When I do something like this... cfquery datasource=#mydbname# name=getinfo SELECT * FROM Table1,Table2 /cfquery and there are only 2 records to show, the output shows those 2 records twice. I'm assuming that its becuase there are 2 tables so it shows it twice. How do I get around this? This

RE: Getting 4 results where there should be only 2

2004-10-25 Thread Ewok
You could try grouping by something distinct or selecting distinct -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 2:45 PM To: CF-Talk Subject: Getting 4 results where there should be only 2 When I do something like this... cfquery

Re: Getting 4 results where there should be only 2

2004-10-25 Thread Deanna Schneider
: Getting 4 results where there should be only 2 When I do something like this... cfquery datasource=#mydbname# name=getinfo SELECT * FROM Table1,Table2 /cfquery and there are only 2 records to show, the output shows those 2 records twice. I'm assuming that its becuase there are 2 tables

RE: Getting 4 results where there should be only 2

2004-10-25 Thread Phillip Perry
I tried this and I'm getting an error saying too few parameters expecting 2. Dont know what that means though. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 2:59 PM To: CF-Talk Subject: Re: Getting 4 results where there should be only 2

Re: Getting 4 results where there should be only 2

2004-10-25 Thread Ian Sheridan
or selecting distinct -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 2:45 PM To: CF-Talk Subject: Getting 4 results where there should be only 2 When I do something like this... cfquery datasource=#mydbname# name=getinfo SELECT * FROM

Re: Getting 4 results where there should be only 2

2004-10-25 Thread Deanna Schneider
Um, that was totally pseudocode. You did modify it for your table structure, right? It might help to actually post the table structure. - Original Message - From: Phillip Perry I tried this and I'm getting an error saying too few parameters expecting 2. Dont know what that means

RE: Getting 4 results where there should be only 2

2004-10-25 Thread Phillip Perry
is misspelled. and ContactID is in both tables spelled the same way. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 3:33 PM To: CF-Talk Subject: Re: Getting 4 results where there should be only 2 Um, that was totally pseudocode. You did

RE: SOLVED Getting 4 results where there should be only 2

2004-10-25 Thread Phillip Perry
PROTECTED] Sent: Monday, October 25, 2004 3:38 PM To: CF-Talk Subject: RE: Getting 4 results where there should be only 2 Yes I adjusted it for my purpose and I even spelled out every single fieldname in the select clause, but doing that just gave me the same error except now its missing 3

Re: Getting 4 results where there should be only 2

2004-10-25 Thread Deanna Schneider
- Original Message - From: Phillip Perry [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 25, 2004 2:37 PM Subject: RE: Getting 4 results where there should be only 2 Yes I adjusted it for my purpose and I even spelled out every single fieldname in the select clause

RE: Getting 4 results where there should be only 2

2004-10-25 Thread dave
PROTECTED] Sent: Monday, October 25, 2004 3:33 PM To: CF-Talk Subject: Re: Getting 4 results where there should be only 2 Um, that was totally pseudocode. You did modify it for your table structure, right? It might help to actually post the table structure. - Original Message - From: Phillip