On Tuesday, November 18, 2014 12:09:43 PM UTC-8, Dave S wrote:
>
>
>
> On Tuesday, November 18, 2014 11:56:59 AM UTC-8, Dave S wrote:
>>
>> I actually used a Form!
>>
>> I have a very simple web site. Originally it had one page beyond the
>> (sample) index.html, which just did a query of my db based on the current
>> date.
>>
>> Now I have 2 more pages, one of which allows entries from
>> your-choice-of-month to be listed,
>>
>
> The DAL's datetime.month() function makes this easy, but when I was trying
> to preview the results in the sqlite3 console, I couldn't get anything
> using their strft("%m", ...), so I still have room to grow. ;-)
>
a growth spurt brings me to
select * from composer where strftime('%m', birthdate) == "04" ;
And because my csv file had some entries like 1987-1-23, I also needed
select * from composer where strftime('%m', birthdate) is null ;
Putting that date into the file as 1987-01-23 would have worked as
expected. Bulk loading needs clean data ;-)
/dps
> and one which allows listing based on matching a surname.
>> (Happy Birthday, Carl Maria von Weber!)
>>
>> My controller isn't very sophisticated ... I use a FORM to get the search
>> "term" from the user, and if it validates I do the query and return the
>> rows with the form;
>> return dict(form = form, rows=rows)
>> The page doesn't redirect, although I have regular A's to link the 3
>> pages together.
>>
>> Not much to crow about, but it certainly feels like progress!
>>
>> /dps
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
