Re: [web2py] VSCODE with linter + debugging in WEB2PY

2021-09-18 Thread Carlos Costa
Hi, I have a video teaching how to setup web2py launch and debug in vs code. It is in Portuguese, but you can activate english subtitles, and it is also to see what I do in the video. https://www.youtube.com/watch?v=4LSy5VuLqCQ Em sexta-feira, 17 de setembro de 2021 às 05:21:04 UTC-3,

Re: [web2py] Re: LOAD in py4web

2020-03-04 Thread Carlos Costa
unpolly.js and cannot find it. Have a link? >> >> >> On Wednesday, 26 February 2020 19:32:20 UTC-8, Carlos Costa wrote: >>> >>> LOAD is a very cool thing! And beginners just say WOW when they can >>> create ajax-like experience so easy. >>> Bu

[web2py] Re: LOAD in py4web

2020-02-26 Thread Carlos Costa
LOAD is a very cool thing! And beginners just say WOW when they can create ajax-like experience so easy. But, IMO, it lacks some important features for modern apps, like error handling and history handling. I have written some simple functions to help cover these things... Another way I found

Re: [web2py] Re: Web2py or py4web for a brand new project

2020-01-22 Thread Carlos Costa
web2py did for you, >>>> but that's half the fun, isn't it? For instance, I used the grid that >>>> web2py's SQLFORM.grid provides for lots of listing pages. py4web doesn't >>>> have one so I've written a helper that displays pages the way my app wants >&g

Re: [web2py] Re: Web2py or py4web for a brand new project

2020-01-22 Thread Carlos Costa
Hey Massimo, thanks for the great info. How about porting apps from web2py to py4web? What steps would you recommend? Em qua., 22 de jan. de 2020 às 08:21, AGRogers escreveu: > OK, thanks. Re reporting errors, I suspect most errors will be due to my > ignorance. But thanks for the

Re: [web2py] Re: Vue2pyj - alternative web IDE

2019-09-27 Thread Carlos Costa
Didnt work here. I did a fresh install from py4web source and clone vue3pyj. ERROR:root:Traceback (most recent call last): File "/home/carlos/projects/py4web/py4web/core.py", line 472, in wrapper ret = func(*func_args, **func_kwargs) File "/home/carlos/projects/py4web/py4web/core.py",

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

2019-09-13 Thread Carlos Costa
; > > > > > On Thursday, 12 September 2019 06:52:23 UTC-7, Carlos Costa wrote: >> >> It's done. >> But I have a question: where will we put component styling? >> I add an table.css file and linked in layout.html but I think it belongs >> to the component

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

2019-09-12 Thread Carlos Costa
, Carlos Costa escreveu: > I liked it. > Much more faster and responsive. > > I didn't get how use search properly. > > I have on suggestion for letting grid more mobile friendly. > Take a look at this snippet https://codepen.io/andornagy/pen/EVXpbR > It is pure CSS

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

2019-09-12 Thread Carlos Costa
I liked it. Much more faster and responsive. I didn't get how use search properly. I have on suggestion for letting grid more mobile friendly. Take a look at this snippet https://codepen.io/andornagy/pen/EVXpbR It is pure CSS. It transform columns into rows in a card style table. I have used it,

Re: [web2py] Descriptografar senha do usuario

2019-08-21 Thread Carlos Costa
Não é possível. Em qua, 21 de ago de 2019 às 11:30, Kimus escreveu: > Bom dia, estou com um leve probleminha, estou tentando atualizar um > usuario sem o SQLFORM ou o FORM to fazendo na mão msm, lgoo preciso > carregar os dados na tela para o usuario atualizar oq ele quiser dos seus > dados, só

Re: [web2py] Re: please help testing web3py

2019-07-09 Thread Carlos Costa
What is the state of the _scafold? I was not able to register as user. Need some help on it? Em ter, 9 de jul de 2019 às 13:05, Stephan escreveu: > Okay, with the updated pydal, the errors have disappeared. I succeeded > cloning a scaffolding app. However, when I try to register in my new app >

Re: [web2py] please help testing web3py

2019-07-09 Thread Carlos Costa
I was able to install, start and create app without problems on Ubuntu 19.4 Em ter, 9 de jul de 2019 às 09:43, Jim Steil escreveu: > Works for me now. I deleted myapps and retried. Didn't work, got a > database error (unfortunately, I didn't copy it). Then python3 -m pip > install --upgrade

Re: [web2py] route 53 or Dns record

2019-06-04 Thread Carlos Costa
creveu: > hai carlos costa , i have an idea for that , i have domain registered with > godaddy , go daddy subdomain forwarding is unlimited and its free too . you > can add like this > in subdomain section add subdomainname as *user1* , target url is > *your.pythonanywhere.com/welco

