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

Mark Mandel mark.mandel at gmail.com
Thu Mar 16 21:30:26 CST 2006

Any chance on seeing the code?

I left my mindreading hat in the car today ;o)


On 3/17/06, Karn <karnsg at gmail.com> wrote:
> 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
> --

E: mark.mandel at gmail.com
W: www.compoundtheory.com
ICQ: 3094740

More information about the thelist mailing list