Jeff Seger wrote:

> try:
>
> my $sth = $dbh->prepare( "set dateformat dmy" )|| die $dbh->errstr; 
> #to see if it's puking on prepare
>
> or
>
> $dbh->do( "set dateformat dmy" ) || die $dbh->errstr;

Interesting.
The above ... $dbh->do( "set dateformat dmy" ) || die $dbh->errstr; ...
actually does the trick, but it *doesn't* work if I do a 'prepare' and
'execute' with the same SQL.

Anyway, it's working. Thanks :)

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au

Reply via email to