RE: TEMP column created via set_sql and MySQL DATE_FORMAT functionreturns 0 in Class::DBI but valid data from command-line

[prev] [thread] [next] [Date index for 2005/02/15]

=20

> -----Original Message-----
> From: Perrin Harkins [mailto:perrin@xxxx.xxx]=20
> Sent: Tuesday, February 15, 2005 3:20 PM
> To: Terrence Brannon
> Cc: cdbi-talk@xxxxxx.xxxxx.xxx
> Subject: RE: TEMP column created via set_sql and MySQL=20
> DATE_FORMAT functionreturns 0 in Class::DBI but valid data=20
> from command-line
>=20
> On Tue, 2005-02-15 at 15:05 -0800, Terrence Brannon wrote:
> > 1/ Something needs to be documented in the "DEFINING SQL STATEMENTS"
> > section of the docs about this. What part of Class::DBI is taking a=20
> > string bracked with q{} and evaluating symbols prefaced with a %?
>=20
> It is touched in the Ima::DBI Queries section.  The set_sql()=20
> method is inherited from Ima::DBI and is documented there. =20
> You're welcome to supply a patch for the docs that makes it=20
> more explicit though.

You are right on the money:

<quote src=3Dhttp://cpan.uwinnipeg.ca/htdocs/Ima-DBI/Ima/DBI.html>
To make up for the limitations of bind parameters, $statement can
contain sprintf() style formatting (ie. %s and such) to allow
dynamically generated SQL statements (so to get a real percent sign, use
'%%'). See sql_* below for more details.
</quote>