Re: [web2py] route 53 or Dns record

2019-06-02 Thread Carlos Costa
ote: > >> Thanks alot for reply . I will try this idea and let you know >> >> On Sun, 2 Jun 2019 at 7:09 PM, Carlos Costa >> wrote: >> >>> I was about to do this before I gave up on aws because of costs. >>> So I don't know exactly what have to be don

Re: [web2py] route 53 or Dns record

2019-06-02 Thread Carlos Costa
I was about to do this before I gave up on aws because of costs. So I don't know exactly what have to be done. But what I think you have to do is: -use aws api or cli to insert the record on route53 dns -add the respective entry on routes.py on web2py folder for this maybe you want to store a

Re: [web2py] Re: How can I generate hash for user password like web2py

2019-05-29 Thread Carlos Costa
If you can use web2py itself for this task, dot it like this: hash = CRYPT()('text to hash')[0] Em qua, 29 de mai de 2019 às 19:05, João Matos escreveu: > I use Python's hashlib module. It contains pbkdf2. > > segunda-feira, 27 de Maio de 2019 às 12:13:54 UTC+1, Константин Комков > escreveu: >>

Re: [web2py] Re: A little suggestion: Create a forum for web3py

2019-05-29 Thread Carlos Costa
I don't agree this is reinvent the wheel. Maybe Slack is reinventing the wheel. Reinvent the wheel, from the Cambridge dictionary: > to waste time trying to create something that someone else has already > created We are having a good experience with chat support on telegram group. There is

Re: [web2py] Re: web2py managing capacity ?

2019-05-24 Thread Carlos Costa
sociability? Em sex, 24 de mai de 2019 às 05:18, 黄祥 escreveu: > how to use it with postgresql ? >> > > pls set the uri connection first > *e.g. private/appconfig.ini* > uri = postgres://postgres:password@localhost/database_name > > *ref:* > >

Re: [web2py] Electron, NWjs or Netralinojs and web2py

2019-05-23 Thread Carlos Costa
I did it with python cef and was easy. Em qui, 23 de mai de 2019 às 11:08, rāma escreveu: > Hi, > > Is there anyone working on packaging web2py as an webview app? > > Is it easily deployable with these kits? > > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation)

Re: [web2py] Re: new DBAPI in pydal for both web2py and web3py

2019-05-18 Thread Carlos Costa
+1 restapi Em sáb, 18 de mai de 2019 às 06:58, Massimiliano escreveu: > +1 for restapi :-) > > On Saturday, May 18, 2019 at 7:30:47 AM UTC+2, Massimo Di Pierro wrote: >> >> How about restapi or friendlyql? >> >> I do not want to tie this to web3py or dal too much. there is no reason >> this

Re: [web2py] Re: new DBAPI in pydal for both web2py and web3py

2019-05-17 Thread Carlos Costa
I liked it, sounds Italian. Sometimes when you have a restriction it inspires creativity. For example, if we would have a rule to give only Italian (Massimo origin is the reason here) names to Web2py stuff (web2py itself included) we could come up with more natural and interesting names. Like

[web2py] Re: new DBAPI in pydal for both web2py and web3py

2019-05-15 Thread Carlos Costa
Aweome! I made a similar API for my apps, but is simpler. I like this one more as it is more complete. Mine is called Consult (because we call query as consulta in Portuguese) This is very useful to integrate ui components such as datatable, or anything. Maybe dal-api should be a good name. If

Re: [web2py] Re: Future of web2py

2019-05-13 Thread Carlos Costa
I don't think all PWA cases must work 100% offline. For 100% offline apps you just need a server to "install" your app, and so web2py would be handy, but no more after install in client. This is not case we should aim as web2py as focused on database driven apps. Sync database may be desirable in

Re: [web2py] Re: Future of web2py

2019-05-11 Thread Carlos Costa
Untill this moment, for me, it means that in a second run, the app can open instantly, mostly because of cached assets. It does not mean that it will always partially work offline. It depends on the need. I think most apps made with web2py (and maybe web3py will be in the same case) are dependent

Re: [web2py] Re: Future of web2py

2019-05-11 Thread Carlos Costa
Recently Google released official support to PWAs in Play Store. So, if a web2py or web3py scaffoles ships with PWA support, it will be easy to deploy it on web and Play Store We would be able make web and mobile apps easily. This technique is saving me hours and hours. Em sáb, 11 de mai de

Re: [web2py] Re: Future of web2py

2019-05-10 Thread Carlos Costa
I am developing this on web2py apps and I plan to contribute with it on web3py. Em sex, 10 de mai de 2019 às 03:35, Martin Weissenboeck escreveu: > Is it planned that web3py will support the development of PWAs? > Martin > > Am Fr., 10. Mai 2019 um 03:58 Uhr schrieb Massimo Di Pierro < >

