[web2py] Virtual Fields. Strange behavior when saving db result sets Build in types

n(k) print k , ' ', v.category, ' ', v.is_presidential() Output: 81 D False 79 P True Does this mean that we can't save rows from DB on Build in types ? Thanks in advance, Santiago

[web2py] Testing accions that access the database.

advance Santiago

[web2py] DAL : fill with zeroes a specific field before insert / update

accion takes place? So, if the field is '5', they it would be completed with zeroes with a result of '5' before insert / update. Thanks in advance Regards, Santiago

[web2py] [Version 1.96.4] DAL timing issue.

| character varying(12) | | extended | Thanks in advance Santiago

[web2py] Re: [web2py:38444] Re: myISAM table creation

I'm newby with Web2py. Using current version 2.0.9. I cant find MySQLAdapter, MyISAMAdapter, InnoDBAdapter. Only gluon/dal.py with InnoDb hardcoded. Can you help me please? Thanks On Wednesday, January 6, 2010 1:55:40 PM UTC-3, Thadeus wrote: > > O > > MySQLAdapter > ->MyISAMAdapter > ->Inn

[web2py] Re: Virtual Fields. Strange behavior when saving db result sets Build in types

anyone? I found that someone else asked about the same issue 5 month ago but there are no comments about it. http://groups.google.com/group/web2py/browse_thread/thread/845e6cdef5de4e92/4ace7b81d9e239c3?lnk=gst&q=Virtual+fields&pli=1 Thanks Santiago On Sat, Aug 13, 2011 at 7:07 PM,

Re: [web2py] bootstrap html attributes with web2py helpers

/web2py.com/books/default/chapter/29/5#HTML-helpers): I think in your case you can use: TAG.BUTTON('Single toggle', _type='button', class='btn btn-primary', **{'_data-toggle': 'button'} ) or TAG.BUTTON('Single toggle', _type='button

[web2py] Re: 'Column table.id not found (SQLTABLE)'

Are you trying to use a table that you have defined in your database and not in web2py? If it is the case you must add an id field with autoincremental El domingo, 12 de marzo de 2017, 20:27:08 (UTC-3), LoveWeb2py escribió: > > Keep getting this error for all of my tables!! What is going on? > >

[web2py] Smartrgrid verify old value on record before update

