Not too sure of format off the top of my head, but you it looks like you
need something like
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 1:45 PM
Subject: Re: statement help...
> I know there is more than one because i am looking in that specific table
>
m: "Jay Patton" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 23, 2001 12:16 PM
> Subject: Re: statement help...
>
>
> > i tried this also, and it still didnt work
> > since then i have switched every
: Monday, April 23, 2001 12:17 PM
To: CF-Talk
Subject: Re: statement help...
i tried this also, and it still didnt work
since then i have switched everything to be id specific now however, it
still only returns the first record w/ that id, now. any ideas this is
my query now
SELECT *
FROM
PROTECTED]]
Sent: 23 April 2001 18:07
To: CF-Talk
Subject: Re: statement help...
How do you know there are 12-ish if you only see 1??
Are you saying that getRodeos.RecordCount = 1, or have you maybe forgotten
to specify queryname in cfoutput loop?
Dave
- Original Message -
From
; <[EMAIL PROTECTED]>
Sent: Monday, April 23, 2001 12:16 PM
Subject: Re: statement help...
> i tried this also, and it still didnt work
> since then i have switched everything to be id specific now however, it
> still only returns the first record w/ that id,
lto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 12:17 PM
To: CF-Talk
Subject: Re: statement help...
i tried this also, and it still didnt work
since then i have switched everything to be id specific now however, it
still only returns the first record w/ that id, now. any ideas this is
my qu
ril 23, 2001 9:48 AM
Subject: Re: statement help...
> Try the following as your where clause:
>
> WHERE trim(Circuit) = '#trim(url.CircuitName)#'
>
> *** REPLY SEPARATOR ***
> On 4/23/2001 at 9:31 AM Jay Patton wrote:
>
> |Why would this only select one
Try the following as your where clause:
WHERE trim(Circuit) = '#trim(url.CircuitName)#'
*** REPLY SEPARATOR ***
On 4/23/2001 at 9:31 AM Jay Patton wrote:
|Why would this only select one record from the db?(there are about 12 it
|should return but it only returns one (which is t
Make sure that in the DB there are 12 for the exact length
and spelling of the URL.CircuitName
I had previous experience with the DB field containing
an extra space so the following are NOT the same:
URL.CircuitName = "CircuitOne"
DB.CircuitName= "CircuitOne "
-Original Message-
From
uld be
better.
Let me know if none of the above helps and I can work on a query using a
virtual table for you.
Bob
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: March 28, 2001 5:11 PM
To: CF-Talk
Subject: Re: Statement Help!!
would it be wise to try a sub query wit
-
From: "Bob Silverberg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 28, 2001 1:47 PM
Subject: RE: Statement Help!!
> What happens if you change the COUNT(EventID) to COUNT(DISTINCT EventID)?
>
> Bob
>
> -Original
quot;CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 28, 2001 1:47 PM
Subject: RE: Statement Help!!
> What happens if you change the COUNT(EventID) to COUNT(DISTINCT EventID)?
>
> Bob
>
> -Original Message-
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
>
What happens if you change the COUNT(EventID) to COUNT(DISTINCT EventID)?
Bob
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: March 28, 2001 3:09 PM
To: CF-Talk
Subject: Statement Help!!
what i am trying to accomplish here is to show ONLY those contestants that
hav
What results are you getting?
Take a look at the DISTINCT COUNT function, instead of the COUNT function.
This should take care of the same eventID in different rodeos.
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 2:09 PM
To: CF-Talk
Subj
14 matches
Mail list logo