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
