Neil Lunn wrote:
I am trying to set up a complex query to generate at runtime and
return through a resultset. My approach to this would normally be
looking at building the SQL statement and sending it off of execution.
The question here, is there a way to build arbitary SQL at runtime and
I am trying to set up a complex query to generate at runtime and return
through a resultset. My approach to this would normally be looking at
building the SQL statement and sending it off of execution.
The question here, is there a way to build arbitary SQL at runtime and
pass that statemen
Jose,
Thank you that was exactly what I needed.
I think one of the problems with DBIx::Class is that the documentation
and work is scattered among so many places it is hard to leap in and put
it all together.
Steve Kirkup
Jose Fonseca wrote:
Steve, I don't know what Gmail did to my reply,
Steve, I don't know what Gmail did to my reply, everything above "Show
quoted text" was deleted. Sorry about that.
Original reply was:
Steve, SQL::Abstract does quote columns and tables for you. It's just that
quote_char is empty by default. To change it from DBIx::Class you probably
need to have
Hope that helps!
Cheers, Ze
On Feb 13, 2008 5:58 PM, Steve Kirkup <[EMAIL PROTECTED]> wrote:
> Howdy,
>
>
> I have a rather unique problem and I am unsure of how to fix this. I
> am connecting to Oracle, one of the tables I HAVE to work with is using
> a keyword as the column name (I didn't do
Howdy,
I have a rather unique problem and I am unsure of how to fix this. I
am connecting to Oracle, one of the tables I HAVE to work with is using
a keyword as the column name (I didn't do it!).
The way to get select statements to work is by single-quoting the
column call. Example:
S
On Feb 13, 2008 5:51 PM, Guillermo Roditi <[EMAIL PROTECTED]> wrote:
> > I attach a patch (against
> > http://dev.catalyst.perl.org/repos/bast/DBIx-Class/0.08/trunk) that
> > does more or less that - when you specify the unique key it ignores
> > all columns from the query that don't belong to it (
Hi, this is my first message here, so first of all let me thank you all for
creating DBIx::Class and for the support you all give here. I've been
lurking for a while on the web transcriptions and learn tons from it. (And
excuse me for the large message!).
SYNOPSIS
The SELECT COUNT(*) queries which
> I attach a patch (against
> http://dev.catalyst.perl.org/repos/bast/DBIx-Class/0.08/trunk) that
> does more or less that - when you specify the unique key it ignores
> all columns from the query that don't belong to it (
I find this to be desired behavior Zbigniew Lukasiak++
___
On Feb 2, 2008 7:31 AM, Matt S Trout <[EMAIL PROTECTED]> wrote:
> On Fri, Feb 01, 2008 at 05:11:19PM -0500, Daniel Westermann-Clark wrote:
> > On 2008-02-01 10:23:33 +0100, Zbigniew Lukasiak wrote:
> > > Yes - just ignore any column that is not part of the key in any case
> > > and then return the
Emmanuel Quevillon wrote:
Emmanuel Quevillon wrote:
Matt S Trout wrote:
On Mon, Feb 04, 2008 at 12:45:08PM +0100, Emmanuel Quevillon wrote:
Matt S Trout a écrit :
On Thu, Jan 31, 2008 at 04:01:27PM +0530, Rajesh Pethe wrote:
Matt S Trout wrote:
On Wed, Jan 30, 2008 at 09:31:27PM +0530, Raje
Emmanuel Quevillon wrote:
Matt S Trout wrote:
On Mon, Feb 04, 2008 at 12:45:08PM +0100, Emmanuel Quevillon wrote:
Matt S Trout a écrit :
On Thu, Jan 31, 2008 at 04:01:27PM +0530, Rajesh Pethe wrote:
Matt S Trout wrote:
On Wed, Jan 30, 2008 at 09:31:27PM +0530, Rajesh Pethe wrote:
I have al
On 13 Feb 2008, at 10:39, Matt S Trout wrote:
On Tue, Feb 12, 2008 at 03:36:58PM +0900, Matt Rosin wrote:
I am not a PG expert unfortunately. But as a user would like to note
8.3 has many new cool things, including a new XML data type (old xml2
method will be deprecated). Much developer candy
On Tue, Feb 12, 2008 at 03:36:58PM +0900, Matt Rosin wrote:
> I am not a PG expert unfortunately. But as a user would like to note
> 8.3 has many new cool things, including a new XML data type (old xml2
> method will be deprecated). Much developer candy in there it would
> seem.
You don't need to
14 matches
Mail list logo
