OPs..
you have to parse the executesql() return, replace with that
db.executesql('select CURRENT_DATE')[0][0].encode()
2010/8/27 Bruno Rocha <[email protected]>
> I dont know if I understand clearly what you want, but..
>
>
> May be :
>
> def get_sql_date():
> return db.executesql('select CURRENT_DATE')
>
> Field('grade_date','date',compute=get_sql_date,required=True,notnull=True)
>
> or
>
>
> Field('grade_date','date',default=request.now.date().strftime('%Y-%m-%d'),required=True,notnull=True)
>
>
>
>
> 2010/8/27 Adrian Klaver <[email protected]>
>
> I seem to be having problems getting my head around the default argument to
>> Field.
>>
>> I am using SQLite as the backend.
>>
>> If I do:
>> Field('grade_date','date',default=request.now,required=True,notnull=True)
>>
>> I get a database column with a DEFAULT of todays date, not what I want:
>> grade_date DATE NOT NULL DEFAULT '2010-08-27'
>>
>> If I do not include the default argument in the initial define_table but
>> add it
>> later todays date shows up in the form but there is no DEFAULT added to
>> the
>> column.
>>
>> What I would like to do is pass the SQLite date variable CURRENT_DATE to
>> the
>> table. At this point I am unclear as to whether default is associated with
>> the
>> table or the form.
>>
>> Thanks,
>> --
>> Adrian Klaver
>> [email protected]
>>
>
>
>
> --
>
> http://rochacbruno.com.br
>
--
http://rochacbruno.com.br
