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
> > do
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
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 need
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 b
