Re: [Templates] syntax problems with Template::DBI

2008-11-13 Thread M
On Thu, Nov 13, 2008 at 01:02:11PM +, M wrote: >On Wed, Nov 12, 2008 at 07:18:12PM +, Andy Wardley wrote: >>http://template-toolkit.org/svnweb/Template-DBI/diff/trunk/lib/Template/Plugin/DBI.pm?rev1=1;rev2=2 >> >>You can check out the latest version like so: >> >> $ svn co svn://svn.tt2.o

Re: [Templates] syntax problems with Template::DBI

2008-11-13 Thread M
On Wed, Nov 12, 2008 at 07:18:12PM +, Andy Wardley wrote: > >Josh Rosenbaum wrote: >>My guess is that the execute() routine does not handle an arrayref being >>passed > >Your guess would be correct. My bad. h I found real bug, or misimplemented feature at least. >>Possible Solutions: >

Re: [Templates] syntax problems with Template::DBI

2008-11-12 Thread Andy Wardley
Kelly Thompson wrote: > I suggest you move the DBI interaction into the perl, script. > Just a thought... For most applications, yes, a clear separation of concerns is a Good Thing[tm]. But then the DBI plugin exists specifically for those occasions when you can't, don't want to, or don't need to

Re: [Templates] syntax problems with Template::DBI

2008-11-12 Thread Kelly Thompson
I suggest you move the DBI interaction into the perl, script. Just a thought... On Wed, Nov 12, 2008 at 2:18 PM, Andy Wardley <[EMAIL PROTECTED]> wrote: > Josh Rosenbaum wrote: > > My guess is that the execute() routine does not handle an arrayref being > passed > > Your guess would be correct

Re: [Templates] syntax problems with Template::DBI

2008-11-12 Thread Andy Wardley
Josh Rosenbaum wrote: > My guess is that the execute() routine does not handle an arrayref being > passed Your guess would be correct. My bad. > Possible Solutions: *) Get Andy to fix it I've committed a fix to the subversion repository. http://template-toolkit.org/svnweb/Template-DBI/diff/t

Re: [Templates] syntax problems with Template::DBI

2008-11-12 Thread Josh Rosenbaum
M wrote: [SNIP] > [% FOREACH customer = main.execute(bind) %] [SNIP] > But When I run it I get > > [Wed Nov 12 18:16:43 2008] [error] [client 92.41.135.118] DBI error - > execute failed: called with 1 bind variables when 2 are needed, referer: > http://test > > I've been wondering if I

[Templates] syntax problems with Template::DBI

2008-11-12 Thread M
Hello again, Sorry to bother again, but I've been fiddling with this for the best part of today and don't seem to be getting anywhere. http://search.cpan.org/~abw/Template-DBI-2.64/lib/Template/Plugin/DBI.pm says that the execute function takes an array for the bind values execute(@args) I've