def articles():
record=db.articles(request.args(0),main_tag=request.args(1))
return dict(title=record.title, body=record.body)
I would like to point out your question as an example of how to post a
proper question:
- concise
- shows the relevant part of the code, no more, no less
- clearly explains the problem
- explains who to do what you need using code.
On Nov 6, 3:09 pm, Eduardo <meketr...@gmail.com> wrote:
> Hi,
>
> I am having trouble using DAL the web2py way. I am trying to create a
> personal website so I can post articles. I have all my articles for
> different subjects stored in a single table with a field "main_tag",
> which tells the subject of the article. I will display them on the
> webpage in different pages, organized by subject.
>
> # ==============================================#
> db = DAL('sqlite://storage.sqlite')
>
> db.define_table('articles',
> Field('title', 'string'),
> Field('body', 'text'),
> Field('main_tag', 'string'),
> Field('sec_tag', 'string'))
>
> db.articles.title.requires = IS_NOT_IN_DB(db, db.articles.title)
> db.articles.body.requires = IS_NOT_EMPTY()
> db.articles.main_tag.requires = IS_NOT_EMPTY()
> # ==============================================#
>
> How do I write the command below the web2py way, instead of using
> executesql()?
>
> # Selects articles by subject ("main_tag" field)
> # request.args() used in the view files
> def articles():
> title = db.executesql('SELECT title FROM articles WHERE id=%s AND
> main_tag=%s' % (request.args(0), request.args(1)))
> body = db.executesql('SELECT body FROM articles WHERE id=%s AND
> main_tag=%s' % (request.args(0), request.args(1)))
> return dict(title=title, body=body)
>
> Thanks,
>
> Eduardo
