Score another goal for Massimo...
I had to tweak it a bit but this ended up working:
dbmileage.trips.origin.requires=IS_IN_DB(dbmileage,dbmileage.places.id,dbmileage.places.name)
dbmileage.trips.destination.requires=IS_IN_DB(dbmileage(dbmileage.places.id!
=request.vars.origin),dbmileage.places.id,dbmileage.places.name,
error_message=T('destination must be different form origin'))
Thanks again.
On Oct 27, 5:01 pm, mdipierro <[EMAIL PROTECTED]> wrote:
> Read below
>
> On Oct 27, 4:28 pm, "Mr.Freeze" <[EMAIL PROTECTED]> wrote:
>
> > Hello web2py folks. I am making a mileage tracker and ran into a
> > small problem. Here's part of my model:
>
> > dbmileage.define_table('places',
> > SQLField('name'),
> > SQLField('bbuser_id', dbmileage.bbuser))
> > dbmileage.define_table('distances',
> > SQLField('origin', dbmileage.places),
> > SQLField('destination', dbmileage.places),
> > SQLField('distance','double'))
> > dbmileage.define_table('trips',
> > SQLField('origin', dbmileage.places),
> > SQLField('destination', dbmileage.places),
> > SQLField('date', 'date', default=now),
> > SQLField('bbuser', dbmileage.bbuser))
>
> db.trips.origin.requires=IS_IN_DB(db,'places.id','%(name)')
> db.trips.destination.requires=IS_IN_DB(db(db.places.id!
> =request.vars.origin),'places.id','%(name)',
> error_message=T('destionation must be different form origin'))
>
> This (!=) will not work on GAE
>
>
>
>
>
> > The 'trips' table pulls both the 'origin' and 'destination' from the
> > 'places' table. What is the best way to ensure that a user selects
> > different 'places' on an SQLFORM (i.e. don't allow trips with the same
> > origin and destination)
>
> > Thanks!- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
