[web2py] Re: Web2py not connect to Oracle DB (error DAL)

2016-12-28 Thread ratlionstasus
Fixed a URI , but now get the error ORA-12162 суббота, 24 декабря 2016 г., 6:58:42 UTC+3 пользователь ratlio...@gmail.com написал: > > good day. learn web2py. installed, configured server to connect to > orcle,but cannot connect through dal, with sqlplus connects fine. line 116, > in the

[web2py] Re: Web2py not connect to Oracle DB (error DAL)

2016-12-28 Thread ratlionstasus
Sorry I test correct uri tooday, this my errors. Dal('oracle://user:password@sid') -- 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

[web2py] Re: Upgrading web2py

2016-12-28 Thread Anthony
> Though there is no reason to change the layout or CSS unless you want to. >> Nothing will break if you keep your old layout. The only things in the >> front end that could break upon upgrade are those that are coupled to >> backend framework code (e.g., web2py.js, which depends on the

[web2py] Re: I can't open database tables help

2016-12-28 Thread Dave S
On Wednesday, December 28, 2016 at 6:10:22 PM UTC-8, Mehmet Alp Albayraktaroğlu wrote: > > Hi Guys database tables doesn't work in my web2py. whatever ı do get same > ticket. what ı am doing wrong ? > name 'tb' is not defined> > Can you show us your table definitions? Are you defining

[web2py] Re: Database error: month must be in 1..12

2016-12-28 Thread Dave S
On Wednesday, December 28, 2016 at 6:10:27 PM UTC-8, Nabil Ontour wrote: > > Hello, > > I can't access my web2py page anymore, as it is showing the following > error: > > month must be in 1..12 > > Variables > > datetime.date > val '2016-14-12' > global datetime

[web2py] I can't open database tables help

2016-12-28 Thread Mehmet Alp Albayraktaroğlu
Hi Guys database tables doesn't work in my web2py. whatever ı do get same ticket. what ı am doing wrong ? name 'tb' is not defined> Frame - *File /root/Masaüstü/web2py/gluon/restricted.py in restricted at line 227* code arguments variables

[web2py] Database error: month must be in 1..12

2016-12-28 Thread Nabil Ontour
Hello, I can't access my web2py page anymore, as it is showing the following error: month must be in 1..12 Variables datetime.date val '2016-14-12' global datetime builtinint val.split builtinmap I am using SQLite. I can't access the database from the admin frontend either, as a query

[web2py] FPDF

2016-12-28 Thread Áureo Dias Neto
Good night, How i'm add a new page, and set new content to this, on pdf, with fpdf? I use pdf.add_page(), but the content o the second page is the same as the first.. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: required=True

2016-12-28 Thread Paolo Caruccio
In addition to the Anthony's answer , if you want also experiment simple native client side validation for web form, you could customize the field widget Field('myfield', 'string', requires=IS_NOT_EMPTY(), widget=lambda f,v:

[web2py] Re: Upgrading web2py

2016-12-28 Thread Dave S
On Wednesday, December 28, 2016 at 11:42:48 AM UTC-8, Anthony wrote: > > On Wednesday, December 28, 2016 at 2:31:59 PM UTC-5, Dave S wrote: >> >> >> >> On Wednesday, December 28, 2016 at 9:42:26 AM UTC-8, Anthony wrote: >>> >>> Also, can you expand on "did not work"? What problems do you see?

[web2py] Re: Upgrading web2py

2016-12-28 Thread Anthony
On Wednesday, December 28, 2016 at 2:31:59 PM UTC-5, Dave S wrote: > > > > On Wednesday, December 28, 2016 at 9:42:26 AM UTC-8, Anthony wrote: >> >> Also, can you expand on "did not work"? What problems do you see? >> >> The main thing you might need to update within the app is web2py.js. >>

[web2py] Re: Upgrading web2py

2016-12-28 Thread Dave S
On Wednesday, December 28, 2016 at 9:42:26 AM UTC-8, Anthony wrote: > > Also, can you expand on "did not work"? What problems do you see? > > The main thing you might need to update within the app is web2py.js. Maybe > also web2py_ajax.html, appadmin.py, and appadmin.html. > > Anthony > There

Re: [web2py] off topic - what GUI do you use to view pythonAnywhere Postgres metadata?

2016-12-28 Thread Alex Glaros
pythonAnywhere just started analysing what fields go where in Putty, so will try SSH tunneling late tonight when I get home. Will share if successfull. thanks Richard. On Wed, Dec 28, 2016 at 11:13 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Hello Alex, > > I don't know

[web2py] Re: Help writing my first Web APP using Web2py

2016-12-28 Thread Dave S
On Wednesday, December 28, 2016 at 8:20:26 AM UTC-8, Sif Baksh wrote: > > I’m trying to use web2py to create a program for some of my buddies, it’s > called “Home Run Derby”. Each member will pick 6 baseball players, only the > top 5 score will count as a total score for each member. > > > >

Re: [web2py] off topic - what GUI do you use to view pythonAnywhere Postgres metadata?

2016-12-28 Thread Richard Vézina
Hello Alex, I don't know Pythonanywhere though you can't make SSH port foward and access pgAdmin4 "locally"? Richard On Wed, Dec 28, 2016 at 1:02 PM, Alex Glaros wrote: > How do people view their Postgres tables meta-data directly? I.e., > constraint definitions,

[web2py] Re: Web2py not connect to Oracle DB (error DAL)

2016-12-28 Thread ratlionstasus
Database oracle 11.04 Connect uri: 'oracle://user/password@sid' Test any uri: 'oracle://user/password@ip :port/sid' Error! Cli python and sqlplus this connect string, connection Ok! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: why you should upgrade to web2py 2.13.4

2016-12-28 Thread Mat Miles
Waiting for Pythonanywhere to add this to their upgrade option. On Saturday, December 26, 2015 at 1:22:27 AM UTC-7, Massimo Di Pierro wrote: > > There are many reasons you should upgrade, depending on which version you > are using now: > > - to help us make sure we did not break backward

[web2py] off topic - what GUI do you use to view pythonAnywhere Postgres metadata?

2016-12-28 Thread Alex Glaros
How do people view their Postgres tables meta-data directly? I.e., constraint definitions, sequence creation scripts, etc. What apps or methods to view do you use? Pythonanywhere posts example using pgAdmin3 but didn't work for me and

[web2py] Re: Upgrading web2py

2016-12-28 Thread Anthony
Also, can you expand on "did not work"? What problems do you see? The main thing you might need to update within the app is web2py.js. Maybe also web2py_ajax.html, appadmin.py, and appadmin.html. Anthony On Wednesday, December 28, 2016 at 11:36:55 AM UTC-5, Massimo Di Pierro wrote: > > Can

[web2py] Re: Need help to debug this error when using URL from gluon/html.py

2016-12-28 Thread Anthony
> > May I ask how did you figure out? I mean, did you already know about that > jquery stuff, or did you made some search with the parameter's names? > Just did a Google search with some of the parameter names and found that Reddit post. > P/D: I looked in the web2py's website and I didn't

Re: [web2py] Re: We do not delete posts

2016-12-28 Thread Terrence Brannon
I think I posted it to this google group. I was alerting the group about how to create the ssh tunnel. The second ssh call should not have an ampersand following it. My patch request indicates this:

[web2py] Re: help,passing java script variable using ajax

2016-12-28 Thread nishanta sarma
thank you,could solve the issue -- 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: help,passing java script variable using ajax

2016-12-28 Thread nishanta sarma
Thank you, could solve the issue On Wednesday, December 28, 2016 at 10:08:35 PM UTC+5:30, Massimo Di Pierro wrote: > > yes because you use val inside {{...}} and that is python code, not JS > code. > > Try replace > > ajax('{{=URL('default','other' vars = {'key':val})}}',[],'target')"/>; > > >

[web2py] Re: Need help to debug this error when using URL from gluon/html.py

2016-12-28 Thread Lisandro
OMG! Anthony you really rock man!! Thanks **a lot** That's exactly what's going on, and it explains the error being so sporadic. Definitely, I'll transform the request.get_vars before passing it to URL() in order to avoid the error. May I ask how did you figure out? I mean, did you already know

[web2py] Re: Need help to debug this error when using URL from gluon/html.py

2016-12-28 Thread Anthony
> > This is a login button, present in the layout, so it's in every page: > > LOGIN > > The url of the login button uses the vars argument to pass the "_next" > key. The _next key contains the current url (with current request.args and > request.get_vars). > Check out

[web2py] Re: We do not delete posts

2016-12-28 Thread Massimo Di Pierro
where did you post it? On Wednesday, 28 December 2016 10:20:21 UTC-6, Terrence Brannon wrote: > > I posted about a typo in the web2py book regarding SSH tunneling and I do > not see my post. > > On Monday, July 20, 2015 at 4:08:57 AM UTC-4, Massimo Di Pierro wrote: >> >> We never delete posts

[web2py] Re: help,passing java script variable using ajax

2016-12-28 Thread Massimo Di Pierro
yes because you use val inside {{...}} and that is python code, not JS code. Try replace ajax('{{=URL('default','other' vars = {'key':val})}}',[],'target')"/>; with ajax('{{=URL('default','other')}}?key='+val,[],'target')"/>; On Wednesday, 28 December 2016 10:20:26 UTC-6, nishanta sarma

[web2py] Re: Upgrading web2py

2016-12-28 Thread Massimo Di Pierro
Can you define "the latest version". Can you install in a new folder and then copy the old web2py/applications/ subfolder over the new one? On Wednesday, 28 December 2016 10:20:22 UTC-6, Jorrit wrote: > > I have an application that runs on web2py 2.9.11 . I tried downloading the > latest

[web2py] Re: user_signature not working...

2016-12-28 Thread Massimo Di Pierro
It should be something like: @auth.requires_login() def index(): redirect(URL('entities', 'list',user_signature=True)) @auth.requires_signature() def list(): If you are logged into index, then index can generate links which are signed. If you are not logged in, than it does not

[web2py] Re: Web2py not connect to Oracle DB (error DAL)

2016-12-28 Thread Massimo Di Pierro
we will need more details. what database? what is the URI string? On Friday, 23 December 2016 21:58:42 UTC-6, ratlionsta...@gmail.com wrote: > > good day. learn web2py. installed, configured server to connect to > orcle,but cannot connect through dal, with sqlplus connects fine. line 116, > in

[web2py] Help writing my first Web APP using Web2py

2016-12-28 Thread Sif Baksh
I’m trying to use web2py to create a program for some of my buddies, it’s called “Home Run Derby”. Each member will pick 6 baseball players, only the top 5 score will count as a total score for each member. Now I get the players name, team and HR by scraping a website and put it in a CSV

[web2py] Upgrading web2py

2016-12-28 Thread Jorrit
I have an application that runs on web2py 2.9.11 . I tried downloading the latest version, packaging the app in the old version and re-uploading it in the new version, but predictably this did not work. The documentation says that upgrading should just be a matter of unzipping the new version

[web2py] Re: We do not delete posts

2016-12-28 Thread Terrence Brannon
I posted about a typo in the web2py book regarding SSH tunneling and I do not see my post. On Monday, July 20, 2015 at 4:08:57 AM UTC-4, Massimo Di Pierro wrote: > > We never delete posts from users, unless the users ask (because they > accidentally post the server password, for example). Yet

[web2py] help,passing java script variable using ajax

2016-12-28 Thread nishanta sarma
function my_function() { var val = 'val'; ajax('{{=URL('default','other' vars = {'key':val})}}',[],'target')"/>; } 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

[web2py] Re: required=True

2016-12-28 Thread Anthony
On Wednesday, December 28, 2016 at 7:24:57 AM UTC-5, Andrea Fae' wrote: > > Why if I use this option in Field table database but when I insert and I > leave not typed this field the system accepted it? > If you are making insertions via a form, you are better off using a validator:

[web2py] Re: dynamic form component

2016-12-28 Thread Pierre
this is a view that should allow users to send messages (submit form/messages...and not to reload the actual page) trying this from Anthony: https://groups.google.com/forum/?fromgroups#!searchin/web2py/dynamic$20component/web2py/-_xH0vnfr7I/J05mFfPvW9cJ form component loads well onclicked

[web2py] Re: required=True

2016-12-28 Thread Leonel Câmara
Probably you are sending it an empty string so there is a value there. -- 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

[web2py] Re: Need help to debug this error when using URL from gluon/html.py

2016-12-28 Thread Lisandro
Sorry for the delay on this, I wanted to make a second full review. I confirm that there is no call to URL() in my code that uses vars argument with a 'title' key. I checked all the included and extended files. However, I have these lines to point out, because they seem a bit "suspicious" to me,

[web2py] Re: dynamic form component

2016-12-28 Thread Marlysson Silva
What structure you should like generate? Em quarta-feira, 28 de dezembro de 2016 10:45:56 UTC-3, Pierre escreveu: > > Hi, > > I have a set of buttons displayed in a view. I'd like each button to > pass different args to the form component (prepopulate some of the form > fields). I can probably

[web2py] dynamic form component

2016-12-28 Thread Pierre
Hi, I have a set of buttons displayed in a view. I'd like each button to pass different args to the form component (prepopulate some of the form fields). I can probably achieve this via some tricky js/jquery but is there a better option like loading the component when necessary with the

Re: [web2py] Re: why you should upgrade to web2py 2.13.4

2016-12-28 Thread LightDot
On Saturday, December 24, 2016 at 2:05:53 PM UTC+1, Rodrigo attique santana wrote: > > .. an app created in 2.14 does not run in 2.11. It returns me invalid > request. ... > That's only to be expected. One can create an app in 2.11.x and it should run under later versions of web2py (as it's

[web2py] required=True

2016-12-28 Thread Andrea Fae'
Why if I use this option in Field table database but when I insert and I leave not typed this field the system accepted it? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

Re: [web2py] Row position change if I switch from a file to another

2016-12-28 Thread Áureo Dias Neto
You can then configure the default application for .py files as notepad ++, and for example, in filezilla, if you navigate to your local files with the right button and edit them, after saving, it automatically detects the Files and asks if you want to update the files on the server. I usually do

Re: [web2py] Row position change if I switch from a file to another

2016-12-28 Thread Gael Princivalle
Thank's Aureo. I use notepad ++ for other goals. What do you mean by "edit the files by path" ? Modifying in local the files and sending then by ftp is not so quick and easy. "edit the files by path" can avoid it? Il giorno mercoledì 28 dicembre 2016 11:08:22 UTC+1, Áureo Dias Neto ha

[web2py] user_signature not working...

2016-12-28 Thread António Ramos
def index(): redirect(URL('entities', 'list',user_signature=True)) This redirect does not redirect with signature to entities\list and i get redirected to default/user/not_authorized entities.py @auth.requires_signature() @auth.requires_login() def list(): ... any ideas ? thank you --

Re: [web2py] Row position change if I switch from a file to another

2016-12-28 Thread Áureo Dias Neto
Good morning, The best to do, is, use a external editor of your choice, ex: sublime text, to edit the files by path 2016-12-28 7:53 GMT-02:00 Gael Princivalle : > Hello all. > > In the administrative interface, if I'm still working on the default.py > file row 234,

[web2py] Row position change if I switch from a file to another

2016-12-28 Thread Gael Princivalle
Hello all. In the administrative interface, if I'm still working on the default.py file row 234, and I switch to menu.py row 25, when I turn back to default.py I'm not anymore in the same row, 234, but 16. It's not user friendly as I have to scroll down and up all the time. Is there a way to