On Sun, Aug 18, 2002 at 01:21:16PM -0500, Jeff Pelkey wrote: >I am having a small problem using DBI and HTML::Pager and was wondering if >somebody could tell me where I am going wrong. First, I'll state that I >have normally used "fetchrow_array" with H-T and had no problems. I read >that you need to use "selectall_arrayref", which I have never used - so I am >very unfamiliar with them. I get no errors, but I also get no data passed >to the template when I should receive 52 rows returned to the template.
Check the documentation for DBI. selectall_arrayref expects an actual SQL statement (text) as its argument, not a statement handle. I suggest you use fetchrow_arrayref or fetchall_arrayref. The output from the latter is the same as from selectall_arrayref, but you get to use cacheing, placeholders, and so on, as normal. Roger ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 _______________________________________________ Html-template-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/html-template-users
