Dear Joe ,
I tried this :
values = []
values.append(request.args(0))
values.append('Both')
sup = db((db.Supplements.Category ==
(request.args(1)).replace('_',' ')) &
(db.Supplements.Users.contains(values))).select(db.Supplements.ALL)
And it didnt do anything !!! i dont understand what is happening !!
Regards,
On Wed, Nov 7, 2012 at 1:37 PM, Joe Barnhart <joe.barnh...@gmail.com> wrote:
> There is a Field function called "contains()" which would be useful here.
> It is described in the online book here:
>
>
> http://www.web2py.com/books/default/chapter/29/06#like,-regexp,-startswith,-contains,-upper,-lower
>
> Your query would be something like:
>
> db.table.Field2.contains( [ 'value1', 'value2' ] )
>
> Notice that "contains" is a function and is on Field2 (where it gets its
> "self" argument). The argument to contains is a list object -- note the
> square brackets! The list gathers up your values into a single object
> which is then passed into "contains". There is an optional keyword
> argument "all" which can be set to True which forces it to match all of the
> list instead of any of the list.
>
> -- Joe B.
>
>
> On Wednesday, November 7, 2012 3:01:58 AM UTC-8, Hassan Alnatour wrote:
>
>> and i even tried :
>>
>> items =[]
>> items.append(request.args(0))
>> items.append('Both')
>>
>> db( (db.table.Field1 == value) & (db.table.Field2 in items))
>>
>>
>> regards,
>>
>>
>> On Wed, Nov 7, 2012 at 12:56 PM, hasan alnator <haln...@gardeniatelco.com
>> > wrote:
>>
>>> Dear Joe ,
>>>
>>> What i want to do is to have a query like this :
>>>
>>> db( (db.table.Field1 == value) & (db.table.Field2 == value or value))
>>>
>>> i tried it i get no errors but its now working
>>>
>>> Regards
>>>
>>>
>>> On Wed, Nov 7, 2012 at 10:10 AM, Joe Barnhart <joe.ba...@gmail.com>wrote:
>>>
>>>> I see -- you're right.
>>>>
>>>> The request.args structure is a List() object which web2py defines to
>>>> retrieve values without the exception if it doesn't exist. It has some
>>>> additional interesting capabilities... You can define a default value,
>>>> such as this:
>>>>
>>>>
>>>> request.args(0,default='Both')
>>>>
>>>>
>>>> This will substitute the value 'Both' for request.args[0] should it be
>>>> set to None or be invalid. Or you could cast a string value to an integer
>>>> -- this often happens since the request.args are strings by default, but I
>>>> often pass row ids to be processed elsewhere:
>>>>
>>>>
>>>> URL('default','editrecord',arg**s=[22])
>>>>
>>>>
>>>> Becomes:
>>>>
>>>>
>>>> http://...../default/**editrecord/22
>>>>
>>>>
>>>> And request.args[0] is now '22' (the string). So we use the "cast"
>>>> keyword to change it to an int:
>>>>
>>>>
>>>> request.args(0,cast=int)
>>>>
>>>>
>>>> There is a ton of behavior in this little class! Thanks for pointing
>>>> it out to me.
>>>>
>>>> -- Joe Barnhart
>>>>
>>>>
>>>> class List(list):
>>>> """
>>>> Like a regular python list but a[i] if i is out of bounds return
>>>> None
>>>> instead of IndexOutOfBounds
>>>> """
>>>>
>>>> def __call__(self, i, default=None, cast=None, otherwise=None):
>>>> """
>>>> request.args(0,default=0,cast=**int,otherwise='http://error_**
>>>> url <http://error_url>')
>>>> request.args(0,default=0,cast=**int,otherwise=lambda:...)
>>>> """
>>>> n = len(self)
>>>> if 0 <= i < n or -n <= i < 0:
>>>> value = self[i]
>>>> else:
>>>> value = default
>>>> if cast:
>>>> try:
>>>> value = cast(value)
>>>> except (ValueError, TypeError):
>>>> from http import HTTP, redirect
>>>> if otherwise is None:
>>>> raise HTTP(404)
>>>> elif isinstance(otherwise, str):
>>>> redirect(otherwise)
>>>> elif callable(otherwise):
>>>> return otherwise()
>>>> else:
>>>> raise RuntimeError("invalid otherwise")
>>>> return value
>>>>
>>>>
>>>>
>>>>
>>>> On Tuesday, November 6, 2012 2:24:53 PM UTC-8, Niphlod wrote:
>>>>>
>>>>>
>>>>> One more point -- your "request.args(1)" should be "request.args[1]"
>>>>>> (with square brackets). The first form calls request.args as a function
>>>>>> and passes it the value "1". The second form treats request.args as a
>>>>>> Storage object and asks for the subscript "1".
>>>>>>
>>>>>> -- Joe Barnhart
>>>>>>
>>>>>> Nope, request.args(1) does basically
>>>>> try:
>>>>> result = request.args[1]
>>>>> except:
>>>>> result = None
>>>>> return result
>>>>>
>>>>> the () notation is safer because using request.args[1] if there is no
>>>>> request.args[1] you get an exception.
>>>>>
>>>> --
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>> --
>
>
>
>
--
