On Aug 7, 2007 4:12 PM, George Hartzell [EMAIL PROTECTED] wrote:
The following little fragment of sql does what I'd like it to do,
inserts the current timestamp into the created_date column.
create table mooses (
id integer primary key autoincrement,
name text,
John Siracusa writes:
On 8/14/07, George Hartzell [EMAIL PROTECTED] wrote:
The default value of now does work when used in the RDBO perl
module. The problem is that since I'm using RDBO::Loader, the only
way to get that value in there is to use it in the SQL, where it
doesn't do
John Siracusa writes:
On 8/7/07 5:12 PM, George Hartzell wrote:
If I change Rose::DB::SQLite::validate_datetime_keyword so that it'll
accept 'current_timestamp'
Yeah, I should do that...
then the value gets inserted literally into the table.
it probably also needs to be
On 8/14/07, George Hartzell [EMAIL PROTECTED] wrote:
The default value of now does work when used in the RDBO perl
module. The problem is that since I'm using RDBO::Loader, the only
way to get that value in there is to use it in the SQL, where it
doesn't do what is intended.
Remember that
On 8/7/07 5:12 PM, George Hartzell wrote:
If I change Rose::DB::SQLite::validate_datetime_keyword so that it'll
accept 'current_timestamp'
Yeah, I should do that...
then the value gets inserted literally into the table.
it probably also needs to be inlined (i.e., unquoted)
I'd like to be
The following little fragment of sql does what I'd like it to do,
inserts the current timestamp into the created_date column.
create table mooses (
id integer primary key autoincrement,
name text,
created_date datetime not null default current_timestamp
);
insert