Re: [web2py] Re: Future of web2py

2019-05-02 Thread Carlos Costa
Massimo, could you create some issues related to these things to be done? I will be easier if anyone wants to contribute. I want to contribute but don't know exactly how. Em qui, 2 de mai de 2019 às 09:16, rāma escreveu: > ONE month!? Sounds super exciting. > > On Thursday, 2 May 2019 15:16:21

Re: [web2py] bye bye T, welcome pluralize

2019-04-30 Thread Carlos Costa
Looks nice! What would be the best approach to translate phrases and longer texts? Em seg, 29 de abr de 2019 às 10:59, Carlos Cesar Caballero Díaz < carlos.caball...@cfg.jovenclub.cu> escreveu: > It looks good!! I can work to support categories if you think it worth it. > Allow something like

Re: [web2py] Enjoying web2py

2019-04-18 Thread Carlos Costa
 Em qui, 18 de abr de 2019 às 08:25, Kevin Keller escreveu: > Just wanted to say that im working on app on an old Acer one 32 bit 2gb > machine with web2py, midori as Browser and Vim as code editor and I'm > enjoying it a lot! > > Thanks for creating such a great batteries included framework.

[web2py] Re: web3py again....

2019-04-02 Thread Carlos Costa
Will it have default url routes? beyond that, my thought about ui widgets: I think it would be nice: 1 - to have an easy integration via a model rest api 2- be agnostice to client side frameworks 3 - come with a default client side framework (preferably vue) 4 - have a ui lib by default 5 - have

[web2py] Re: New International Telegram Support Group

2019-03-19 Thread Carlos Costa
we noticied this group has no administrator, so we are moving to a new one, here is the link https://t.me/joinchat/DYZrfBT-bIsVhwLZc1hG8Q Em terça-feira, 19 de março de 2019 12:14:17 UTC-3, Carlos Costa escreveu: > > We have had a good experience with the brazilian telegram group ded

[web2py] New International Telegram Support Group

2019-03-19 Thread Carlos Costa
We have had a good experience with the brazilian telegram group dedicated to to support web2py users. But the english speaking group is not used at. Here is the link to join it: https://t.me/web2py_en Also, here is the link to the Brazilian group (portuguese speaking and some portunhol

Re: [web2py] Can I do INSERT INTO statement with DAL syntax ?

2018-10-16 Thread Carlos Costa
I think it is not possible yet. If you don't care about performance, in this case you can do it by code. But if you care, use db.executesql... Em sex, 12 de out de 2018 às 12:44, icodk escreveu: > something like : > > INSERT INTO Customers (CustomerName, City, Country) > SELECT SupplierName,

Re: [web2py] Re: Web2Py + VueJS SPA (Webpack)

2017-12-06 Thread Carlos Costa
This bootstrap-vue.js transparently integrated with web2py backend woud be a dream. IMO this would be half the web3py. 2017-12-04 11:42 GMT-02:00 : > Hi Massimo, I thought you might be interested in this: > https://bootstrap-vue.js.org/ > > Quite a new project, MIT

[web2py] Re: web2py 2.15.1 is OUT

2017-07-17 Thread Carlos Costa
I have a problem with this version. This does not work anymore: db.define_table('tabela', Field('campo')) form = SQLFORM.factory(db.tabela.campo) I throws this: Traceback (most recent call last): File "C:\Users\carlos.costa\Downloads\web2py\gluon\restricted.py", line 219, in

[web2py] Re: web2py 2.15.1

2017-06-07 Thread Carlos Costa
+1 on date picker. It is totally outdated. Em segunda-feira, 5 de junho de 2017 05:39:11 UTC-3, Karoly Kantor escreveu: > > Dear Massimo, > > I saw your question in the developers group where I cannot post, therefore > i do it here. > > I am currently aware of the following issues to be fixed: >

Re: [web2py] Re: The Almighty Form

2017-04-26 Thread Carlos Costa
Great tip. I did something similar, but in views. I wrote a function to take a form and break it into a giver number of columns using bootstrap grid classes. The default stacked layout gets pretty boring with time. 2017-04-26 18:18 GMT-03:00 Alfonso Serra : > This is great

Re: [web2py] Permission denied: '/var/lib/web2py/applications/admin/private/hosts.deny'

2017-03-31 Thread Carlos Costa
hosts listed in this file are have access denied. If this is the problem, just remove the host from the file or remove the entire file. Also, all web2py files must belong to the specified user in the apache virtual user. 2017-03-30 7:02 GMT-03:00 Nicola Gramola : >

