Resolved!
This is the sql string needed to produce a selection for my reference field
in IS_IN_DB:
select vehicle.id,vehicle.manufacturer,vehicle.name,UPPER(vin) as vin from
vehicle inner join (select a.own_veh_fk from owner a where a.own_end_date
is not null and a.own_veh_fk not in (select b.
This is my short version of SQL string that I am trying to convert for use
with web2py. I am studding how to do it at this time but any help that
comes sooner will be appreciated. It finds a vehicle without owner that is
used when creating a vehicle owner.
select vehicle.id,vehicle.manufacturer,
Sorry, I should have written:
db.owner.own_veh_fk.requires=IS_IN_DB(db(query),'vehicle.id',
'%(manufacturer)s %(vin)s')
If you need to pass a set so you need to call db(query) in order to execute
the query.
2014-05-28 21:46 GMT-03:00 <98uj...@gmail.com>:
> I did try:
> query = query1 | guery
I did try:
query = query1 | guery2
and received error: "Set | Set" or similar
On Wednesday, May 28, 2014 7:47:36 PM UTC-4, 98u...@gmail.com wrote:
>
> Thank you Mr. Massimo and your colleagues for bringing the web2py to the
> masses.
> I need to have a field that will present a choice of values
4 matches
Mail list logo
