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]