Re: [web2py] Javascript load order and templates

2017-03-31 Thread Carlos Costa
A proper way to do this is to put the page javascript in the page_js block It is the declared in the default layout.html. To use it just do this in your view {{block page_js}} ...put your js here... {{end page_js}} This way it will be inserted in the right place into the rendered page.

[web2py] Re: web2pyslices

2017-03-24 Thread Carlos Costa
About fiddle, I think we can easily do the view and controller part. But what about the other parts like models, modules, database, etc? Would it be really necessary or have a reliable solution? I think we could do only view, controller and model. For the model maybe we should have an interface

[web2py] Re: web2pyslices

2017-03-24 Thread Carlos Costa
What about this: http://www.web2pyref.com/ Who owns it? Could we migrate slices data to it? Em terça-feira, 21 de março de 2017 16:53:16 UTC-3, Massimo Di Pierro escreveu: > > web2pyslices is becoming hard to maintain. Right now the best solution is > to create a github repo and move all the

Re: [web2py] Re: web2pyslices

2017-03-22 Thread Carlos Costa
t; the slice has to be a working example a la fiddle (web2py-fiddle). I know > it difficult and involve a lot of security, sandboxing, etc, but it would > be interresting to have demo of slice, that make sure we have the exact > code to make it works... > > Richard > > On Wed

Re: [web2py] Re: web2pyslices

2017-03-22 Thread Carlos Costa
I'd like to help maintain it. And I vote for a web2py solution. Not using would let us in a "shoemaker's son always goes barefoot" situation. I think this is embarrassing. 2017-03-22 1:23 GMT-03:00 Kiran Subbaraman : > I agree that the managing web2pyslices as issues

Re: [web2py] Re: How do you use web2py app work with phonegap?

2016-03-21 Thread Carlos Costa
I am using cordova and bootstrap for rapid prototyping. Next I will change it to static pages interacting via json webservices. 2016-03-21 7:23 GMT-03:00 eric cuver : > ok thank you i'll check > > > Le dimanche 20 mars 2016 21:24:05 UTC+1, pbreit a écrit : >> >> Ionic

Re: [web2py] qrcode

2015-10-14 Thread Carlos Costa
http://www.web2pyslices.com/slice/show/1462/qr-code-builder-with-web2py 2015-10-13 18:04 GMT-03:00 Fabiano Almeida : > Hi all! > > How to dynamically generate qr code in web2py? > > grateful, > > Fabiano. > > -- > Resources: > - http://web2py.com > -

Re: [web2py] Re: PyCharm license for web2py dev - who wants?

2015-10-14 Thread Carlos Costa
+1 2015-10-14 19:41 GMT-03:00 Stuart Rolinson : > +1 > > Thanks, > Stuart > > On Sunday, October 11, 2015 at 12:21:16 PM UTC-7, Francisco Ribeiro wrote: >> >> Hello all, >> >> for those who know PyCharm is a great IDE from JetBrains that provides >> free licenses for Open

Re: [web2py] Re: My son made a new web2py logo

2015-06-04 Thread Carlos Costa
thing I could find that returned no hits from the trademarks database. On Monday, 1 June 2015 17:12:39 UTC-5, Carlos Costa wrote: A little off now but I waited for a moment to say that. IT IS ONLY AN OPINION. Maybe the only thing I do not like in Web2py is its name. I really love Web2py

Re: [web2py] Re: My son made a new web2py logo

2015-06-01 Thread Carlos Costa
A little off now but I waited for a moment to say that. IT IS ONLY AN OPINION. Maybe the only thing I do not like in Web2py is its name. I really love Web2py and use it and advocate it but this name is not a strength. Many frameworks have better sounding names. I would consider rename it in the

[web2py] How to read latin encoded characters correctly from MSSQL?

2015-04-17 Thread Carlos Costa
Whe I use pyodbc only, I can read and convert characters correctly. But always replace accentuated characters with '?'. I already tried the db_codec='cp1252' and db_codec='latin1' attribute in DAL. In fact, MSSQL uses its own collation: sql_latin1_general_cp1_ci_as as collation. But both latin1

[web2py] websocket messaging VS scheduler

2015-03-31 Thread Carlos Costa
I would like to use scheduler with a task sends websocket messages but it looks like they conflict with each other. I am able to run only one of them. If I start scheduler first, websocket freezes web2py. If I start websocket first scheduler do not run any worker. I start we2py with web2py.py

Re: [web2py] Re: WEB2PY Certificate ?

2015-03-28 Thread Carlos Costa
And what is the future of experts4solutions ? 2015-03-25 0:19 GMT-03:00 Massimo Di Pierro massimo.dipie...@gmail.com: Looks like you did. :-O Anyway, the point of a university is that we do not usually teach courses about specific technologies. We use specific technologies to serve more

