|
erics, May 11th, 2011 |
1 2 3 4 5 6 7 |
my $value = $dbh->fetch_one_value( 'table' => 'users', 'columns' => 'COUNT(*)', 'where' => { 'active' => 1, }, ); |
Categories: How-To's, Technology Column, Count, DBI, DBIx, DBIx::SQLEngine, mysql, SQL
| 
No comments
erics, April 24th, 2011 First, make sure MySQL server has the time zone tables loaded, which are NOT there by default!
|
1 2 |
# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql # service mysqld restart |
Next, tell MySQL to use the desired time zone via Perl:
|
1 2 |
my $dbh = DBIx::SQLEngine->new( ${dsn}, '{login}', '{passwd}' ); $dbh->do_sql("SET time_zone = 'America/New_York';"); |
MySQL TimeZone Support Info MySQL Date and Time Functions
Categories: How-To's, Technology DBI, DBIx::SQLEngine, Eastern, EDT, EST, GMT, mysql, perl, Timezone, TZ, UTC, zoneinfo
| No comments
erics, January 5th, 2010 Found that DBIx::Wrapper was BROKEN BADLY – now using DBIx::SQLEngine with great success… Just had our first successful test from the database through JSON to the javascript front-end. Very nice. Zooooooooom!
Categories: Technology CPAN, DBI, DBIx, JSON, mysql, perl, SQL
| No comments
