Hello All,
I have a problem with a query that works on my CF developer's 7.0.2.142559
server. However, when it runs on 7.0.1.116466 I get the following error:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 9.
The query is:
<!--- Returns Turn Around Time for book Orders --->
<cffunction name="getOrderCompl" returntype="query">
<!--- do not inlude orderType of 3 or 7 (AV, Ebook) --->
<cfargument name="startdate" type="date">
<cfargument name="enddate" type="date">
<cfquery name="qGetOrders"
datasource="#APPLICATION.datasource#">
SELECT DateDiff("d",p.DateCreated,i.DateRecd) AS
sumDiff,
v.vendorPk,v.vendorName,
p.poId
FROM ((Vendor v INNER JOIN P_PoNumber p ON v.VendorpK =
p.vendor)
INNER JOIN P_Invoice i ON i.poNumber = p.poId)
WHERE i.dateRecd BETWEEN <cfqueryparam
cfsqltype="cf_sql_date" value="#ARGUMENTS.startDate#"> AND <cfqueryparam
cfsqltype="cf_sql_date" value="#ARGUMENTS.enddate#">
AND (i.OrderType = <cfqueryparam
cfsqltype="cf_sql_integer" value="1"> OR
i.OrderType = <cfqueryparam
cfsqltype="cf_sql_integer" value="4"> OR
i.OrderType = <cfqueryparam
cfsqltype="cf_sql_integer" value="5"> OR
i.OrderType = <cfqueryparam
cfsqltype="cf_sql_integer" value="6"> OR
i.OrderType = <cfqueryparam
cfsqltype="cf_sql_integer" value="8"> OR
i.OrderType = <cfqueryparam
cfsqltype="cf_sql_integer" value="9">)
ORDER BY v.vendorname
<!---GROUP BY v.vendorPk,v.vendorName,p.Poid,sumDiff--->
</cfquery>
<!--- Gets and Sums total number of days between PODate and
InvReceived date --->
<cfquery name="qGetDateDiff" dbtype="query">
SELECT AVG(sumDiff) AS avgDiff,
vendorPk,
vendorName
FROM qGetOrders
WHERE sumDiff > <cfqueryparam
cfsqltype="cf_sql_integer" value="0">
GROUP BY vendorPk,vendorName
ORDER BY vendorPk
</cfquery>
<cfreturn qGetDateDiff>
</cffunction>
Thanks in advance,
John
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4264
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
