[web2py] list:reference get data

Hello everybody, I have this table with a list:reference to another table Movie = db.define_table('movies', Field('title','string', label = 'Title'), Field('date_release','integer', label = 'Date Release'), Field('duraction','integer', label = 'Duraction'), Field('category','string','list:ref

[web2py] List reference counting elements

Hello everybody, I have a table like this Movie = db.define_table('movies', Field('title','string', label = 'Title'), Field('date_release','integer', label = 'Date Release'), Field('duraction','integer', label = 'Duraction'), Field('category','string','list:reference categories', label = 'Cat

[web2py] jQuery Plugin Multi select

Hello everyone, I have my table like this, db.define_table('Document', Field('date','date'), Field('school','reference schoolNames'), Field('students','list:reference Students'), ) db.Document.students.requires = IS_IN_DB(db((db

[web2py] Re: Reportlab show image stored in database

It doesn't work with "uploads" Anyone know how to show a image which was stored in a database in a pdf file?? El miércoles, 10 de mayo de 2017, 21:32:38 (UTC-3), Winter Kryz escribió: > > Hello everyone, > > I'm doing a report using reportlab and I have a tabl

[web2py] Reportlab show image stored in database

Hello everyone, I'm doing a report using reportlab and I have a table like this db.define_table('document', Field('file_name','string'), Field('file','upload'), ) What I need to do is get the file from the database and display it on a PDF report.

[web2py] Field date error

Hello everybody, I have a table db.define_table('Person', Field('last_name', 'string'), Field('first_name', 'string'), Field('nationality','string'), Field('birth_date', 'date', requires = IS_NOT_EMPTY(error_message="select a date"))

[web2py] Re: Select filled with years

Thanks, but how can I do the loop thing. I'm new on web2py so I don't know how to do that. Can you explain me please? El domingo, 16 de abril de 2017, 21:09:55 (UTC-3), 黄祥 escribió: > > you can use requires = IS_IN_SET() validators for that : > ref: > > http://web2py.com/books/default/chapter/29

[web2py] Select filled with years

Hello everybody, I have a table like this db.define_table('Report', Field('person', 'reference Person'), Field('year', 'integer'), Field('letter', 'string'), ) and I use SQLFORM to create a form with that table form=SQLFORM(db.Repor

[web2py] Dropdown lists cascade in Crud form

Hello everybody, I have a table called Person Db.py db.define_table('Person', Field('last name', 'string',label='Last Name'), Field('First name', 'string',label='First Name'), Field('City','reference City',label='City', requires = IS_IN_DB(db,db.C

[web2py] Re: Delete confirmation popup

nd process them ( make search and > delete it ) . > > Em segunda-feira, 27 de março de 2017 20:49:59 UTC-3, Winter Kryz escreveu: >> >> Hello Everybody, >> >> I hope someone can help me, I have a table full of records from a data >> base, each row has a delet

[web2py] Delete confirmation popup

Hello Everybody, I hope someone can help me, I have a table full of records from a data base, each row has a delete button so what I want to do is to show a "Yes/No" Javascript popup to confirm the delete action. So far what I did is: *** controller *** def Person(): person = db(db.Person

[web2py] Delete confirmation

Hello everybody, I have a Datatable filled with registers from a database and for each row I have a 'delete' button, what I'm trying to do is display a modal (bootstrap) delete confirmation (yes/no) but I don't know how to pass the id of that particular register so I can delete from the databas

[web2py] Caret doesn't appear on dropdown menu

Hello everyone, I'm doing a project and when I use the auth-user dropdown menu, the cursor (class="caret") doesn't appear next to Log in. This is my code: {{='auth' in globals() and auth.navbar('Welcome',mode='dropdown') or ''}}

[web2py] Jquery UI Datepicker

Hello everybody, I'm trying to change the appearance of the default datepicker on a form and I want to choose a theme from Jquery UI

[web2py] display only year on a form

Hello, I have created a form where I need to insert the enrolling year of a student that is about to graduate on a particular career in a University. The 'year' field on the form displays an ajax calendar but it shows the complete date DD-MM- and I want it to display just the year without d

[web2py] Reportlab add image to pdf

Hello everyone, I am trying to generate reports using Reportlab in web2py. I'm working on pythonanywhere.com I am having some problems because I want to insert an image as header into the pdf report this is my report.py from reportlab.platypus import * from reportlab.lib.styles import getSampl

[web2py] Re: Reportlab add image to pdf

I tried the os.path.join but didn't work. Can someone help me with this, please? -- 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 messag

[web2py] Re: How to set default country in dropdown list

I created a module Countries.py with all the country names, imported into my model db.py and from applications.Egressum.modules. countries import * ... Field ('countries', requires = IS_IN_SET(COUNTRIES), default='United States'), then when I go to execute it, I get the following error (

[web2py] Re: How to set default country in dropdown list

I created a module Countries.py with all the country names, imported into my model db.py and Field ('countries', requires = IS_IN_SET(COUNTRIES), default='United States'), then when I go to execute it, I get the following error (1025, "Error on rename of './Kryz@0024db_egressum_we2py/#sq

[web2py] Re: How to set default country in dropdown list

I tried Field('nationality', requires=IS_IN_SET(nationalities), default='United States') but it gives me the following error name 'nationalities' is not defined I have to mention that I have already load all the nationalities names into a table called 'Nationalities' so what I need is only

[web2py] Re: How to set default country in dropdown list

Thanks for the answers I tried what xmarx said but it didn't work How would I use it with IS_IN_SET? -- 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

[web2py] How to set default country in dropdown list

Hello everybody, I am new in web2py, I have 2 tables called 'Nationalities' and 'Person' db.define_table('Nationalities', Field('description', 'string'), common_filter = lambda query:db.Nationalities.description != 'United States', format='%(descri