@ sandeep.
Thanks a lot for your solution and it is working for me. But I am facing a
small problem : When I choose a option from the drop down list and later
change my mind and try to select a different value , I cannot do that
because after the first selection, it is not showing other values.Any
insight on this ? Thanks.
On Tue, Dec 4, 2018 at 10:11 PM Ben Duncan <linux...@gmail.com> wrote:
> Here is a sample I did when I found some OLD web2py forums. I tested with
> a dictionary then
> with a "in" DB ..
> In controller/default.py:
>
> def company_login():
> # Read the company file into a dictionary
> company =
> db(db.company).select(db.company.company_number,db.company.company_name,orderby=db.company.company_name)
>
> # Create a form using the sets
> form = SQLFORM.factory(
> Field('username', requires=IS_NOT_EMPTY()),
> Field('password', 'password', requires=IS_NOT_EMPTY()),
> Field('Company',
> requires=IS_IN_DB(db,db.company.company_number,'%(company_name)s')))
> # Field('Company', requires=IS_IN_SET(company)))
>
> # Note: IS_IN_SET is fugly, anyone know a way to "format" it for display?
>
> if form.process().accepted:
> # redirect(URL('index'))
> response.flash = 'form accepted'
> elif form.errors:
> response.flash = T('form has errors')
>
> return dict(form=form)
>
> In views/default/company_login.html :
>
> {{extend 'layout.html'}}
> {{=form}}
>
>
> -------------------------------------------------
> Ok, my NEXT questions along this thread:
> I need to display the values returned from the sqlform, any ideas on this ?
>
> thanks ..
>
> *Ben Duncan*
> DBA / Chief Software Architect
> Mississippi State Supreme Court
> Electronic Filing Division
>
>
> On Tue, Dec 4, 2018 at 9:08 AM sandeep patel <patelsandeep...@gmail.com>
> wrote:
>
>> @Arindam: Try the following code instead
>>
>> def test():
>> form = FORM(LABEL("File(s):"), INPUT(_name='pic_upload',
>> _type='file', _multiple=''),
>> BR(), LABEL("Comments:"), INPUT(_name='comments'),
>> BR(), LABEL("Print Size:"), INPUT(_name='print_size'),
>> BR(), LABEL("copies:"), INPUT(_name='copies'))
>> form.append(XML('<br><input list="names" name="names"><datalist
>> id="names"><option value="Matte"><option value="Glossy"></datalist><br>'))
>> form.append(XML('<button type="submit">submit</button>'))
>>
>> return locals()
>>
>> Hope this works for you
>>
>> Thanks
>> SP
>>
>> On Tue, Dec 4, 2018 at 8:02 PM Lovedie JC <lbjc1...@gmail.com> wrote:
>>
>>> I have done something like that. Let me retrieve it in 3hrs
>>>
>>> On 4 Dec 2018 5:17 PM, "Ben Duncan" <linux...@gmail.com> wrote:
>>>
>>> I was working on trying to figure out the EXACT same thing !!!!!
>>>
>>> Thanks ..
>>>
>>> *Ben Duncan*
>>> DBA / Chief Software Architect
>>> Mississippi State Supreme Court
>>> Electronic Filing Division
>>>
>>>
>>> On Tue, Dec 4, 2018 at 6:40 AM Arindam Dasgupta <nyn.dasgu...@gmail.com>
>>> wrote:
>>>
>>>> Hi,
>>>> I need to display a drop down list in my form but have no idea how to
>>>> do it. I have the following arrangements :
>>>>
>>>> Model :
>>>>
>>>> db.define_table('orders',
>>>>
>>>> Field('comments' ,type='string'),
>>>> Field('print_size',requires=IS_IN_SET(['5x3.5', '6x4',
>>>> '6x4.5', '5x7', '5x7.5', '6x8', '6x9', '12x8', '12x10',
>>>> '12x12', '12x15', '12x18', '12x24', '12x30',
>>>> '12x36']),default='6x4'),
>>>>
>>>> Field('paper_type',requires=IS_IN_SET(['Matte','Glossy']),default='Matte'),
>>>> Field('copies',requires=IS_IN_SET(mylist),default=1),
>>>> Field('cart',type='boolean' ,default='False'),
>>>> Field('checkout',type='boolean' ,default='False'),
>>>> Field('pic_upload' ,'upload',autodelete=True),
>>>> Field('order_id' , type='integer',default= 0),
>>>> Field('price' , type='float' , default=1),
>>>> Field('unit_price' , type='float' , default=1),
>>>> Field('order_status' ,
>>>> requires=IS_IN_SET(['Delivered','Not Delivered']) , default='Not
>>>> Delivered'),
>>>>
>>>> auth.signature
>>>> )
>>>>
>>>> Controller :
>>>>
>>>> def multiple_upload():
>>>> import datetime
>>>>
>>>> form = FORM(LABEL("File(s):"), INPUT(_name='pic_upload',
>>>> _type='file', _multiple=''),
>>>> BR(), LABEL("Comments:"), INPUT(_name='comments'),
>>>> BR(), LABEL("Print Size:"), INPUT(_name='print_size'),
>>>> BR(), LABEL("Paper Type:"),INPUT(_name='paper_type'
>>>> ,requires=IS_IN_SET(['Matte','Glossy']) ),
>>>> BR(), LABEL("copies:"), INPUT(_name='copies'),
>>>> BR(),INPUT(_type='submit'))
>>>>
>>>> return dict(form=form)
>>>>
>>>>
>>>> View:
>>>>
>>>> {{extend 'layout.html'}}
>>>> <h1>This is the default/multiple_upload.html template</h1>
>>>> {{=form}}
>>>>
>>>> In the paper type field I need to display a drop down with values
>>>> ('Matte' , 'Glossy').
>>>> Can you please show me how to do that.I dont want to use SQL form or
>>>> SQLFORM.FACTORY .
>>>> Thanks in advance for your kind suggestions.
>>>>
>>>> Best Regards,
>>>> Arindam
>>>>
>>>> --
>>>> 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 web2py+unsubscr...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>> --
>>> 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 web2py+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>>
>>> --
>>> 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 web2py+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
>> 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 web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> 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 web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
