Perhaps the problem lies in the output....what does that code look like?
*************
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-----Original Message-----
From: Jay Patton [mailto:[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 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