Re: [web2py] Re: Install in hostgator

2015-03-23 Thread Carlos Costa
Have you seen this? http://www.web2pyslices.com/slice/show/1567/running-web2py-on-hostgator-shared-host 2015-03-22 23:24 GMT-03:00 LoveWeb2py atayloru...@gmail.com: Did anyone ever find a complete solution to this? I'm using web2py on hostgator and after following this tutorial I can only get

Re: [web2py] several vars in page

2015-03-20 Thread Carlos Costa
Question 1: The parenthesis are wrong. The _href attribute is inside I and not A helper. In fact, a parenthesis was missing too. {{if page:}} {{request.vars.page = [page - 1] }} {{=SPAN(A(I(T('Previous')), _href = URL(vars = request.vars ) ) ) }} {{elif len(rows) items_per_page:}}

Re: [web2py] Re: Search in web2py book case sensitive

2015-03-20 Thread Carlos Costa
+1 2015-03-19 14:07 GMT-03:00 Massimo Di Pierro massimo.dipie...@gmail.com: done. Thanks. On Thursday, 19 March 2015 05:26:22 UTC-5, Kiran Subbaraman wrote: Yes, it is. This line of code probably needs to be changed: https://github.com/mdipierro/web2py-book/blob/master/

Re: [web2py] Re: Function being called twice from one button click

2015-02-26 Thread Carlos Costa
Use the browser console to investigate. Look at the Network tab if it performs two actions with that URL. Another thing that may sound stupid but it is not uncommon and I have already seen it. Some people double click buttons, icons in the web too. I saw a case that a delay between clicks was

Re: [web2py] Translate Controller names and Function names

2015-01-27 Thread Carlos Costa
Very interesting question. It must have some effect on SEO. I have seen this post but it does not seem to solve exactly this https://groups.google.com/forum/#!searchin/web2py/translate$20url/web2py/3adXUSCGQQQ/TaKfRagHyvMJ Although if you have a different URL for different content it will be

Re: [web2py] Re: We could have something like this

2014-10-22 Thread Carlos Costa
It does not the same thing but it does. It was intend to keep recipes, but one can post links to anything too. Thinking this way it is even better than meteorhelp. But the main difference I see is the dated layout, design and UX. It is a nice tool but already needs a refresh. 2014-10-21 11:23

Re: [web2py] Re: We could have something like this

2014-10-22 Thread Carlos Costa
We have Web2py Slices. http://www.web2pyslices.com 2014-10-20 19:41 GMT-02:00 António Ramos ramstei...@gmail.com: it was not a question. we know everything is possible. Its just that finding info about web2py are sometimes dificult A site like this could help and also rate the source of

Re: [web2py] Accesing table from external database

2014-09-17 Thread Carlos Costa
I don't get it. You can make DAL connection to SQL Server, what is the problem you can not? 2014-09-17 16:39 GMT-03:00 José Eloy pepe.e...@gmail.com: Hello! I need to populate a combobox in a FORM (or SQL FORM) with the content of a field of a table which is in an external SQL Server

Re: [web2py] web2py 2.9.7 is OUT

2014-09-05 Thread Carlos Costa
Cool! 2014-09-05 2:47 GMT-03:00 Massimo Di Pierro massimo.dipie...@gmail.com: same as 2.9.6 except: - a few more bug fixes - sessions are stores in sessions/XX/YY/ subfolder to avoid proliferation of files under the same folder which causes slowdown - cache.disk has been rewritten by

Re: [web2py] The Zen of web2py

2014-07-09 Thread Carlos Costa
I like it. I wonder if we could do it in an organized in some way. Recently I lost to convince my boss to change everything to web2py because there are few developers that know it. So it would be very good to have a massive community. As we will have more opportunities to work on the framework

Re: [web2py] The Zen of web2py

2014-07-09 Thread Carlos Costa
I agree with you Massimo, the best ones are those that built something. Videos like this http://vimeo.com/6782736 helped me to decide to stay with web2py. Not only that title is quite marketish but content is so true. 2014-07-09 12:28 GMT-03:00 Massimo Di Pierro massimo.dipie...@gmail.com: I

Re: [web2py] Web2py Rocks ... Again :)

2014-07-03 Thread Carlos Costa
+1 2014-07-03 8:38 GMT-03:00 lyn2py lyn...@gmail.com: Finally, have ironed out all the kinks and sorted out all the errors. Most of them come about because of user-problems (yes, me), because I don't deploy to production often enough to keep up with the versions of all other supporting

Re: [web2py] How do I view text on view.html

