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
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
: 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
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
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
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
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
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
- 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
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
10 matches
Mail list logo