Re: [web2py] Re: FOREIGN KEY constraint failed

2017-07-18 Thread Santiago Cartasegna
e its code word for 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 w

Re: [web2py] Re: FOREIGN KEY constraint failed

2017-07-05 Thread Santiago Cartasegna
dot-table files, but I've 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 >>

[web2py] Re: FOREIGN KEY constraint failed

2017-07-03 Thread Santiago Cartasegna
, > Field('formName', 'reference > govmntForm'),migrate=False,fake_migrate=True) > > > On Monday, July 3, 2017 at 4:51:47 PM UTC+2, Santiago Cartasegna wrote: >> >> Hello, >> >> You should reference the table with the same name that is create

[web2py] Re: FOREIGN KEY constraint failed

2017-07-03 Thread Santiago Cartasegna
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

[web2py] Strange Behavoir sql.factory()

2017-06-02 Thread Santiago Cartasegna
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!"

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

2017-05-17 Thread Santiago Cartasegna
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

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

2017-05-16 Thread Santiago Cartasegna
the 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] Make an inster/update in a second table after inserting/update

2017-05-16 Thread Santiago Cartasegna
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

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

2017-04-28 Thread Santiago Cartasegna
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

[web2py] Hide the achive links for a table.

2017-04-28 Thread Santiago Cartasegna
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?

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

2017-03-26 Thread Santiago Cartasegna
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 =

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

2017-03-20 Thread Santiago Cartasegna
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 before updat

[web2py] Re: problem with ldap authentication

2017-03-20 Thread Santiago Cartasegna
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

[web2py] Smartrgrid verify old value on record before update

2017-03-20 Thread Santiago Cartasegna
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',

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

2017-03-20 Thread Santiago Cartasegna
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? >