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 <[email protected]> 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 <[email protected]> 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 >>> >> >> -- > > > > --