Hello, I am trying to do some validation before updating a record. My idea is to verify that the new value of a field is bigger than the old one. However I am not getting how to do it: table definition: db.define_table('t_myTable', Field('f_year', type='integer', label=T('Año')

[web2py] Re: problem with ldap authentication

Have you tried to check conectivity between servers without Web2py in the middle? For example, try to do a ldapsearch to see if it works. El martes, 7 de marzo de 2017, 12:32:42 (UTC-3), Carlos Cesar Caballero escribió: > > Hi, I am trying to include ldap authentication to my app, and for t

[web2py] Re: Smartrgrid verify old value on record before update

I have made a workarround. if (request.args[1] == 'edit'): #obtenemos el id del campo a modificar idUpdate = request.args[3] El lunes, 20 de marzo de 2017, 10:40:23 (UTC-3), Santiago Cartasegna escribió: > > Hello, > > I am trying to do some validation be

[web2py] Re: Smartrgrid verify old value on record before update

I wasn't sure how to obtaien the value of the Row Id which was being modified! Thanks for your answer El lunes, 20 de marzo de 2017, 13:27:07 (UTC-3), Anthony escribió: > > > def is_bigger(form): >> idUpdate = request.args(3).first >> > > What is .first supposed to do? > > >> r = db(d

[web2py] Hide the achive links for a table.

Hello everyone, I am using a Smartgrid to display some data. I was wondering if there is any chanche of hidding the links that redirect to the archive records. Is there any easy way of doing this?

Re: [web2py] Hide the achive links for a table.

linked_tables=[] would do the trick. Thanks! -- 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

[web2py] Make an inster/update in a second table after inserting/update

Hello, I am having a struggle in doing the following workflow: I have One table wich I need to get the values after insert/Update (I know how to manage this case) to put in another table. In the case of the update, I can make a workaround besacuse I can catch the edit. But when I have a New Rec

[web2py] Re: Make an inster/update in a second table after inserting/update

id of the inserted > record. Also, take a look at > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#callbacks-on-record-insert--delete-and-update. > > Anthony > > On Tuesday, May 16, 2017 at 1:08:59 PM UTC-4, Santiago Cartasegna wrote: >> >>

[web2py] which is the correct way to add validations to SQLFORM.factory?

I am creating a form using SQLFORM.factory and I have diferent problems: 1 - I can't make "invisible" some values (that i Autofill later) 2- I can't add extraValidations to the Form (as I do when a create a sqlsmartgrid form). I use SQLFORM because I use the ID of the inserted row to make an in

[web2py] Strange Behavoir sql.factory()

Hello everyone I have modified an SQLFORM.Smartgrid so when i Edit a record I only can modify a part of the data. I need to make some validations, so I added a myValidation to the form (and it renders OK). However no validation is made on the form and a response.flash with the "Success!" appear

[web2py] Re: FOREIGN KEY constraint failed

Hello, You should reference the table with the same name that is created so the table sould be like: db.define_table('governmetFormPages', Field('formImage', 'upload'), Field('formTitle',requires=IS_NOT_EMPTY()), Field('formName', 'reference gover

[web2py] Re: FOREIGN KEY constraint failed

ble('governmetFormPages', > Field('formImage', 'upload'), > Field('formTitle',requires=IS_NOT_EMPTY()), > Field('formName', 'reference > govmntForm'),migrate=False,fake_migrate=

Re: [web2py] Re: FOREIGN KEY constraint failed

only > done node.js on heroku, so I'm just waving my hands.) > > /dps > > > >> On Tuesday, July 4, 2017 at 12:08:44 AM UTC+2, Santiago Cartasegna wrote: >>> >>> Go to the database folder backup and delete all the .tables. Perhaps a >>> change w

Re: [web2py] Re: FOREIGN KEY constraint failed

word, that > solved my problem. thanks for the input guys. Santiago Cartasegna was > right. > > On Sunday, July 2, 2017 at 10:37:22 AM UTC+2, mostwanted wrote: >> >> Hi guys, i need help, i'm pulling my hairs out over here, i have a >> website where when i'

Re: [web2py] DAL : fill with zeroes a specific field before insert / update

Thanks all, I going to use a custom validator then. Best Regards, Santiago On Mon, Jul 2, 2012 at 3:00 PM, vinicius...@gmail.com wrote: > Remember "requires" property is not used when you just insert(), update() > or update_record(). > > So, in Web2py you don't have

Re: [web2py] Re: [Version 1.96.4] DAL timing issue.

esult(self.voting_center.provisional) log_delete(r.as_dict()) r2 = r.delete_results() and r.delete_record() for ps in self.voting_center.polling_station.select(): r3 = r3 and db.polling_station(ps.id).delete_results() return r1 and r2 and r3 return lazy Thanks, Regards Santiago O

Re: [web2py] Re: [Version 1.96.4] DAL timing issue.

center)._select( db.voting_center.id, orderby='id')): reg = db.voting_center(id) The geometry field is used to saved the location of the voting_center (see postgis) and it is not a custom field. Thanks Regards, Santiago On Sat, Jul 7, 2012 at 11:03 PM, Massimo Di Pierro < massimo.dipie...@gma

Re: [web2py] Re: [Version 1.96.4] DAL timing issue.

= db.voting_center(id) > > Thats's N+1 select()s where N is the number of records. > > On Tuesday, 10 July 2012 07:21:37 UTC-5, Santiago wrote: >> >> Hello, >> >> Limiting the number of rows or removing the virtual field, it works. So, >> as far as I un

[web2py] Grid inside Form

Hello, My example app has two models. db.define_table('person', Field('name')) db.define_table('dog', Field('name'), Field('owner',db.person)) In controller/default.py I define this method: def manage_person(): form = SQLFORM.grid(db.person) return dict(form=form) This code render th

Re: [web2py] Re: grid export button

Maybe original_export_menu is None. You have to verify this before call .elements('a') if w2p_grid_tbl: original_export_menu = grid.element('div.w2p_export_menu') if original_export_menu : export_menu_links = original_export_menu.elements('a') But, if original_export_menu is None, this i