Matt S Trout wrote:
> Doran L. Barton wrote:
>> I specifically need to use the TO_CHAR() function which takes a field
>> name and a format string:
>>
>> SELECT foo, TO_CHAR('bar', 'Month DD YYYYY') FROM Artist
>
> { TO_CHAR => [ 'bar', 'Month DD YYYY' ] } ?
>
> Always try the obvious thing first (this assumes you have quoting turned on.
> if you don't, you probably want \"'Month DD YYYY'")
That's what I thought, but it wasn't working. I've updated to DBIx::Class
0.06 (was running an older version) and still having problems. Let me expose
more of the environment:
Fedora Core Linux 4 (i386) (Perl 5.8.6)
PostgreSQL 8.0.7 backend
DBD::Pg 1.47
Here is the error showing up in the logs now when I try using the above code
to include a TO_CHAR(arg1, arg2) in the code:
Cannot mix placeholder styles ":foo" and "?" at
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/DBD/Pg.pm line 188.
Any other suggestions?
--
[EMAIL PROTECTED] is Doran L. Barton, president, Iodynamics LLC
Iodynamics: Linux solutions - Web development - Business connectivity
"Please do not wash hair or clothes in toilet."
-- Seen in a Tokyo restroom
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
