[Radiant] Archives by Month??? PROBLEM FOUND, NOW WHAT?
John W. Long
ng at johnwlong.com
Fri Aug 11 00:06:10 CDT 2006
Andrew Barnett wrote:
> BUT, STRFTIME('%m' returns a character value, such as '06', whereas
> it's being compared to the integer 6. I tested in sqlite3 and no rows
> returned. Wow, 17 years of Oracle experience counts for something in
> this Web world.
>
> So, strftime needs to be wrapped with a string-to-integer conversion,
> yes?
That sounds fine to me. Can you or someone else get me a unit test that
reproduces the problem? Maybe even a patch that fixes it?
--
John Long
http://wiseheartdesign.com
More information about the Radiant
mailing list