[web2py] Re: How to encrypt password

(salt=salt)(new_password)[0] if stored_password == new_hash : form.errors.new_password = ('You can not repeat password') break Regards. El miércoles, 28 de julio de 2021 a las 16:36:08 UTC-3, isi_jca escribió: > > > Hello! > > I was

[web2py] Re: How to encrypt password

Hello! I was doing a test. rows_password = db(db.thist_password.usrid == auth.user_id).select(db.thist_password.password) for j in rows_password: #Get digest_alg salt, hash and original hash (digest_alg, salt, save_hash) = j.password.split('$') #Encrypt

[web2py] How to encrypt password

Hello! I have a historical table where I save n passwords by users so, I want to validate in the next change password that the user don't repeat the password. I need to encrypt the password and make a query in historical table. How can I do to encrypt the password in Web2py? Best regards. --

[web2py] Re: py4web has now a grid ...

e.html) --*/ [[extend 'layout.html']] Clientes [[=grid]] What is the problem? Thanks in advanced, regards. El domingo, 6 de octubre de 2019, 4:19:07 (UTC-3), Massimo Di Pierro escribió: > > I do not know. Try check the JS console for errors. Maybe it is missing > the js

[web2py] Re: py4web grid syntax - needs testers

Hi! Anybody have idea why py4web doesn't translate the labels? Best regards El domingo, 22 de septiembre de 2019, 22:02:16 (UTC-3), isi_jca escribió: > > Hi!!! > > In models.py, I have this table > > db.define_table('tempresa', > Field('descripcion&

[web2py] Re: py4web grid syntax - needs testers

Hi!!! In models.py, I have this table db.define_table('tempresa', Field('descripcion','string',length=50,label = T('Enterprise')), Field('email','string',length=50, label = T('Email')), Field('phone','string',length=50, label = T('Phone')), Field('estado','reference trestado',label = T('State')),

[web2py] Re: py4web grid syntax - needs testers

Hi!!! 1°) When I try to use "A page with an update form example", the console show: ERROR:root:Traceback (most recent call last): File "/home/jalbornoz/py4web-env/lib64/python3.7/site-packages/py4web/core.py", line 461, in wrapper ret = func(*func_args, **func_kwargs) File "/home/jal

[web2py] Re: py4web has now a grid ...

Hi Massimo: When I try the example I only watch a page blank. Why? Best Regards El jueves, 12 de septiembre de 2019, 3:31:36 (UTC-3), Massimo Di Pierro escribió: > > ... it is incomplete. It is experimental. The API is subject to change. > But I could use some community feedback: > > from py4w

[web2py] Re: How can I update the record in one table with value entry of another table as soon as the value is entered?

Hi!!!, When you made a sale, only must to update the products sold. For example: db(db.product.amount.id = product_id ).update(amount=amount1) El jueves, 5 de septiembre de 2019, 15:04:57 (UTC-3), mostwanted escribió: > > Everything you are saying i understand but I cant put into code

[web2py] Re: Connect to Sybase ASE 15.7