2014-06-16 Thread Carlos Costa
You should create and action for that view and pass it in dictionary to the view 2014-06-16 7:08 GMT-03:00 Maurice Waka mauricew...@gmail.com: My code: class Person(): name = 'Victor' def say(self, what): print(self.name, what) getattr(person, attr_name) How do

Re: [web2py] Trying to use the LOAD helper, if a button is clicked

2014-06-16 Thread Carlos Costa
It may work if this button is inside the component loaded. 2014-06-13 20:47 GMT-03:00 Omri Levy my.mail...@gmail.com: Hi , So I have a ticket system, and I want to allow user to edit the ticket without leaving the page. I don't want to LOAD the edit_page and hide it, but only load it once

Re: [web2py] Re: How do I view text on view.html

2014-06-16 Thread Carlos Costa
I guess you need to familiarize yourself more with not just with web2py but also with web development, right? Anthony is right, you should read web2py book at www.web2py.com/book, at least the first chapters to get a start. At first you need to understand MVC. For example you may have: in db.py

Re: [web2py] Re: web2py CMS

2014-06-04 Thread Carlos Costa
I found Plone very hard to do almost anything. For simple sites I would not recomend although it is really the best in the Python world. 2014-06-04 6:02 GMT-03:00 Philip Kilner phil.kil...@gmail.com: Hi, +1 for Plone from me, too. If you only need something lightweight, it may be OTT - but

Re: [web2py] web2py CMS

2014-05-30 Thread Carlos Costa
We have some options as I know. Kpax from Massimo http://vimeo.com/1098656 https://github.com/mdipierro/web2py-appliances/tree/master/KPax2 Quoca and Movuca (more lika a social app) from Bruno Rocha http://quokkaproject.org/ https://github.com/rochacbruno/Movuca

Re: [web2py] Re: requires IS_IN_DB set as a union of two queries

2014-05-29 Thread Carlos Costa
Sorry, I should have written: db.owner.own_veh_fk.requires=IS_IN_DB(db(query),'vehicle.id', '%(manufacturer)s %(vin)s') If you need to pass a set so you need to call db(query) in order to execute the query. 2014-05-28 21:46 GMT-03:00 98uj...@gmail.com: I did try: query = query1 | guery2

Re: [web2py] DAL Referencing By Name Not By ID Possible?

2014-05-28 Thread Carlos Costa
Give a look here: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Legacy-databases-and-keyed-tables But I think it won't work in your case because name is a string. Our you can model it another way. db.define_table('tiers', Field('name', 'string'),

Re: [web2py] DAL Referencing By Name Not By ID Possible?

2014-05-28 Thread Carlos Costa
You are welcome! :) 2014-05-28 11:08 GMT-03:00 'Michael Gheith' via web2py-users web2py@googlegroups.com: Many thanks for this, I found it to be helpful :) On Wednesday, May 28, 2014 6:30:31 AM UTC-5, yamandu wrote: Give a look here: http://web2py.com/books/default/chapter/29/06/the-

Re: [web2py] requires IS_IN_DB set as a union of two queries

