[CDBI] strftime parameters and set_sql

Matt S Trout dbix-class at trout.me.uk
Wed Feb 15 14:10:03 GMT 2006

On Wed, Feb 15, 2006 at 01:35:31PM +0000, Aaron Trevena wrote:
> Hi all,
> I've got a couple of SQL Queries that I want to access through
> Ima::DB/CDBI's set_sql and they contain stuff like :
> STR_TO_DATE(CONCAT_WS(' ',DATE(NOW()),min_time.end_time), '%Y-%m-%d %H:%i:%s'),
> yes, the CONCAT_WS is probably redundant, but I'll worry about that later..
> So.. I can't see anywhere in the documentation or examples for either
> whether I can or whether I should (different things) pass these format
> strings - as they look like they could be confused for set_sql
> placeholders.

That's because transform_sql just uses sprintf, which works the same way
sprintf always does :)

Try s/%/%%/ and you should be fine.

     Matt S Trout       Offering custom development, consultancy and support
  Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

 + Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +

More information about the ClassDBI mailing list