Using Python native module in SDK ASE 16, the connection is sucessful import sybpydb conn = sybpydb.connect(servername='TEST',user='Myuser', password='Pa$$w0rd') cur = conn.cursor() cur.execute("select succod, sucdesc from mydb..tsucursal") while True: row = cur.fetchone() if (not

[web2py] Re: How to catch index error

In this place def sleep_chart(): response.files.append(URL('e_default','static/js/pygal-tooltips.min.js')) response.headers['Content-Type']='image/svg+xml' custom_style = Style( background='transparent', plot_background='transparent', foreground='#53E89B',

[web2py] How to show log event while form is submitted

Hi, I have a form, when I click on submit button it is start processing and saving data (events) in table tlogproceso: Controller def fprocess (): form = SQLFORM.factory (Field ('filename', 'upload', uploadfolder = os.path.join (request.folder, 'uploads'), label = 'DB file')) if f

[web2py] Re: ¿How to show in comment property string from a function?

t 1:52:54 PM UTC-8, isi_jca wrote: >> >> Hi! >> >> Is possible to get data (a string) in this mammer? >> >> >> tpaciente.idarticulo.comment= lambda row : myfunction(row.idarticulo) >> >> In the grid form from view, it is show " at &

[web2py] ¿How to show in comment property string from a function?

Hi! Is possible to get data (a string) in this mammer? tpaciente.idarticulo.comment= lambda row : myfunction(row.idarticulo) In the grid form from view, it is show " at 0x7f604fce2aa0>" Can anybody help me?. Thanks in advanced. -- Resources: - http://web2py.com - http://web2py.com/book (Do

[web2py] Re: Connect to Sybase ASE 15.7

Hi!!! I get this message when try to connect at sybase (ASE) Ticket ID 127.0.0.1.2018-11-02.16-39-39.0e1ecf1e-e9a8-4950-893f-e3c2b7a98b0b Failure to connect, tried 5 times: Traceback (most recent call last): File "c:\web2py\gluon\packages\dal\pydal\base.py", line 455, in __init__ self._adapt

Re: [web2py] Re: qrcode

16, 7:05:49 (UTC-5), isi_jca escribió: >> >> >> Hi!!!. >>> >>> >> When I try to print qrcode image to pdf using pyfpdf, I get the next >> error: >> >> FPDF error: Unsupported image type: >> pilimage object at 0x7f2e82f13a50> >&g

[web2py] Re: Set password to user programmatically

de octubre de 2018, 11:59:15 (UTC-3), isi_jca escribió: > > I was reading documentation in this link > https://web2py.readthedocs.io/en/latest/_modules/gluon/tools.html#Auth.get_or_create_user > > What is wrong?. > > > > > El miércoles, 17 de octubre de 2018, 9:0

[web2py] Re: Set password to user programmatically

I was reading documentation in this link https://web2py.readthedocs.io/en/latest/_modules/gluon/tools.html#Auth.get_or_create_user What is wrong?. El miércoles, 17 de octubre de 2018, 9:02:36 (UTC-4), isi_jca escribió: > > Dave: > > Thanks for your time, I was trying with this

[web2py] Re: Set password to user programmatically

-4), Dave S escribió: > > > > On Tuesday, October 16, 2018 at 2:00:03 PM UTC-7, isi_jca wrote: >> >> Hello everybody: >> >> Is possible to write this script: >> >> db(db.auth_user.email == ls_user).update(password = >> db.auth_user.password.validate(ls

[web2py] Set password to user programmatically

Hello everybody: Is possible to write this script: db(db.auth_user.email == ls_user).update(password = db.auth_user.password.validate(ls_password)) ? I want to set a new password for special user. I don't want to use a form. Regards, thanks in advanced. -- Resources: - http://web2py.com - h

[web2py] Webservice using JWT

Hi Everybody!! I am trying to use webservice and Jason Web Token I have this controller: webservice.py from gluon.tools import AuthJWT myjwt = AuthJWT(auth, secret_key='my_especial_key',algorithm='HS512',user_param="email") myjwt.verify_expiration = False def login_take_token(): retu

[web2py] How to hide parameter in link using url

Hi When redirecting using href=URL('abmpersona','ficha',args=(ls_verificador) from a controller I get this link https://www.dominio.com.ar/miapp/abmpersona/ficha/8630002323323238310 How can I hide this parameter (8630002323323238310)?. Is there another mechanism that I can u

[web2py] Re: Send args from a button in views

Matthew: Look at the example in the attached file Regards El jueves, 24 de mayo de 2018, 10:46:05 (UTC-3), Matthew J Watts escribió: > > Hi all > > How do i send args via a button from views. > > For example, i'd like to send variables to the 'my_collections URL' {{=A( > 'Finish',_href=U

[web2py] Re: it's possible to use Autocomplete widget in SQLFORM.grid ?

Sandeep: Look at this link: http://web2py.com/books/default/chapter/29/07/forms-and-validators?search=autocomplete#Autocomplete-widget Regards El lunes, 21 de mayo de 2018, 9:37:40 (UTC-3), Sandeep Patel escribió: > > Hello, > Can anyone, let me know how to work Autocomplete widget with SQLFROM

[web2py] Re: Creating a dropdown form for linked tables

Hi!!! Look at in this link http://www.web2pyslices.com/slice/show/1410/cascading-drop-down-lists -- 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 rec

[web2py] Re: not web2py related but this is free now

Thanks a lot and best regards -- 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] Re: grid edit

T.R.Rajkumar Try setting this value: *field_id* must be the field of the table to be used as ID, for example db.mytable.id. This is useful when the grid query is a join of several tables. Any action button on the grid(add record, view, edit, delete) will work over db.mytable. Regards. -- R

[web2py] Re: Autocomplete How to search in midle of string

Hi!!! Reading in http://web2py.readthedocs.io/en/latest/_modules/gluon/sqlhtml.html I discovered this parameter "at_beginning" when it is setting in false it is possible to search in middle of the string. Example: db.tpersona.idprovincia.widget = SQLFORM.widgets.autocomplete(request, db.trpr

[web2py] Autocomplete How to search in midle of string

Hi!!! 1°) I am using autocomplete widget in this manner db.tpersona.idprovincia.widget = SQLFORM.widgets.autocomplete(request, db.trprovincia.descripcion, id_field= db.trprovincia.id, limitby=(0,20), min_length=2 ) This works

[web2py] Re: Query auth_user over first and last names in one query

Jim: In the next expression query = db((db.auth_user == name) or (db.auth_user == lastname)).select() Replace "or" by "|" (pipe) query = db((db.auth_user == name) | (db.auth_user == lastname)).select() Regards. El miércoles, 8 de marzo de 2017, 1:00:04 (UTC-3), Jim S escribió: > > Hi > > I ha

Re: [web2py] Re: qrcode

> Hi!!!. > > When I try to print qrcode image to pdf using pyfpdf, I get the next error: FPDF error: Unsupported image type: pilimage object at 0x7f2e82f13a50> Versión web2py™ Version 2.14.5-stable+timestamp.2016.04.14.03.26.16 Python Python 2.7.6: /usr/bin/python (prefix: /usr) Anyone have

Re: [web2py] Re: Want to add Confirmation on link in sqlform.grid

Hi!!! In this manner, works the link: links = [lambda row: A('Club call',_onclick="if(confirm('Do you want to club this call?')) document.location='%s'; return false;" % URL("","Incident",args=[row.id]))] Regards. El lunes, 13 de mayo de 2013, 9:11:10 (UTC-3), Pawan Jha escribió: > > not

[web2py] Re: Want to add Confirmation on link in sqlform.grid

El lunes, 13 de mayo de 2013, 2:56:27 (UTC-3), Pawan Jha escribió: > > Hi all > > I am using this in SQLFORM.grid > > here is confirm message but on clicking this Message is coming but when i > am clicking on no the its refresh the pages > > so please tell me how will i prevent this > > lin

[web2py] Re: How can I keep the user input value in form after user submit the form?

Hi!!! http://web2py.com/books/default/chapter/29/07/forms-and-validators#keepvalues Sometime you want an insert form that, upon submission and after the insert, retains the preceding values to help the user insert a new record. This can be done: db=SQLDB('sqlite://db.db') db.define_table('use

[web2py] Re: reading values from request.vars

Hi!!! Try using ajax('{{=URL('insert_data')}}',['opt1','opt2','opt3','txtt1'],':eval'); Regards El viernes, 1 de julio de 2016, 17:06:06 (UTC-3), Dave S escribió: > > > > On Friday, July 1, 2016 at 10:47:22 AM UTC-7, ktesr...@gmail.com wrote: >> >> Anthony, >> >> can you share if you have an

[web2py] Re: How to use the administrator account to check error for apache + web2py framework?

Hi!!! 1°) Create an item menu like this: ('Ticket de Errores', URL()==URL('tickets', 'errors'), URL('tickets','errors')), 2°) Copy tickets.py in controller 3°) Extract tickets.7z in view Regards. El jueves, 30 de junio de 2016, 18:25:19 (UTC-3), Jing Lu escribió: > > Dear Web2py developers,

