<CFQUERY name="Test" datasource="#ds#">
SELECT CF_CLASS
FROM CALL_FREQUENCY_MATRIX
WHERE cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2
AND CF_LOC_ID = '77'
AND CF_EXISTCONQ = 'E'
AND PF_ID = 'CE'
AND CF_GROUP = 'CE'
</CFQUERY>
>From: "Burcham, Steve" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Strange Query Problem
>Date: Tue, 23 Dec 2003 10:41:26 -0600
>
>I have a query that returns one character that is used for classing our
>customer. The query runs fine in query analyzer, but returns zero records
>when I try to run it from a ColdFusion page. Any ideas?
>
><CFQUERY name="Test" datasource="#ds#">
>DECLARE @cf_units int
>
>SET @cf_units = #fleetsizece#
>
>SELECT CF_CLASS
>FROM CALL_FREQUENCY_MATRIX
>WHERE @cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2
>AND CF_LOC_ID = '77'
>AND CF_EXISTCONQ = 'E'
>AND PF_ID = 'CE'
>AND CF_GROUP = 'CE'
></CFQUERY>
>
>
>Here is the result set that I get.
>
>Test (Records=0, Time=16ms)
>SQL =
>DECLARE @cf_units int
>
>SET @cf_units = 4
>
>SELECT CF_CLASS
>FROM CALL_FREQUENCY_MATRIX
>WHERE @cf_units BETWEEN CFM_PARAM1 AND CFM_PARAM2
>AND CF_LOC_ID = '77'
>AND CF_EXISTCONQ = 'E'
>AND PF_ID = 'CE'
>AND CF_GROUP = 'CE'
>
>Thank you.
>
>Steve Burcham
>Webmaster
>RDO Equipment Co.
>Phone (701) 526-9838
>Fax (701) 526-9839
> <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
