[web2py] Re: How can I return a report to the user in the view?

2019-04-29 Thread 'Francis Windram' via web2py-users
Brilliant, thank you! The pre tags worked exactly as required. -- 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 s

Re: [web2py] Web2py Windows edition with 3.x Interpreter

2019-04-29 Thread Nico Zanferrari
Hi rama, first of all, note that the shell.py fix will resolve only the 'cosmethic' problem of the help command (and "copyright", "credits" , "license" commands) that doesn't work in the interactive shell. But it will not change the import problem in any way. According to the manual, if you run

Re: [web2py] bye bye T, welcome pluralize

2019-04-29 Thread Carlos Cesar Caballero Díaz
It looks good!! I can work to support categories if you think it worth it. Allow something like T("string", "category") or T("string", cat="category"). A category would map to an specific folder of json internationalization files, if there is no category specified, it will map to a default cate

[web2py] 2.18.5 admin app search error

2019-04-29 Thread JSalvat
Hi all, I'm getting An error occurred, please reload the page when using the search feature in edit application. It used to work on previus releases! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.g

Re: [web2py] Re: custom search

2019-04-29 Thread villas
Hi Andfae It seems you are using additional inputs to submit searches to a SQLFORM.grid search widget... 1. Do not wrap the new inputs inside a form, as you are adding them to an existing search form. 2. Add something like this as the last line in your *datainizioSrch * function $("#w2p_keywo

[web2py] Re: MARKMIN - Sanitizing

2019-04-29 Thread villas
Hi Paul If you are worried about saving dodgy text in the DB, you could sanitize it first using XML() e.g. XML('dodgy();**Hello**',sanitize=True).xml() ***Hello*** On Thursday, 25 April 2019 12:19:44 UTC+1, Paul Ellis wrote: > > I am using an editable span with some js to s

[web2py] Re: Duplicates in SQLgrid

2019-04-29 Thread villas
Not sure if this personal experience helps but... I only use SQLFORM.grid when it is clearly a quick and simple solution. Otherwise, I use DataTables, which I think is great. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code

Re: [web2py] Re: MARKMIN - Sanitizing

2019-04-29 Thread Paul Ellis
Hey Villas, thanks. I actually thought that the XML sanitization would break the MARKMIN conversion but it doesn't. I probably should have tested that first. Regards On Mon, Apr 29, 2019 at 7:06 PM villas wrote: > Hi Paul > > If you are worried about saving dodgy text in the DB, you coul

[web2py] Grid search and clear buttons don't restore request.args. Where can I correct that?

2019-04-29 Thread jcrmatos
Grid search and clear buttons don't restore request.args. Where can I correct that? If using master-child pages, the master grid search works fine (because there are no request.args), but the child grid (which has request.args, from the master record) doesn't because the search and clear but

[web2py] Grid search collects all records from all fields on each request. Isn't this bad for performance?

2019-04-29 Thread jcrmatos
Grid search collects all records from all fields on each request. Isn't this bad for performance? Isn't it possible to change this behavior to only load the records when the user selects a specific field to do the search? -- Resources: - http://web2py.com - http://web2py.com/book (Documentatio

[web2py] Grid sorting sorts by id (in case of a FK) instead of shown value (eg. name). Is this normal?

2019-04-29 Thread jcrmatos
Grid sorting sorts by id (in case of a FK) instead of shown value (eg. name). Is this normal? The only way I found to correct this behavior was to change the grid's table to a query, where in this query I include all the foreign fields (eg. name) directly and remove al the foreign keys. Is this

[web2py] Re: Grid sorting sorts by id (in case of a FK) instead of shown value (eg. name). Is this normal?

2019-04-29 Thread Anthony
Yes. It shows the values from the foreign table via "recursive selects" (i.e., a separate query for each displayed row after the initial set of records is fetched from the database), so it is not able to use that information for sorting (which would require the initial query to be a join with t

[web2py] Re: Grid sorting sorts by id (in case of a FK) instead of shown value (eg. name). Is this normal?

2019-04-29 Thread jcrmatos
So the only way to correct it is the way I used. Thanks Anthony. segunda-feira, 29 de Abril de 2019 às 23:56:18 UTC+1, Anthony escreveu: > > Yes. It shows the values from the foreign table via "recursive selects" > (i.e., a separate query for each displayed row after the initial set of > records

[web2py] Re: Grid search collects all records from all fields on each request. Isn't this bad for performance?

2019-04-29 Thread Anthony
On Monday, April 29, 2019 at 6:22:26 PM UTC-4, jcrma...@gmail.com wrote: > > Grid search collects all records from all fields on each request. Isn't > this bad for performance? > Are you referring to "reference" fields, which result in a select element showing associated values from the foreign

[web2py] Re: Grid search and clear buttons don't restore request.args. Where can I correct that?

2019-04-29 Thread Anthony
What do you mean by master-child pages? Are you using smartgrid? Can you show some code? On Monday, April 29, 2019 at 6:15:30 PM UTC-4, jcrma...@gmail.com wrote: > > Grid search and clear buttons don't restore request.args. Where can I > correct that? > > > If using master-child pages, the maste

[web2py] Re: How to convert my view to pdf

2019-04-29 Thread Paul Ellis
This is really hard to answer because a PDF has a set page size and a HTML file (view) does not. Plus getting the css used in a HTML file to translate into css is also a challenge. Just print the page you are talking about with a pdf printer driver to see. You probably won't be happy with the

[web2py] pyDAL -> jsDAL?

2019-04-29 Thread Scott Hunter
The direction from web2py to web3py seems to be applications where the server is responsible for (relatively) static pages which use Javascript for their dynamic aspects & talking to the server via an API, primarily for interaction w/ the database. In the spirit of Progressive Web Apps, one co

Re: [web2py] Web2py Windows edition with 3.x Interpreter

2019-04-29 Thread rāma
Hi Nico, Thanks for your inputs. I've actually run windows py2.7 binary with modules within site-packages, and pip can be leveraged by setting your target folder like this: pip install -t site-packages . Just for the benefit of other readers. It's just that pandas didn't quite work for me in p

[web2py] Add recoCrud form into modal

2019-04-29 Thread Cristina Sig
Hello everyone, I have a button to add records. What I am trying to do is when I click on it I want to display a modal that contains a Crud form to create/add a new record. Something like this Example Any suggestions to do that?