> Can someone give me debugging tips for working with Template::Plugin::DBI?
>
> Maybe it's the flu getting to me, but I'm not seeing what I'm doing wrong
> with this usage. It's not sorting like I expect: It's sorting by "title"
> not "sortorder,title". sortorder is a number.
>
> [% USE DBI(database.dsn, database.user, database.password) %]
> [% query = DBI.prepare('SELECT name, title FROM people WHERE type = ? and
> display = "yes" ORDER BY ?,?') %]
You also need to select sortorder:
[% query = DBI.prepare('SELECT name, >>>sortorder,<<< title FROM people WHERE type
= ? and
display = "yes" ORDER BY ?,?') %]
Craig
