Help

2005-09-16 Thread Sridharan Muthuswamy
I encounter the following error when trying to use DBI.pm DBD driver has not implemented the AutoCommit attribute at /usr/lib/perl5/DBI.pm line 615. Appreciate if someone can let me know why this error is seen. Thanks __ Yahoo! Mail - PC

RE: RFC : AJAX + DBI = DBIx::LiveGrid

2005-09-16 Thread Martin J. Evans
Jeff, Nice one. However, it does not quite work with my DBD and database. What I see is the first 70 rows repeated as I scroll through the table. The SQL being executed does not seem correct: select * from ( select top 70 * from ( select top 70 col,col from table ) as foo ) as bar then

Re: Perl DBI / SQL Question

2005-09-16 Thread Scott R. Godin
Vance M. Allen wrote: Sorry if the cross-posting wasn't appropriate, but I need help with this and am not sure if it's more appropriate to post under CGI or DBI since it involves both...I want to be sure that I can get help from the best source. My question is probably a simple answer, but I

RE: RFC : AJAX + DBI = DBIx::LiveGrid

2005-09-16 Thread Martin J. Evans
Jeff, The problem I'm experiencing may be to do with the following from SQL::Abstract::Limit: = select( $table, [EMAIL PROTECTED], $where, [ [EMAIL PROTECTED], [ $rows, [ $offset ], [ $dialect ] ] ] ) Same as SQL::Abstract::select, but accepts additional $rows, $offset and $dialect

Re: RFC : AJAX + DBI = DBIx::LiveGrid

2005-09-16 Thread Jeff Zucker
Martin J. Evans wrote: Jeff, The $order parameter is required if $rows is specified. Ah, yes, of course, thanks for spotting that. To confirm, does it scroll correctly when you do specify an order (i.e. by clicking on a column heading to toggle ordering by that column)? If it does

RE: [dbi] Re: RFC : AJAX + DBI = DBIx::LiveGrid

2005-09-16 Thread Martin J. Evans
On 16-Sep-2005 Jeff Zucker wrote: Martin J. Evans wrote: Jeff, The $order parameter is required if $rows is specified. Ah, yes, of course, thanks for spotting that. To confirm, does it scroll correctly when you do specify an order (i.e. by clicking on a column heading to toggle

Off topic, but on-community...

2005-09-16 Thread Matthew Persico
Within the past few months, I read an article which presented a Perl module running under Apache that reads a config file to generate a web interface for updating a table in a database, complete with the ability to use reference tables, specify explicit SQL, etc. I cannot for the life of me

Re: Off topic, but on-community...

2005-09-16 Thread Dean Arnold
Matthew Persico wrote: Within the past few months, I read an article which presented a Perl module running under Apache that reads a config file to generate a web interface for updating a table in a database, complete with the ability to use reference tables, specify explicit SQL, etc. I

Re: Off topic, but on-community...

2005-09-16 Thread Randal L. Schwartz
Matthew == Matthew Persico [EMAIL PROTECTED] writes: Matthew Within the past few months, I read an article which presented Matthew a Perl module running under Apache that reads a config file Matthew to generate a web interface for updating a table in a Matthew database, complete with the ability