Re: [Dbix-class] PROCEDURE ANALYSE (1, 2);

On 09/26/2014 11:44 AM, Максим Владимирович wrote: how to do? SELECT * FROM `DisPacket` WHERE `TownFrom` =2 AND `State` =62 PROCEDURE ANALYSE (1, 2); Hi! Sorry for the very late reply. Just checking if your question was ever answered? If not - please give me more details wrt the syntax: Wha

[Dbix-class] automated response

I will be out of the office until January 5th. If you need immediate assistance please contact calc_supp...@intex.com. Lawrence Hochberg ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://d

Re: [Dbix-class] Connection timeouts?

On 10/10/2014 06:37 AM, Bill Moseley wrote: On Thu, Oct 9, 2014 at 6:32 PM, Ben Tilly mailto:bti...@gmail.com>> wrote: The obvious thing to try is to use the alarm() function to send yourself a signal and set a signal handler that will just die to escape. But this is unlikely to wor

Re: [Dbix-class] DBIC and Moo woes

On 10/02/2014 04:21 AM, Aran Deltac wrote: I've been converting a lot of @work's custom components, result, result set, schema, and storage classes (yes, we even have custom storage classes) to Moo roles and classes. Hi Aran, Just wanted to followup whether the current stable DBIC and Moo ver

Re: [Dbix-class] Escaping placeholders

On Fri, Dec 19, 2014 at 01:12:16PM +0100, Alexander Foken wrote: > Hello all, > > this reminds me of a similar problem I had in 2000 with DBI, > DBD::Oracle, and Oracle. See > , > . > > Problem was u

Re: [Dbix-class] Escaping placeholders (was: Using Postgres JSONB operators in queries)

There'll need to be a change to DBD::Pg before \? will work. I've opened a case for it https://rt.cpan.org/Ticket/Display.html?id=101030 Once implemented you'd use the usual SQL::Abstract way of specifying operators: https://metacpan.org/pod/SQL::Abstract#Specific-comparison-operators Tim. On F

Re: [Dbix-class] update and join

On 11/13/2014 12:34 PM, RAPPAZ Francois wrote: I have two tables joined by a "belongs to" and a "has many" relationship Ddref idref iduser finished created nn--+ ^ ¦ ¦ ¦RefUser (bt iduser)

Re: [Dbix-class] Dynamic/Flexible DBIC views

On 11/21/2014 02:38 PM, Christian Lackas wrote: Hi Everybody, tl;dr: what is the best way to dynamically create the definition of a virtual view or create an entire virtual view on the fly? Sorry for the late reply, was busy with some other stuff. I would like to drill deeper into this and f

Re: [Dbix-class] prefetch across multiple tables

On 12/17/2014 07:39 PM, John Stoffel wrote: Hi all, With a bit of nudging, I had a head-smack moment and upgraded to the latest version of DBIx::Class on CPAN, and it now looks like things are working better for me, but I'm still getting some interesting behavior. Before I got errors, now I ca

Re: [Dbix-class] Escaping placeholders

On 12/20/2014 03:38 PM, Tim Bunce wrote: On Fri, Dec 19, 2014 at 01:12:16PM +0100, Alexander Foken wrote: Hello all, this reminds me of a similar problem I had in 2000 with DBI, DBD::Oracle, and Oracle. See ,

[Dbix-class] Numbered placeholders and DBIC

On 12/19/2014 11:40 AM, Tim Bunce wrote: For code using DBIx::Class the problem is more tricky. I'm pretty sure that SQL::Abstract and thus DBIx::Class only support question mark placeholders. That means it probably impossible to use expressions containing a question mark operator with SQL::Abst

Re: [Dbix-class] custom join condition weirdness

On 12/01/2014 07:31 PM, Peter Mottram wrote: I'm working on a custom join condition for use in https://metacpan.org/pod/Interchange6::Schema full reasons for which are hard to explain - maybe we'll get to that in a later email if explanation is needed. I've added a new relationship to my Product

Re: [Dbix-class] Escaping placeholders

On Sat, Dec 20, 2014 at 05:35:55PM +0100, Alexander Foken wrote: > On 20.12.2014 15:38, Tim Bunce wrote: > >Can you, or anyone else, think of any situation where a backslash before > >a ? or :foo (or even $1) style placeholder might be valid SQL? > > I found two situations for PostgreSQL: > > (1)

Re: [Dbix-class] Escaping placeholders

On Sat, Dec 20, 2014 at 01:14:29PM -0800, Jonathan Leffler wrote: >Many, many years ago, DBD::Informix had to give up on the DBI-provided > parsing for placeholders because >there were too many contexts in which it was wrong for Informix. It may > have improved since then, but: > >