Can we see your model? Are you sure the "timestamp" field is a datetime 
field and not a string field? When I try prettydate with a datetime field, 
it works fine?

Anthony

On Thursday, August 16, 2012 3:26:24 PM UTC-4, Pystar wrote:
>
> To Max,
> Like Anthony said, why is a datetime object I retrieved from my database 
> in a controller automatically converted to a string object? and how come 
> prettydate() cant convert datetime objects that are strings too? Is  this a 
> feature of a bug? I also discovered that if i do this in my view 
> {{=prettydate(request.now)}}, it gives me a "now" result i.e. prettydate 
> works, but doesnt work on retrieved datetime objects from my DB. I need 
> help. thanks
>
> On Thursday, August 16, 2012 6:25:20 PM UTC+1, Anthony wrote:
>>
>> Does this break backward compatibility, or do you consider this a bug?
>>
>> Note, Pystar's problem is not that the function was failing silently, but 
>> that his item.now value was a string when he expected it to be a datetime 
>> object (i.e., now it will still fail, but not silently).
>>
>> Anthony
>>
>> On Thursday, August 16, 2012 1:07:57 PM UTC-4, Massimo Di Pierro wrote:
>>>
>>> you are right. I think this is now fixed on google code (not on github 
>>> because I am behind a firewall and cannot push to github right now).
>>>
>>> Massimo
>>>
>>> On Thursday, 16 August 2012 00:42:34 UTC-5, Anthony wrote:
>>>>
>>>> Massimo, note that prettydate() does fail silently due to a try/except 
>>>> (the except returns '') -- see 
>>>> https://groups.google.com/forum/#!msg/web2py/Rguuny9E3X8/-a976Tjx4EIJ%5B1-25%5D
>>>> .
>>>>
>>>> Anthony
>>>>
>>>> On Thursday, August 16, 2012 1:14:47 AM UTC-4, Massimo Di Pierro wrote:
>>>>>
>>>>> Try:
>>>>>
>>>>> {{=prettydate(item.timestamp)}} {{=item.timestamp}} to check there is 
>>>>> actually something to display.
>>>>>
>>>>> functions cannot fail silently in view. If they are executed and fail, 
>>>>> they raise an exception.
>>>>>
>>>>> On Wednesday, 15 August 2012 22:24:08 UTC-5, Pystar wrote:
>>>>>>
>>>>>> still doesnt work
>>>>>>
>>>>>> On Wednesday, August 15, 2012 1:45:47 AM UTC+1, Pystar wrote:
>>>>>>>
>>>>>>> OK, After doing type(item.now). I discovered that web2py is escaping 
>>>>>>> my retrieved data from the database and converting everything into 
>>>>>>> strings. 
>>>>>>> And since prettydate() doesnt work on strings but datetime objects, it 
>>>>>>> fails. 
>>>>>>> For this prettydate to work in the views, I would have to
>>>>>>> import datetime and do
>>>>>>> datetime.datetime.strptime(item.now, [format]) in order to format 
>>>>>>> the datetime object that has now being converted into a string back to 
>>>>>>> a 
>>>>>>> datetime object and then allow prettydate() to work its magic. The only 
>>>>>>> problem I am having now is knowing the correct format to pass to the 
>>>>>>> strptime() function as all I have used is raising this error: 
>>>>>>> "2012-08-15 
>>>>>>> 01:38:15.019797' does not match format '%Y, %m, %d, %H, %M, %S, %f'"
>>>>>>> I need help thanks
>>>>>>>
>>>>>>> On Tuesday, August 14, 2012 11:57:45 PM UTC+1, Pystar wrote:
>>>>>>>>
>>>>>>>> It fails silently, it outputs nothing.
>>>>>>>>
>>>>>>>> On Tuesday, August 14, 2012 11:34:54 PM UTC+1, Anthony wrote:
>>>>>>>>>
>>>>>>>>> item.now is a field in my database whose default value is 
>>>>>>>>>> request.now.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Yes, I understand, but can you report the error raised as well as 
>>>>>>>>> checking the type of item.now?
>>>>>>>>>
>>>>>>>>> Anthony 
>>>>>>>>>
>>>>>>>>

-- 



Reply via email to