[web2py] IS_IN_DB validation error

2015-10-01 Thread John Smidt
Im currently creating a website for a geology museum. Each exhibit in the museum contains different collections (or categories) of minerals, and each collection has a handful of individual minerals that are being shown at this museum. The part that I am currently working on is to allow an admin

[web2py] Filtering a set of items from a collection issues

2015-10-12 Thread John Smidt
Hi, I am trying to populate a drop down box so that a user may choose a "featured Image" from a collection of images. There are multiple collections, so I need to filter out the other images that are in the different collections. The code I have is shown below: db.geo_collection.f_featured_img.

[web2py] Re: Filtering a set of items from a collection issues

2015-10-13 Thread John Smidt
IS_IN_DB( > db(db.geo_item.f_collection_id == current_collection_id), > db.geo_item.id, ...) > > You'll have to set current_collection_id to the appropriate value. > > Anthony > > > > > On Monday, October 12, 2015 at 12:54:03 PM UTC-4, John Smidt wrote: >> >&g

[web2py] Re: Filtering a set of items from a collection issues

2015-10-14 Thread John Smidt
That worked! Thanks for the quick help! On Tuesday, October 13, 2015 at 9:52:47 PM UTC-6, Anthony wrote: > > > > On Tuesday, October 13, 2015 at 12:21:10 PM UTC-4, John Smidt wrote: >> >> Ok, I get how the IS_IN_SET needs a filtered set as the first argument >> b