Have you tried running this code directly at the db?...i.e. if SQL run in
query analyser. One thing you could try is put trim statements around the
fied (or LTRIM and RTRIM if you are using SQL). i.e:
SELECT * FROM RodeoManager WHERE TRIM(CircuitID) = #TRIM(url.CircuitID)#
OR:
SELECT * FROM RodeoManager WHERE LTRIM(RTRIM(CircuitID)) =
#TRIM(url.CircuitID)#
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Dave f [mailto:[EMAIL 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: "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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
