I have a qoq like so,
<cfstoredproc
procedure="LEO4_ADMIN_DISTINCT_DAILY"
datasource="#request.matrixDSN#"
username="#request.matrix#"
password="#request.neo#">
<cfprocresult name="q_distinctData">
<cfprocparam dbvarname="@customerid" value="#attributes.id#" cfsqltype="cf_sql_integer" type="in">
<cfprocparam dbvarname="@date" value="#oneDay#" cfsqltype="cf_sql_integer" type="in">
<cfprocparam dbvarname="@schname" value="#attributes.macro#" cfsqltype="cf_sql_varchar" type="in">
</cfstoredproc>
<cfquery dbtype="query" name="q_qoq">
SELECT vehicleid
FROM q_distinctData
WHERE vehicleid in ('165','564')
</cfquery>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]