I've change all my db model :).
Thank you for the tip Anthony.
On Thursday, March 7, 2013 10:54:59 PM UTC+1, Anthony wrote:
>
> 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.
