That error is coming from your MS Access driver. You might want to confirm that you have the same driver version installed on both machines as well to eliminate that as a possibility. Not sure how to do that off the top of my head.
Dave -----Original Message----- From: John Ahlen [mailto:[email protected]] Sent: Wednesday, January 07, 2009 12:27 PM To: cf-newbie Subject: Query issue 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:4266 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
