Re: [Dbix-class] @bind confusion

2010-12-24 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: Hello, when using subqueries in the 'from' part of a query, sometimes the list of @bind parameters is not maintained correct. This problem has *finally* been solved. It should show up on CPAN shortly. https://rt.cpan.org/Ticket/Display.html?id=61025#txn-873219 Cheer

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: Peter, Am 03.08.2010 um 14:34 schrieb Peter Rabbitson: Wolfgang Kinkeldei wrote: Hi Peter, If you need the full schema files, I could provide a tarball for you. No need for these. This is the search taken from my project. The points marked like (1), (2), (3) cont

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Wolfgang Kinkeldei
Peter, Am 03.08.2010 um 14:34 schrieb Peter Rabbitson: > Wolfgang Kinkeldei wrote: >> Hi Peter, >> If you need the full schema files, I could provide a tarball for you. > > No need for these. > >> This is the search taken from my project. The points marked like (1), (2), >> (3) contain places

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: Hi Peter, If you need the full schema files, I could provide a tarball for you. No need for these. This is the search taken from my project. The points marked like (1), (2), (3) contain places where changes make the query work or fail. my $nr_uploads = $sche

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Wolfgang Kinkeldei
Hi Peter, If you need the full schema files, I could provide a tarball for you. However, this is nothing that I would like to see in the mailing list as a whole. It would not help most of the people reading this thread... Am 03.08.2010 um 13:20 schrieb Peter Rabbitson: > Wolfgang Kinkeldei wr

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: Hello, when using subqueries in the 'from' part of a query, sometimes the list of @bind parameters is not maintained correct. As a simple testcase please find a primitive subselect enclosed that just does a count with a correlated subquery. # a simple counting subqu

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Wolfgang Kinkeldei
Hi, Am 03.08.2010 um 12:11 schrieb Peter Rabbitson: > Wolfgang Kinkeldei wrote: >> ... >> however, if the join is present: >> DBIx::Class::ResultSet::all(): Cannot bind unknown placeholder 3 (3) at >> /Library/Perl/5.10.0/DBIx/Class/Storage/DBI.pm line 1475. > > Please provide the DBIC_TRACE=1

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Wolfgang Kinkeldei
Hi Peter, Am 03.08.2010 um 11:59 schrieb Peter Rabbitson: > Wolfgang Kinkeldei wrote: >> Hello, >> when using subqueries in the 'from' part of a query, sometimes the list of >> @bind parameters is not maintained correct. As a simple testcase please find >> a primitive subselect enclosed that ju

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: ... however, if the join is present: DBIx::Class::ResultSet::all(): Cannot bind unknown placeholder 3 (3) at /Library/Perl/5.10.0/DBIx/Class/Storage/DBI.pm line 1475. Please provide the DBIC_TRACE=1 of what SQL is generated right before you see this error.

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: Hello, when using subqueries in the 'from' part of a query, sometimes the list of @bind parameters is not maintained correct. As a simple testcase please find a primitive subselect enclosed that just does a count with a correlated subquery. # a simple counting subqu

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Wolfgang Kinkeldei
Peter, Am 03.08.2010 um 10:49 schrieb Peter Rabbitson: > Wolfgang Kinkeldei wrote: >> Hello, >> when using subqueries in the 'from' part of a query, sometimes the list of >> @bind parameters is not maintained correct. As a simple testcase please find >> a primitive subselect enclosed that just

Re: [Dbix-class] @bind confusion

2010-08-03 Thread Peter Rabbitson
Wolfgang Kinkeldei wrote: Hello, when using subqueries in the 'from' part of a query, sometimes the list of @bind parameters is not maintained correct. As a simple testcase please find a primitive subselect enclosed that just does a count with a correlated subquery. Were you helped with this

[Dbix-class] @bind confusion

2010-07-19 Thread Wolfgang Kinkeldei
Hello, when using subqueries in the 'from' part of a query, sometimes the list of @bind parameters is not maintained correct. As a simple testcase please find a primitive subselect enclosed that just does a count with a correlated subquery. # a simple counting subquery my $subquery = $sch