[thelist] ColdFusion--"Too few parameters!"

Karn karnsg at gmail.com
Thu Mar 16 19:44:51 CST 2006

I'm building a table on simple CF page to list rows in a database, and each
column heading serves as a link to "sort" the table by that category. To do
this, I'm using a <CFPARAM> tag in the first line of the document to define
a default value, and then a <CFSWITCH> tag within the ORDER BY statement in
the query itself.

So, for example, when I click the column heading "Joined," the same page
should load, but it will be passed a variable so that the URL looks like
this instead: "/MemberList.cfm?SortMem=JA" That is, "Sort Members = Joined
Ascending." I used this *identical* method on a similar page with *complete*
success. With this page, however, CF throws this error:

   Error Executing Database Query.
 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 1.

I'm almost certain this error is coming from my <CFPARAM> tag, but I've
checked and doublechecked the syntax. I eventually just copied the entire
source from the successful page into a new file and just corrected the
appropriate tags. The only real difference between these two pages is that
the working page draws data from two tables, and the broken page draws data
from only one.

What in the world is going on?
Thanks a lot
-KarnSG at gmail.com

More information about the thelist mailing list