Re: [web2py] Re: Querying data using admin

d i have to scroll to the right a lot. > > 2016-06-09 14:55 GMT+01:00 isi_jca >: > >> Hello!!! >> >> Try using Parenthesis, for example: >> >> (db.tventa.id >= 3) & (db.tventa.id <= 7) >> >> >> Result Set >> tventa.

[web2py] Re: Querying data using admin

Hello!!! Try using Parenthesis, for example: (db.tventa.id >= 3) & (db.tventa.id <= 7) Result Set tventa.id tventa.fecha tventa.vendedor

[web2py] Re: Ajax load function div with incorrect data and duplicates elements of the page

Hi!!! I commented that you can solve the problem by doing the following: 1°) Modifying the function as follows def fgetlocalidad(): idprovincia = 0 result='' idprovincia = int(request.vars.idprovincia) localidad_rows = db(db.trlocalidad.idprovincia==idprovincia).select(orderby=d

[web2py] Re: how do I call stored procedure containing parameters?

Charles: You can use this expression: status = db.executesql("exec mystored @adt_time = ?, @ai_usrid= ?",placeholders = (ldt_time, auth.user_id)) In this case the stored procedure has two arguments. Greeting. El miércoles, 1 de junio de 2016, 8:05:53 (UTC-3), Charles tenorio escribió: > > h

[web2py] Re: Grid remove class date/datetime

Hello!!! In my particular case, I wrote this code in my view: jQuery('input#tmatrizlaboral_fecingreso').removeClass('date form-control'); Greetings. El jueves, 12 de mayo de 2016, 9:45:07 (UTC-3), isi_jca escribió: > > Hi!!! > > Is possible to remove cl

[web2py] Grid remove class date/datetime

Hi!!! Is possible to remove class date/datetime from form Grid?. Thanks in advance -- 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 mes

[web2py] Re: After user login, I need to verify validity password.

Leonel : That was only a value of example. El miércoles, 27 de abril de 2016, 8:05:58 (UTC-3), Leonel Câmara escribió: > > Why are you forcing your users to change passwords every 100 days? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/w

[web2py] Re: After user login, I need to verify validity password.

Massimo: Also I can make a trigger on auth_user table in the database when the password is changed and update lastchangepassword field. Althrougth I know is lost portability. Best regards. El martes, 26 de abril de 2016, 17:59:42 (UTC-3), isi_jca escribió: > > Massimo: > > Th

[web2py] Re: After user login, I need to verify validity password.

escribió: > > at the bottom of db.py you can put: > > if auth.user and request.function!='user' > and (request.now_lastchargepasswrod).days>100: > redirect(URL('user/change_password')) > > > On Tuesday, 26 April 2016 08:37:56 UTC-5, isi_jca wr

[web2py] After user login, I need to verify validity password.

Hi!!! After user login, I want to check validity password, I added extra fields (lastchangepassword and valitiypassword) at the auth_user table. Where must I trigger a function to check this fields and then force at the user to change password when password expire? Thanks in advanced. -- Res

[web2py] Re: Form created using helper - load image

default','download', args=item.foto1) Best regards. El viernes, 29 de enero de 2016, 20:39:28 (UTC-3), isi_jca escribió: > > Hi!!! > > I have a form created using Helper HTML, It is has manye field > > form = FORM(TABLE( > > TR(TD(LABEL("Foto 1:&quo

[web2py] Form created using helper - load image

Hi!!! I have a form created using Helper HTML, It is has manye field form = FORM(TABLE( TR(TD(LABEL("Foto 1:",_class="label_foto5"), INPUT(_class="upload",_id="foto5",_name="foto5", _type="file", _onchange="leerarchivobin('foto5','

[web2py] Re: class 'sqlite3.integrityerror' foreign key constraint failed

RUTMARYS: *¿Qué tipo de formulario estas usando para insertar los datos, en que base de datos estas trabajando?, el mensaje te esta indicando que estas tratando de insertar en la columna ente o * *nomodelo un valor inexistente en las tablas ente o modelo, revisa como esta definida la relación

[web2py] Re: Links to referencing records - 'str' object has no attribute 'ignore_common_filters'

Ok, Thanks a lot. On 17 ene, 11:00, Anthony wrote: > > I made a modifications in my script: > > def list_records(): > >     expresion = 'list_records' > >     table = request.args(0) > >     query = request.vars.query > >     pos = query.find(expresion) > > >     if pos >= 0: > >         pos = p

[web2py] Re: Links to referencing records - 'str' object has no attribute 'ignore_common_filters'

Hi!!! I made a modifications in my script: def list_records(): expresion = 'list_records' table = request.args(0) query = request.vars.query pos = query.find(expresion) if pos >= 0: pos = pos + len(expresion) query= query[pos:] q = db(query) rec

[web2py] Re: Links to referencing records - 'str' object has no attribute 'ignore_common_filters'

end 'layout.html'}} Display Form {{=form}} list_records.html {{extend 'layout.html'}} {{=records}} Sorry for my English. Thanks you very much for answers. On 13 ene, 17:39, Anthony wrote: > On Friday, January 13, 2012 12:52:26 PM UTC-5, isi_jca wrote: > > > Thanks for

[web2py] Re: Links to referencing records - 'str' object has no attribute 'ignore_common_filters'

y wrote: > Looks like somewhere you have a query 'dog.owner=5'. Instead, that should > be: > > dog.owner == 5 > > Note, no surrounding quotes, and use of == (to test equality) instead of = > (used for assignment). > > Anthony > > > > > >

[web2py] Links to referencing records - 'str' object has no attribute 'ignore_common_filters'

Hello!!! I am a beginner and get the next ticket. Anybody Can I Help me?. Thanks in advance. Ticket ID 127.0.0.1.2012-01-12.14-09-56.3407b807-6bc6-4428-a7f2-0173a5473524 'str' object has no attribute 'ignore_common_filters' Version web2py™ (1, 99, 4, datetime.datetime(2011, 12, 14, 14, 46,