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: "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 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....
>
> <cfquery name="getRodeos"
> datasource="#datasource#"
> dbtype="ODBC"
> username="#username#"
> password="#password#">
> SELECT *
> FROM RodeoManager
> WHERE CircuitID = #url.CircuitID#
> </cfquery>
>
> thanks,
>
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> p. 406.549.3337 ext. 203
> p. 1.888.5WEBPRO ext. 203
> e. [EMAIL PROTECTED]
> url. www.webpro-usa.com
> ----- Original Message -----
> From: "Mike Sprague" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 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 record from the db?(there are about 12
it
> > |should return but it only returns one (which is the first one)
> > |
> > |<cfquery name="getRodeos"
> > | datasource="#datasource#"
> > | dbtype="ODBC"
> > | username="#username#"
> > | password="#password#">
> > |SELECT *
> > |FROM RodeoManager
> > |WHERE Circuit = '#url.CircuitName#'
> > |</cfquery>
> > |
> > |
> > |Thanks,
> > |
> > |Jay Patton
> > |Web Design / Application Design
> > |Web Pro USA
> > |p. 406.549.3337 ext. 203
> > |p. 1.888.5WEBPRO ext. 203
> > |e. [EMAIL PROTECTED]
> > |url. www.webpro-usa.com
> > |
> > | |
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
