DECLARE @q1 varchar(7)
SELECT @q1 = period_name
FROM adj_periods
WHERE period_id = 1
And If I try to do this in CF:
<cfquery name="sales" datasource="forecasting"
DECLARE @q1 varchar(7)
SELECT @q1 = period_name
FROM adj_periods
WHERE period_id = 1
</cfquery>
I get this error:
QUERY The QUERY attribute of the tag does not specify the name of an available query
This is a simplified version of my problem, but it seems that CF will execute the query without an error but the returned query structure won't exist at all.
Has anyone else ran into this problem?
Thanks,
Chris
[EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
