In db.order.depart_from==db.fare_table.from
both right and left hand sites are fields of the table. therefore including that in a query makes a join, but does not filer fields. This instead db.order.depart_from=='some value' compares a field to a value and therefore filters fields. Now you can rewrite it using a variable: value_from = 'some value' # defines the variable db.order.depart_from==value_from # the query On Monday, 11 November 2013 09:31:19 UTC-6, raferbop wrote: > > Thanks much Massimo, > > Could you explain this statement further; *where value_to and value_from > are not fields not the values of the source and destination. * > > On Sunday, November 10, 2013 5:28:03 PM UTC-5, Massimo Di Pierro wrote: >> >> fare = db((db.order.depart_from==db.fare_table.from) & >> (db.order.arrive_to==db.fare_table.to)).select(db.fare_table.fare) >> >> should be >> >> fare = db((db.order.depart_from==value_from) & >> (db.order.arrive_to==value_to)).select(db.fare_table.fare) >> >> where value_to and value_from are not fields not the values of the source >> and destination. >> >> >> On Sunday, 10 November 2013 15:55:34 UTC-6, raferbop wrote: >>> >>> Good days guys, >>> >>> I created an order form with the following fields (db.order); >>> >>> - Departure Location >>> - Arrival Location >>> - Date >>> >>> I wanted to display fares between each departure and arrival location, >>> so I created a fare table (db.fare_table); >>> >>> id depart_city arrival_city fare >>> 1 NYC Miami 800.00 >>> 2 Miami NYC 800.00 >>> >>> The goal was display fares when the user selected a departure and >>> arrival location (from a drop-down box), so I wrote the following query; >>> >>> fare = db((db.order.depart_from==db.fare_table.from) & >>> (db.order.arrive_to==db.fare_table.to)).select(db.fare_table.fare) >>> >>> But this query returns all the fares that have been submitted to the >>> order.db table. So I would like to know if it's possible to query the >>> database, prior to the data being submitted, and if yes, how do you go >>> about doing it? >>> >>> Regards, >>> Rafer >>> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
