Always good to help :)
On Thursday, September 20, 2012 5:46:01 PM UTC+1, Andrew Evans wrote:
>
> OMG You are a genius!
>
> That worked and worked beautifully
>
> thank you so much
>
> *cheers
>
> Andrew
>
> On Thu, Sep 20, 2012 at 9:43 AM, villas <vill...@gmail.com
> <javascript:>>wrote:
>
>> Not sure I read your question carefully enough, but maybe you need
>> something like:
>>
>> query = db.listing.region.contains(region)
>>
>> Anyhow, contains has a special usage for list fields.
>>
>>
>> On Thursday, September 20, 2012 5:07:46 PM UTC+1, Andrew Evans wrote:
>>
>>> I have since added format='%(title)s %(id)s' to the region table but the
>>> listing is not being selected
>>>
>>> Is it because it is a list?
>>>
>>> I have entered multiple region entries for a single listing any idea how
>>> to select that listing in each of those regions when using the region
>>> search method?
>>>
>>> *cheers
>>>
>>> and ty
>>>
>>>
>>>
>>> On Thu, Sep 20, 2012 at 7:53 AM, Andrew Evans <ade....@gmail.com> wrote:
>>>
>>>> Hello I have a field in my table defined like so
>>>>
>>>> Field('region', 'list:reference region'),
>>>>
>>>> The data entered is multiple regions in the form, Gibsons, Sechelt
>>>>
>>>> I am wondering since it is not an id how I can pass the name of the
>>>> town as an argument, so it only selects entries from that town
>>>>
>>>> this is the view from the search_methods/region page
>>>>
>>>> <ul data-role="listview" data-inset="true">
>>>> {{for region in region_query:}}
>>>> <li><a href="{{=URL('views', 'region', args=(region.id))}}"
>>>> target="_blank" data-transition="fade" title="{{=region.title}}"
>>>> >{{=region.title}}</a></li>
>>>> {{pass}}
>>>> </ul>
>>>>
>>>> I need to change the *a* tag I think here so I can pass the correct
>>>> argument
>>>>
>>>> here is the controller function for the views/region page (where the
>>>> above a tag points to) not sure what to change here any ideas are greatly
>>>> appreciated
>>>>
>>>> def region():
>>>> region = request.args(0)
>>>> query = db.listing.region == region
>>>> orderby = db.listing.title
>>>> pcache = (cache.ram, 15)
>>>> paginate = Pagination(db, query, orderby, display_count=10,
>>>> cache=pcache, r=request, res=response)
>>>> region_query = paginate.get_set(set_links=**True)
>>>> region_text = db(db.region.id == region).select()
>>>>
>>>> return dict(region_query = region_query, region_text=region_text)
>>>>
>>>> *cheers
>>>>
>>>> and ty
>>>>
>>>> Andrew
>>>>
>>>
>>> --
>>
>>
>>
>>
>
>
--
