Also, don't use SQLField -- it was deprecated in favor of Field several
years ago.
On Thursday, March 7, 2013 10:33:35 AM UTC-5, Niphlod wrote:
>
> you can do as you did with the hotels (i.e. passing a queryset already
> filtered instead of a table to the IS_IN_DB) or create a dict holding a few
> cities with as the key the id of the city and the value the name of it.
>
> On Thursday, March 7, 2013 3:52:24 PM UTC+1, José Manuel López Muñoz wrote:
>>
>> Hi,
>> I'm trying to populate a drop down menu of a form like this:
>> def createOffer():
>> hotelesUsuario=db(db.Hotel.managerID == auth.user_id)
>> db.Offer.hotel.requires=IS_IN_DB(hotelesUsuario,'Hotel.id','%(name)s')
>> form = SQLFORM(db.Offer)
>>
>> This is my Offer table:
>>
>> db.define_table('Offer',
>> SQLField('created_on', 'datetime', label="Día de creación de la
>> oferta", writable=False, default=request.now),
>> SQLField('valid_from_date', 'datetime', label="Oferta
>> desde el día", default = request.now),
>> SQLField('valid_to_date', 'datetime', label="Oferta hasta
>> el día", default = request.now),
>> SQLField('selected','boolean', default=False,
>> readable=False, writable=False),
>> SQLField('city',db.City, label="Ciudad"),
>> SQLField('hotel',db.Hotel),
>> SQLField('num_rooms', label="N√∫mero de habitaciones",
>> default="1"),
>> format="%(id)s")
>>
>> I want to populate the DropDown menu "city" with some cities (not all the
>> cities, like now) in my database
>> How can I do it?
>> form.var.city = ¿?¿?
>>
>> I have tried many things but is clear I don't know how to do it.
>>
>> Any help will be very appreciated :)
>>
>
--
---
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.
