Please Help! Too few parameters. Expected 3.
So I keep getting an error
Error Executing Database Query. | |
| [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3. | |
The error comes from the bolded & italicised line. I have not changed anything recently in my code, it only started to happen today. Any suggestions on how to fix it?
And the block of code is:
<cffunction name="getArchives" access="public" returnType="query" output="false" >
<cfargument name="archiveYears" type="numeric" required="false" default="0">
<cfset var getMonthlyArchives = "" />
<cfset var fromYear = year(now()) - arguments.archiveYears />
<cfquery name="getMonthlyArchives" datasource="#instance.dsn#" username="#instance.username#" password="#instance.password#">
SELECT MONTH(tblBlogEntries.posted) AS PreviousMonths,
YEAR(tblBlogEntries.posted) AS PreviousYears,
COUNT(tblBlogEntries.id) AS entryCount
FROM tblBlogEntries
WHERE tblBlogEntries.blog = <cfqueryparam value="#instance.name#" cfsqltype="CF_SQL_VARCHAR" maxlength="50">
<cfif arguments.archiveYears gt 0>
AND YEAR(tblBlogEntries.posted) >= #fromYear#
</cfif>
GROUP BY YEAR(tblBlogEntries.posted), MONTH(tblBlogEntries.posted)
ORDER BY PreviousYears DESC, PreviousMonths DESC
</cfquery>
<cfreturn getMonthlyArchives>
</cffunction>
AdChoices