Model:
db.define_table('numbers',
Field('no_1', 'integer',
requires=IS_INT_IN_RANGE(0,10000)),
Field('no_2', 'integer',
requires=IS_INT_IN_RANGE(0,10000)),
Field('no_3', 'integer',
requires=IS_INT_IN_RANGE(0,10000)),
Field('no_4', 'integer',
requires=IS_INT_IN_RANGE(0,10000)),
Field('date', 'date'))
Controller:
def search():
form=SQLFORM.factory(
Field('no_1','integer',label="No 1"),
Field('no_2','integer',label="No 2"),
Field('no_3','integer',label="No 3"),
Field('no_4','integer',label="No 4"))
if form.accepts(request.vars,keepvalues=True):
keys=(1,2,3,4)
s=[int(form.vars['no_%i'%i]) for i in keys if form.vars['no_
%i'%i]!=None]
query=reduce(lambda a,b:a|b,[db.numbers['no_%i'%i].belongs(s)
for i in keys])
items=db(query).select()
if not items: response.flash="There are no matching records in
Database."
else:
items=[]
return dict(form=form,items=items)
View: default/search.html
{{extend 'layout.html'}}
{{=form}}
{{=SQLTABLE(items,headers="fieldname:capitalize") if items else
"Nothing to see here."}}
This works for me.
On Sep 21, 9:21 am, elfuego1 <elfue...@gmail.com> wrote:
> Hello,
>
> Did you manage to find a cause of the problem?
> Why the db search is not working?
>
> Best wishes,
>
> On 19 Wrz, 18:26, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > My office email server appears to be done. Maintenance perhaps.
>
> > On Sep 19, 11:13 am, elfuego1 <elfue...@gmail.com> wrote:
>
> > > Ok. I've sent it again.
> > > Should be there right now.
>
> > > On 19 Wrz, 16:42, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > nope
>
> > > > On Sep 19, 4:52 am, elfuego1 <elfue...@gmail.com> wrote:
>
> > > > > Has my message reached your e-mail?
> > > > > The email topic: "Simple search form"
>
> > > > > On 17 Wrz, 23:37, elfuego1 <elfue...@gmail.com> wrote:
>
> > > > > > I did as you suggested.
> > > > > > The mail should be in your mail box.
>
> > > > > > On 17 Wrz, 15:55, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > > > > You need to help some bore with debugging. Looks to me there
> > > > > > > simply is
> > > > > > > no matching data.
> > > > > > > Try search by one single filed, Try print the values of form.vars.
>
> > > > > > > or send me the app and I will take a look.
>
> > > > > > > On Sep 17, 8:47 am, elfuego1 <elfue...@gmail.com> wrote:
>
> > > > > > > > OK. Both parts are there in the view.
> > > > > > > > The input fields are not evaluated against Database though.
> > > > > > > > Even if I enter numbers that are there in DB, form responses
> > > > > > > > with:
> > > > > > > > "There are no matching records in Database."
>
> > > > > > > > If the numbers are matching they should be displayed in the
> > > > > > > > result
> > > > > > > > part of the search page.
>
> > > > > > > > I tried something like this aslo:
>
> > > > > > > > items=db(db.numbers.no_1==form.vars.no_1|\
> > > > > > > > db.numbers.no_2==form.vars.no_2|\
> > > > > > > > db.numbers.no_3==form.vars.no_3|\
> > > > > > > > db.numbers.no_4==form.vars.no_4).select()
>
> > > > > > > > But it's not working either.
>
> > > > > > > > Can I count on some hint?
>
> > > > > > > > Best wishes.
>
> > > > > > > > On 16 Wrz, 23:19, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > > > > > > somewhere you still have in it
>
> > > > > > > > > {{=SQLTABLE(items,headers="fieldname:capitalize")}}
>
> > > > > > > > > which as we said only works {{if items:}}
>
> > > > > > > > > Please remove everything from the view.
> > > > > > > > > You should just have
>
> > > > > > > > > {{extend 'layout.html'}}
> > > > > > > > > {{=form}}
> > > > > > > > > {{=SQLTABLE(items,headers="fieldname:capitalize") if items
> > > > > > > > > else
> > > > > > > > > "nothing to see here"}}
>
> > > > > > > > > On Sep 16, 4:15 pm, elfuego1 <elfue...@gmail.com> wrote:
>
> > > > > > > > > > OK. Both parts are there in the view.
>
> > > > > > > > > > Now, when I go from index.html to search.html I get an
> > > > > > > > > > error:
>
> > > > > > > > > > Traceback (most recent call last):
> > > > > > > > > > File "gluon/restricted.py", line 188, in restricted
> > > > > > > > > > File "F:\Programy\web2py\applications\myapp/views\default/
> > > > > > > > > > search.html", line 88, in <module>
> > > > > > > > > > File "gluon/sqlhtml.py", line 1192, in __init__
> > > > > > > > > > AttributeError: 'list' object has no attribute 'colnames'
>
> > > > > > > > > > Line 88:
> > > > > > > > > > response.write(SQLTABLE(items,headers="fieldname:capitalize"))
>
> > > > > > > > > > On 16 Wrz, 22:02, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > > > > > > > > You have a form:
>
> > > > > > > > > > > def search():
> > > > > > > > > > > form=SQLFORM.factory(INPUT('no_1','integer'), <=
> > > > > > > > > > > line 57
> > > > > > > > > > > INPUT('no_2','integer'),
> > > > > > > > > > > INPUT('no_3','integer'),
> > > > > > > > > > > INPUT('no_4','integer'))
> > > > > > > > > > > if form.accepts(request.vars,keepvalues=True):
> > > > > > > > > > > items=db(db.numbers.no_1.contains(form.vars.no_1)|\
> > > > > > > > > > > db.numbers.no_2.contains(form.vars.no_2)|\
> > > > > > > > > > > db.numbers.no_3.contains(form.vars.no_3)|\
> > > > > > > > > > >
> > > > > > > > > > > db.numbers.no_4.contains(form.vars.no_4)).select()
> > > > > > > > > > > else: items=[]
> > > > > > > > > > > return dict(form=form,items=items)
>
> > > > > > > > > > > you need to but both
>
> > > > > > > > > > > {{=form}}
>
> > > > > > > > > > > and
>
> > > > > > > > > > > {{=SQLTABLE(items,headers="fieldname:capitalize") if
> > > > > > > > > > > items else
> > > > > > > > > > > "nothing to see here"}}
>
> > > > > > > > > > > in the view
>
> > > > > > > > > > > On Sep 16, 2:25 pm, elfuego1 <elfue...@gmail.com> wrote:
>
> > > > > > > > > > > > I did as you told me. Now I don't have search form on
> > > > > > > > > > > > my search page.
> > > > > > > > > > > > What do you mean by saying: >>it is only producing
> > > > > > > > > > > > "nothing to see
> > > > > > > > > > > > here"
> > > > > > > > > > > > because there is no data.<<
> > > > > > > > > > > > There is data in DB waiting to be searched, but how am
> > > > > > > > > > > > I supposed to
> > > > > > > > > > > > do that now when there is no input fields on search
> > > > > > > > > > > > page?!
> > > > > > > > > > > > How do I get input fields and results for my search
> > > > > > > > > > > > below?
>
> > > > > > > > > > > > This is some vicious circle...
>
> > > > > > > > > > > > On 16 Wrz, 02:47, mdipierro <mdipie...@cs.depaul.edu>
> > > > > > > > > > > > wrote:
>
> > > > > > > > > > > > > It is working just not being called. The output you
> > > > > > > > > > > > > see comes from
> > > > > > > > > > > > > this code you have
>
> > > > > > > > > > > > > {try:}}{{=H2(message)}}{{except:}}{{=BEAUTIFY(response._vars)}}
> > > > > > > > > > > > > {{pass}}
>
> > > > > > > > > > > > > and you should remove it.
>
> > > > > > > > > > > > > The code I suggested:
>
> > > > > > > > > > > > > {{=SQLTABLE(items,headers="fieldname:capitalize") if
> > > > > > > > > > > > > items else
> > > > > > > > > > > > > "nothing to see here"}}
>
> > > > > > > > > > > > > is working all right but it is only producing
> > > > > > > > > > > > > "nothing to see here"
> > > > > > > > > > > > > because there is no data.
>
> > > > > > > > > > > > > On Sep 15, 6:56 pm, elfuego1 <elfue...@gmail.com>
> > > > > > > > > > > > > wrote:
>
> > > > > > > > > > > > > > Source code for search.html looks like that:
>
> > > > > > > > > > > > > > {{extend 'layout.html'}}
> > > > > > > > > > > > > > {{try:}}{{=H2(message)}}{{except:}}{{=BEAUTIFY(response._vars)}}
> > > > > > > > > > > > > > {{pass}}
> > > > > > > > > > > > > > {{=SQLTABLE(items,headers="fieldname:capitalize")
> > > > > > > > > > > > > > if items else
> > > > > > > > > > > > > > "nothing to see here"}}
>
> > > > > > > > > > > > > > The output page looks like that:
>
> > > > > > > > > > > > > > form :
> > > > > > > > > > > > > > No 1:
> > > > > > > > > > > > > > No 2:
> > > > > > > > > > > > > > No 3:
> > > > > > > > > > > > > > No 4:
>
> > > > > > > > > > > > > > items :
> > > > > > > > > > > > > > numbers.id numbers.no_1 numbers.no_2 numbers.no_3
> > > > > > > > > > > > > > numbers.no_4
> > > > > > > > > > > > > > nothing to see here
>
> > > > > > > > > > > > > > As you can see aliasing is not working at the
> > > > > > > > > > > > > > moment.
> > > > > > > > > > > > > > Moreover when I put numbers into fields (numbers
> > > > > > > > > > > > > > that are in database)
> > > > > > > > > > > > > > - nothing happens.
> > > > > > > > > > > > > > Values are not checked against DB.
> > > > > > > > > > > > > > I only get flash message: "There are no matching
> > > > > > > > > > > > > > records in Database",
> > > > > > > > > > > > > > although I know that these numbers are in DB...
>
> > > > > > > > > > > > > > Something is missing but I can't figure out what it
> > > > > > > > > > > > > > is.
>
> > > > > > > > > > > > > > On 16 Wrz, 01:09, mdipierro
> > > > > > > > > > > > > > <mdipie...@cs.depaul.edu> wrote:
>
> > > > > > > > > > > > > > > It is failing when items=[]
> > > > > > > > > > > > > > > replace
>
> > > > > > > > > > > > > > > {{=SQLTABLE(items,headers="fieldname:capitalize")}}
>
> > > > > > > > > > > > > > > with
>
> > > > > > > > > > > > > > > {{=SQLTABLE(items,headers="fieldname:capitalize")
> > > > > > > > > > > > > > > if items else
> > > > > > > > > > > > > > > "nothing to see here"}}
>
> > > > > > > > > > > > > > > On Sep 15, 5:12 pm, elfuego1 <elfue...@gmail.com>
> > > > > > > > > > > > > > > wrote:
>
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > items=db(db.numbers.no_1.contains(form.vars.no_1)|\
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > db.numbers.no_2.contains(form.vars.no_2)|\
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > db.numbers.no_3.contains(form.vars.no_3)|\
> > > > > > > > > > > > > > > >
> > > > > > > > > > > > > > > > db.numbers.no_4.contains(form.vars.no_4)).select()
> > > > > > > > > > > > > > > > if not items: response.flash="There are
> > > > > > > > > > > > > > > > no matching records in
> > > > > > > > > > > > > > > > Database."
> > > > > > > > > > > > > > > > else: items=[]
> > > > > > > > > > > > > > > > return dict(form=form,items=items)
>
> > > > > > > > > > > > > > > > On 15 Wrz, 23:08, mdipierro
> > > > > > > > > > > > > > > > <mdipie...@cs.depaul.edu> wrote:
>
> > > > > > > > > > > > > > > > > You get an error in
>
> > > > > > > > > > > > > > > > > response.write(SQLTABLE(items,headers="fieldname:capitalize"))
>
> > > > > > > > > > > > > > > > > that seems to indicate items is not the
> > > > > > > > > > > > > > > > > result of a select but a list.
> > > > > > > > > > > > > > > > > What is items?
>
> > > > > > > > > > > > > > > > > On Sep 15, 3:57 pm, elfuego1
> > > > > > > > > > > > > > > > > <elfue...@gmail.com> wrote:
>
> > > > > > > > > > > > > > > > > > That doesn't work as planned.
>
> > > > > > > > > > > > > > > > > > First scenario.
> > > > > > > > > > > > > > > > > > I added the code you provided above and got
> > > > > > > > > > > > > > > > > > error:
>
> > > > > > > > > > > > > > > > > > Error traceback
>
> > > > > > > > > > > > > > > > > > Traceback (most recent call last):
> > > > > > > > > > > > > > > > > > File "gluon/restricted.py", line 188, in
> > > > > > > > > > > > > > > > > > restricted
> > > > > > > > > > > > > > > > > > File
> > > > > > > > > > > > > > > > > > "F:\Programy\web2py\applications\myapp/views\default/
> > > > > > > > > > > > > > > > > > search.html", line 92, in <module>
> > > > > > > > > > > > > > > > > > File "gluon/sqlhtml.py", line 1192, in
> > > > > > > > > > > > > > > > > > __init__
> > > > > > > > > > > > > > > > > > AttributeError: 'list' object has no
> > > > > > > > > > > > > > > > > > attribute 'colnames'
>
> > > > > > > > > > > > > > > > > > Line 92:
>
> ...
>
> read more »
