I run some tests and I cannot reproduce the problem but I pointed you to the wrong function. This works for me and does what you asked:
db = DAL() db.define_table('a',Field('b')) db.a.insert(b="xxx") query = SQLFORM.build_query([db.a.b],'xxx') print db(query).select() Does it work for you? On Mar 6, 2015, at 6:40 PM, Ron Chatterjee <achatterjee...@gmail.com> wrote: > In my db.py I have "from gluon.tools import*". Thats the issue? > > On Mar 6, 2015 7:31 PM, "Massimo DiPierro" <massimo.dipie...@gmail.com> wrote: > Do you have any from …. import Field in your code? > > > On Mar 6, 2015, at 6:20 PM, Ron Chatterjee <achatterjee...@gmail.com> wrote: > >> I think the issue is with the line isinstance (field, Field). When I pass >> the field.it is a gluon.dal.objects.Field n u r comparing that with >> pydal.object.Field. I m not sure but its failing both if and else. So it >> goes to raise. Lol >> >> On Mar 6, 2015 6:59 PM, "Massimo DiPierro" <massimo.dipie...@gmail.com> >> wrote: >> What is wrong with smart_query? >> >> On Fri, Mar 6, 2015 at 5:56 PM, Ron Chatterjee <achatterjee...@gmail.com> >> wrote: >> Can u fix smart_query for me? Lol >> >> On Mar 6, 2015 6:53 PM, "Massimo DiPierro" <massimo.dipie...@gmail.com> >> wrote: >> there should be instructions in the file. You need to install whoosh >> >> On Mar 6, 2015, at 5:50 PM, Ron Chatterjee <achatterjee...@gmail.com> wrote: >> >>> Does anyone know how to install haystack? I see a python file with .py >>> extension. I need to install whoosk and sunburnt first? Thought may be give >>> haystack a try. >>> >>> >>> >>> On Friday, March 6, 2015 at 1:08:28 PM UTC-5, Massimo Di Pierro wrote: >>> It may need some love. Very few people have used this. It should work fine. >>> It works for me. >>> >>> On Friday, 6 March 2015 11:40:25 UTC-6, Ron Chatterjee wrote: >>> Omg, this is exactly what I was looking for. Sooo spooky >>> >>> On Mar 6, 2015 12:35 PM, "Massimo DiPierro" <massimo....@gmail.com> wrote: >>> https://github.com/mdipierro/web2py-haystack >>> >>> On Mar 6, 2015, at 11:29 AM, Ron Chatterjee <achatte...@gmail.com> wrote: >>> >>>> Is whoosh is supported in DAL. Any example? Or have a js that create >>>> SQLFORM.search like SQLFOrM.smartgrid? Searching is important >>>> >>> >> >> > -- 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.