LOL! I just said that Massimo would point a better for doing that! thats it!
Totally forget my code!
Tks Massimo
(sometimes the easiest way passes far away from our eyes)
2010/11/6 mdipierro <mdipie...@cs.depaul.edu>
>
> 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
>
--
http://rochacbruno.com.br
