[web2py] passing multiple values from view to controller

2018-11-04 Thread Tribo Eila
Hi, using the code below, i'm trying to pass multiple variable from view to controller... and simple print the two values or work some validation. perhaps i'm missing something... need help view:

[web2py] Re: customizing SQLFORM to insert many rows from one form

2018-04-03 Thread Tribo Eila
you can try this http://www.mdelrosso.com/sheepit/index.php?lng=en_GB On Monday, April 2, 2018 at 5:37:09 PM UTC+3, Mashareq M wrote: > > Hi, > > I am creating a web app for attending employees. > > This is the model: > > db.define_table( > 'employee', > Field('name'), > format = '%(

[web2py] Re: insert list of dictionary

2016-10-23 Thread Tribo Eila
Thank You Anthony. You give me another idea... On Thursday, October 20, 2016 at 6:17:50 PM UTC+3, Anthony wrote: > > On Wednesday, October 19, 2016 at 9:15:21 AM UTC-4, Tribo Eila wrote: >> >> Hi, >> >> supposed: >> db.define_table('color&#

[web2py] Re: insert list of dictionary

2016-10-23 Thread Tribo Eila
se this data to define *multiple* records, > something like this might do what you want: > > for i in xrange(3): > db.color.insert( blue=COLORED_THINGS['blue'][i], > yellow=COLORED_THINGS['yellow'][i], red=COLORED_THINGS['red'][i] ) > &

[web2py] insert list of dictionary

2016-10-19 Thread Tribo Eila
Hi, supposed: db.define_table('color', Field('blue'),Field('yellow'),Field('red')) COLORED_THINGS = { 'blue': ['sky', 'jeans', 'powerline insert mode'], 'yellow': ['sun', 'banana', 'phone book/monitor stand'], 'red': ['blood', 'tomato', 'test failure']} using db.c

[web2py] Re: SELECT without duplicates for a specific field

2016-06-15 Thread Tribo Eila
; or be used in an aggregate function LINE 1: SELECT "table"."id"... > > Someone have a solution ? > > Il giorno martedì 14 giugno 2016 09:59:54 UTC+2, Tribo Eila ha scritto: >> >> Try INNER JOINS. >> >> On Monday, June 13, 2016 at 6:31:33 PM UTC

[web2py] Re: SELECT without duplicates for a specific field

2016-06-14 Thread Tribo Eila
Try INNER JOINS. On Monday, June 13, 2016 at 6:31:33 PM UTC+3, Gael Princivalle wrote: > > New model: > db.define_table('categories): > Field('title', type='string')) > > db.define_table('products'): > Field('code', type='string'), > Field('category', reference 'categories')) > >

[web2py] orderby with foreign key

2016-06-11 Thread Tribo Eila
hi, using: for x in db(..).select(.. orderby=db.yyy.zzz): row.append(TD(x.zzz.key <--- ref. value how to sort the string value, instead the ref. value? i tried using join and it's effective. but i'm using nested for loops which my head getting to explode now. thanks for your

Re: [web2py] FPDF database image

2013-07-22 Thread Tribo Eila
the sample function, that uses that info to generate the pdf. > > Best regads > > Mariano Reingart > http://www.sistemasagiles.com.ar > http://reingart.blogspot.com > > > On Mon, Jul 15, 2013 at 2:03 AM, Tribo Eila > > > wrote: > > Hi,

Re: [web2py] FPDF database image

2013-07-22 Thread Tribo Eila
Di Pierro wrote: > > You need to > >pip install PIL > > or > >sudo apt-get install python-imaging > > or on mac > >brew brew install pil > > On Tuesday, 16 July 2013 00:52:15 UTC-5, Tribo Eila wrote: >> >> Mariano, >> >&

Re: [web2py] FPDF database image

2013-07-15 Thread Tribo Eila
s the upload field): > > fn = db.sponsor[user.sponsor_id].logo > source = os.path.join(request.folder, 'uploads', fn) > > See the sample function, that uses that info to generate the pdf. > > Best regads > > Mariano Reingart > http://www.sistemasagiles.com

[web2py] FPDF database image

2013-07-15 Thread Tribo Eila
Hi, Supposed the code below: db.define_table('person', Field('name'), Field('picture', 'upload')). I'm trying to figure out, how to implement the picture field from database(postgreSQL) to FPDF. Any ideas to share? Thank You. -- --- You received this messa

[web2py] FPDF database image

2013-07-15 Thread Tribo Eila
Hi, Supposed the code below: db.define_table('person', Field('name'), Field('picture', 'upload')). I'm trying to figured out, how to implement the picture to retrieve from database(postgreSQL) to FPDF. Any ideas to share? Thanks. Newbie -- --- You recei

[web2py] FPDF Report database image

2013-07-15 Thread Tribo Eila
Hi, Supposed the code below: db.define_table('person', Field('name), Field('picture', 'upload')) I'm trying to figure out, how to implement the picture field from database(postgreSQL) to FPDF. Any ideas to share? I'm very appreciated your help. Thank you very

[web2py] FPDF database image report

2013-07-15 Thread Tribo Eila
Hi, Supposed the code below: db.define_table('person', Field('name), Field('picture', 'upload')) I'm trying to figure out, how to implement the picture field from database(postgreSQL) to FPDF. Any ideas to share? I'm very appreciated your help. Thank you very

[web2py] Re: finding the difference in same field

2013-06-24 Thread Tribo Eila
Sunday, 23 June 2013 01:42:30 UTC-5, Tribo Eila wrote: >> >> Hi, >> >> Supposed a model: >> >> db.define_table('test', >> Field('t1', 'integer'), >> Field('t2', 'integer'), >> ) >&g

[web2py] finding the difference in same field

2013-06-23 Thread Tribo Eila
Hi, Supposed a model: db.define_table('test', Field('t1', 'integer'), Field('t2', 'integer'), ) How to find the difference in db.test.t1 (ex: db.test.t2(row2) = db.test.t1(row2) - db.test.t1(row1)) and store the result in db.test.t2. What approach should i used? Thanks. -- ---