2014-05-28 Thread Carlos Costa
Have you tried something like: query1=((db.vehicle.id==db.owner.own_veh_fk)(db.owner.own_end_date!=None)) query2=(~db.vehicle.id.belongs(db(db.owner.own_veh_fk==db.vehicle.id )._select(db.vehicle.id))) query = query1 query2 db.owner.own_veh_fk.requires=IS_IN_DB(query,'vehicle.id',

Re: [web2py] How to select a column of numbers into a list so that I can manipulate the list

2014-05-26 Thread Carlos Costa
Try: nums3 = db(db.Measures).select( db.Measures.measure_value, orderby=db.Measures.measure_date_time).as_list() 2014-05-26 7:20 GMT-03:00 Syd Stewart sydney.w.stew...@gmail.com: Hi What is the simplest way please to select a column of figures (floats and int) into a list, so I can

Re: [web2py] Can't login to Admin interface

2014-05-21 Thread Carlos Costa
How did you started web2py? 2014-05-21 2:36 GMT-03:00 shubham agarwal shubhamagarwal...@gmail.com: I'am trying to login to the web2py admin interface but my password is not been accepted. I'm pretty sure that the password is correct. Can anyone help me with this issue. Thanks --

Re: [web2py] going crazy with pyfpdf

2014-05-21 Thread Carlos Costa
It uses pyfpdf to convert it. But there are some restrictions as I remember. You check it here https://code.google.com/p/pyfpdf/ 2014-05-21 12:13 GMT-03:00 Carlos Cesar Caballero Díaz desarro...@spicm.cfg.sld.cu: Hi, I need some help, when I call a view with .pdf this: html head

Re: [web2py] Re: TAG helper can not parse html

2014-05-20 Thread Carlos Costa
Yeah, the error is thrown by HTMLParser, TAG is build on top of it. I will try some other tools like Beautifull Soup. Thanks. 2014-05-20 10:04 GMT-03:00 Anthony abasta...@gmail.com: No, TAG is only a basic parser and not robust against errors in the HTML. You should probably use a more

Re: [web2py] Re: help with helper!

2014-05-15 Thread Carlos Costa
It is because you are using it the wrong way. MENU helper itself generates the html marckup, ul, li, a, etc Give a look at the documentation here http://web2py.com/books/default/chapter/29/05/the-views?search=menu#MENU Look that MENU has some optional arguments to setup the classes to custom

Re: [web2py] help with helper!

2014-05-14 Thread Carlos Costa
Like this A(I(_class=fa-home),SPAN(Home,_class=menu-item-parent),_href=index.html, _title=Home) 2014-05-14 18:59 GMT-03:00 greenpoise danel.sega...@gmail.com: I need help with this helper! I have this a href=index.html title=Homei class=fa-home/i span class= menu-item-parentHome/span/a

Re: [web2py] help with helper!

2014-05-14 Thread Carlos Costa
Are you using it in the MENU helper? 2014-05-14 20:14 GMT-03:00 greenpoise danel.sega...@gmail.com: I tried this but didnt work. I am using it in the menu section Thanks On Wednesday, May 14, 2014 3:59:19 PM UTC-7, yamandu wrote: Like this

Re: [web2py] OAuth - Can Users Authenticate without an Internet connection?

2014-05-01 Thread Carlos Costa
If they share the same DB and they all are in the same network, the builtin authentication will work. If not, you may want to sync the authentication tables while you have connection. So each local application will have a copy. 2014-05-01 12:22 GMT-03:00 Brando bhe...@trustcc.com: What are

Re: [web2py] OAuth - Can Users Authenticate without an Internet connection?

2014-04-30 Thread Carlos Costa
If each node must authenticate with OAuth with it will requires internet connection. Give a look here: https://developers.google.com/accounts/docs/OAuth2 2014-04-30 16:30 GMT-03:00 Brando bhe...@trustcc.com: I want to use OAuth + Google and want to know if things will work if a node is

Re: [web2py] Re: first() as aggregation function

2014-04-28 Thread Carlos Costa
I think he is looking for the first record of each group, not the first record of the entire result. I think there is no such function in web2py yet. I have performed a similar task for reporting using this: https://docs.python.org/2/library/itertools.html#itertools.groupby It will require more

Re: [web2py] URLising Links in Tables

2014-04-28 Thread Carlos Costa
Use represent and the tag A helper. db.table_name.link_field.represent = lambda value, row: A(value, _href=value) 2014-04-28 13:17 GMT-03:00 jaw...@gmail.com: Hi I've created a run-of-the-mill table: def index(): grid = SQLFORM.grid(db.table_name, user_signature=False) return

Re: [web2py] Re: first() as aggregation function

2014-04-28 Thread Carlos Costa
= 'first_value(b_field) over (partition by a_field order by b_field)' rows = db2(db2.test_table.id 0).select(myexpr, db2.test_table.a_field) for row in rows: print row.aa, row[myexpr] On Monday, April 28, 2014 4:46:43 PM UTC+2, Manuele wrote: Il 28/04/14 16:05, Carlos Costa ha scritto

Re: [web2py] too many values to unpack

2014-04-16 Thread Carlos Costa
To show some code should help us to help you. This type of error occurs when something like this is tried; d = dict(a='a',b='b') a, b, c = d 2014-04-16 6:36 GMT-03:00 Richard richard.dijks...@planet.nl: I have a working app and added a list of form in the response variables from the

Re: [web2py] 'Table' object has no attribute 'attr'

2014-04-16 Thread Carlos Costa
The book says in http://web2py.com/books/default/chapter/29/07/forms-and-validators causes the hidden fields to be passed with the submission, no more, no less. form.accepts(...) is not intended to read the received hidden fields and move them into form.vars. The reason is security. Hidden fields

Re: [web2py] Re: Brazilian web2py users, what system do you use to receive credit card payments?

2014-04-15 Thread Carlos Costa
Pagseguro, for sure is the most used here in Brazil. It belongs to UOL, it has a lot of advertising on TV. Its the best know and trusted. Another options are: -mercado pago -bcash -moip -braspag -f2b -paypal Brasil I tried to sort them in an order of popularity. 2014-04-11 23:54 GMT-03:00

Re: [web2py] AYUDA como ajustar la resolucion de la pagina de web segun el navegador ?

2014-04-15 Thread Carlos Costa
Mayra, esto es lo grupo web2py en ingles. Por favor, reecriba tu question en ingles para que qualquier uno pueda compreenderla. Asi tenes mas chances de ser respondida. Mayra, this is the web2py group in english. Please, rewrite your question in english so anyone can understand it. So you more

Re: [web2py] Need a developer. Seattle Wa

2014-04-04 Thread Carlos Costa
I guess it will be easier to find devs to work remotely for you. Here in the group or even in ODesk for example. Or if you prefer a local dev, you can hire a Django dev and ask him to learn web2py. He will find a very easy learning curve. 2014-04-04 2:59 GMT-03:00 Brando bhe...@trustcc.com:

Re: [web2py] Fun with Scheduler

2013-06-05 Thread Carlos Costa
Very good idea. I have not learned to use scheduler yet. This would be very useful, I think. 2013/6/5 Joe Barnhart joe.barnh...@gmail.com I think the web2py scheduler is the most amazing thing ever added to the platform. It is truly a wonder in that it works so well and has such a clean

Re: [web2py] Avoiding extra quries when using DAL

2013-06-04 Thread Carlos Costa
Maybe something like that. You could do the query and save it as a dict and work on it. result = db(db.table2.id 0).select().as_dict() retVal = [entity.name for entity in result] 2013/6/4 guruyaya guruy...@gmail.com Lets examine this code for a sec: db.define_table('table1',Field('name'))

Re: [web2py] Re: Avoiding extra quries when using DAL

2013-06-04 Thread Carlos Costa
Hum, I forgot the problem has two tables. Nice! 2013/6/4 Massimo Di Pierro massimo.dipie...@gmail.com I would replace retVal = [] for entity in db(db.table2.id 0).select(): retVal += entity.table1.name with table1_map = db(db.table2 http://db.table2.id/).select().as_dict() retVal

Re: [web2py] form.custom in modal window

2013-05-17 Thread Carlos Costa
Have you tested it without modal? Just hit the url for mailVcard.load and make shure it works. If if works you may have to debug the javascript using firebug for example. 2013/5/16 Annet anneve...@googlemail.com I have the following link to open a view in a modal window: a href=#vCardModal

Re: [web2py] How to run web2py on Linux Shared Hosting With No Shell, or SSH access

2013-05-17 Thread Carlos Costa
Have you asked your host for SSH access? I have used hostgator, I have to ask then to grant me SSH access, and even with this is a pain to make web2py run there. If they dont give it anyway, consider change the host, give a try at pythonanywhere.com, you should install web2py with one click.

Re: [web2py] Dynamic IS_IN_DB

2013-05-02 Thread Carlos Costa
You may try something like this: for id in id_list: query = query | (db.asset_class.id == id) requires = IS_IN_DB(query,..) 2013/5/2 Domagoj Kovač doctorko...@gmail.com Hi, i want to have dynamic query in my IS_IN_DB validator: requires = IS_IN_DB(db((db.asset_class.id == 10)

Re: [web2py] Doubt in the example provided on web2py manual page 98

2013-03-14 Thread Carlos Costa
Probably you are confused because of this code present in index.html: {{elif 'content' in globals():}} {{=content}} {{else:}} {{=BEAUTIFY(response._vars)}} {{pass}} If theres no content it renders the BEAUTIFY(response._vars) just like the generic view, so its not the generic view being rendered

Re: [web2py] REF: SQLFORM.grid: Determine when a new record is added

2013-03-14 Thread Carlos Costa
Check oncreate argument. 2013/3/14 Teddy Nyambe software@gmail.com I want to add logic when a user clicks on submit to add a new record using the SQLFORM.grid, I would like to do something. I have checked the vars and args there is nothing to indicate this only when a form is requested

Re: [web2py] Re: creating groups

2013-03-02 Thread Carlos Costa
You can create records and the the auth_group to create a group give a look at it in the database admin, it is simple. For example: form = crud.create(db.auth_group) with this line you can create a form where the user will insert a record, so creating a new group. To put someone in a group

Re: [web2py] refresh div in a html page (web2py)

2012-12-18 Thread Carlos Costa
What you get when you access the test2.html url in the browser? Maybe the url is wrong. Try to inspect using firebug in error console. 2012/12/18 yn yn lkga...@gmail.com Hi I am starting using web2py. I have a page web Test.html in view with a div: . On the other hand, I have a page web in

Re: [web2py] formatting time string during field update

2012-12-18 Thread Carlos Costa
In web2py_ajax.html there is the format that is used for jquery, try that. 2012/12/18 marino segnan sgn...@gmail.com Hello, I am a beginner with web2py and I have this apparently simple problem. I have a db table: db.define_table('tappe',

  1   2   >