On Tue, Oct 6, 2009 at 04:23, mengu <[email protected]> wrote: > > hi everyone, > > i am coding a blog system with web2py that will be licensed under gpl. > hopefully, it will be a nice one with tagging, categorising, syntax > highlighting, built-in accordion menu and many other things.
I'm creating a blog app to use in my blog. Actually it have only basic things, like authentication, posting in HTML, tagging, comments etc. I'll release it under GPLv2 and post it to bitbucket.org. I think we can work together instead of doing the same work 2 times. What do you think? > my first question is about routes. can you please let me know how to > set the routes.py in order to get the urls like the following: > http://domain/post/a-post-title > http://domain/category/categoryname or http://domain/category/category-name > http://domain/archives/year > http://domain/archives/year/month > http://domain/archives/year/month/day Have you read routes.py? There are some examples on using it. > my second question is about a database query. i have the following > query in order to retrieve all the posts and those posts' categories. > the code can be found at http://mengu.pastebin.com/m111e1a47 how can i > make the query more simple? > > also, wouldn''t it be nice to get an object with field names for > results that we get by db.executesql()? > > thanks. > > > -- Álvaro Justen Peta5 - Telecomunicações e Software Livre 21 3021-6001 / 9898-0141 http://www.peta5.com.br/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
