Re: [web2py] Re: Some trouble with the oracle driver

2014-12-22 Thread Paolo Valleri
I don't have an oracle instance to run tests. do you mind to check if with_alias works in a simple query? Paolo Il giorno domenica 21 dicembre 2014 11:52:06 UTC+1, Manuele ha scritto: Il 21/12/14 08:00, Paolo Valleri ha scritto: My guest is the alias name 'group', have you already tried

Re: [web2py] pass query from client to sever

2014-12-22 Thread Manuele Pesenti
Il 22/12/14 07:07, Massimo Di Pierro ha scritto: We do not have a way to serialize queries in a server independent way but we should. I'm using this recipe with success: http://www.web2pyslices.com/slice/show/1593/class-for-building-db-queries-from-python-dictionaries essentially I serialize

[web2py] Re: Australian Users

2014-12-22 Thread Simon Ashley
That's a negative but went to school both ends of Johnston St. Family's in Vic for the holidays while I slave away on the GC on EOY system changes. :) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: One AutoComplete overrides another

2014-12-22 Thread tim . nyborg
Found my mistake; hopefully it will save someone time in the future. Multiple autocompletes referring to the same field need keyword arguments, otherwise they all end up as the default '_autocomplete_%(tablename)s_%(fieldname)s' (_autocomplete_module_code in my case). Once I gave them

[web2py] wiki page contents

2014-12-22 Thread Manuele Pesenti
Hi *, I'm trying the auth.wiki for the first time and I cannot find where the pages contens is saved. on the db? somewhere on the fs? Thank you Manuele -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Lazy options widget

2014-12-22 Thread Gael Princivalle
Hello all. I'm still trying to use this lazy option widget: http://dev.s-cubism.com/plugin_lazy_options_widget Also in a new application, when I load the db page or the index page I have this error: type 'exceptions.TypeError' unsupported type for timedelta seconds component: NoneType 1278.

[web2py] Re: wiki page contents

2014-12-22 Thread Niphlod
the db (wiki_* tables) On Monday, December 22, 2014 11:29:16 AM UTC+1, Manuele wrote: Hi *, I'm trying the auth.wiki for the first time and I cannot find where the pages contens is saved. on the db? somewhere on the fs? Thank you Manuele -- Resources: - http://web2py.com -

Re: [web2py] Re: wiki page contents

2014-12-22 Thread Manuele Pesenti
Il 22/12/14 14:26, Niphlod ha scritto: the db (wiki_* tables) so why I cannot see them from the admin page? :) was exactly what I was expacting... and I looked for M. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Re: bootstrap 3 - if you care help test trunk now

2014-12-22 Thread Dmitry Ermolaev
how I can include Layout Themes in admin/wizard/step1# ?? There is only Default (( Plugins - also is empty ( воскресенье, 10 августа 2014 г., 6:30:06 UTC+4 пользователь Massimo Di Pierro написал: https://github.com/web2py/web2py/archive/master.zip note, you have to use formstyle. For auth

Re: [web2py] Re: wiki page contents

2014-12-22 Thread Paolo Valleri
because I guess you have instantiated the wiki in a controller. To see table definitions in admin you have to instantiate it in a model file Paolo On Monday, December 22, 2014 2:46:03 PM UTC+1, Manuele wrote: Il 22/12/14 14:26, Niphlod ha scritto: the db (wiki_* tables) so why I cannot

Re: [web2py] Re: wiki page contents

2014-12-22 Thread Niphlod
it's because they're defined at run-time by default (i.e. when you call wiki from the controller) if you want to be able to see tables, you need to call auth.wiki (resolve=False) as documented (largely and explicitely) on

[web2py] Re: Not in touch with web2py community for a while. anything new interesting?

2014-12-22 Thread Kenneth
I think PyNuke is the latest CMS based on Web2py. On Tuesday, December 2, 2014 1:07:48 PM UTC-5, Phyo Arkar wrote: Being busy and i lost touch with w2p community for a while. What are the new features of web2py? What are the most actively maintainted web2py community projects ?

Re: [web2py] Re: SocketTimeout: Socket timed out before request

2014-12-22 Thread Richard Vézina
Antonio, Lennon suggest to delete his email because it was a mistake... And your issue that seems more interresting seems unrelated to this thread... I suggest you to create a thread about it!! Richard On Mon, Dec 15, 2014 at 7:50 PM, Antonio Salazar asalaza...@gmail.com wrote: I know this is

[web2py] Datetime Grid Filtering ignores localized format and timezone

2014-12-22 Thread mcamel
Hi all, I use frequently spanish localization, so dates are formated like day/month/year. Everything works fine if this is located at languages/es.py: '%Y-%m-%d %H:%M:%S': '%d/%m/%Y %H:%M:%S'. Represents, validators and widgets, follow this rule. But if you try to filter a grid by datetime

[web2py] tips requested for tracing errors

2014-12-22 Thread Alex Glaros
any suggestions for figuring out what line of code is causing the error? field displayName is used in many places and hard to analyze thanks Alex Glaros Error ticket for ES1 Ticket ID 127.0.0.1.2014-12-22.15-46-50.434cb922-6ec2-438c-a158-c2a710eafc0c type 'exceptions.AttributeError' 'Table'

[web2py] Re: tips requested for tracing errors

2014-12-22 Thread Alex Glaros
found the error in a requires statement but solved error through random luck. Any suggestions for methodically identifying coding mistake would be greatly appreciated -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: tips requested for tracing errors

2014-12-22 Thread Alex Glaros
I searched the error ticket for traces of table name, line number, but couldn't see any connection to anything regarding the real error (which I knew) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] ck_editor plugin updated

2014-12-22 Thread Tim Richardson
I've updated the ck_editor plugin. Improvements from dmvieira are merged. Also, ck_editor code is now the current release (4.4.6 Nov 25 2014) Web2py slices: http://www.web2pyslices.com/slice/show/1952/ck-editor4-plugin -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Australian Users

2014-12-22 Thread Tim Richardson
Three would be a user group! My office is in Johnston St so if you're ever around ... also there is a PUG first Mondays in Richmond, FYI (via Meetup). On Monday, 22 December 2014 20:16:17 UTC+11, Simon Ashley wrote: That's a negative but went to school both ends of Johnston St. Family's

[web2py] Web2py using IOS Safari

2014-12-22 Thread Ira Fuchs
Can anyone please tell me why IOS Safari (on iPad) cannot display the Web2py admin page correctly? In particular the window on the right side of the page is not rendered. Atomic Web (another IOS browser) works but I would like to be able to use Safari. Is there a workaround? -- Resources: -

[web2py] Re: One AutoComplete overrides another

2014-12-22 Thread Tim Nyborg
I haven't found a solution to this, but have found more detail about the problem: The first defined autocomplete widget on a particular field overrides ALL others defined after. idb.define_table( 'fee', ... Field('module_code', 'string', writable=False, label='Module code',

[web2py] PYODBC and IIS App Pool Memory Leak?

2014-12-22 Thread Pbop
We have deployed a web2py app to a client site with the client now doing some testing. On an initial load into the app by the first browser and on stress load of concurrent users, this error is being thrown. class 'gluon.contrib.pypyodbc.Error' (u'HY090', u'[HY090] [Microsoft][ODBC Driver

[web2py] SQL Whitelist Beta

2014-12-22 Thread abhishek dusane
Hello all, I want to add this tool in plesk, I have searched many forums and sites for solutions but didn't get any solutions. Please anyone tell me how do I do that. Thanks, -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Using android for development

2014-12-22 Thread Rodrigo Cesar
Hi everybody, i have everyday some free time and want to use it to develop a program i'll use, but the only machine i have on hands is a android tablet, i've read it's possible to run web2py on android, my question is: is it possible to use android to develop? I don't realy need a very good

[web2py] web2py with Mobile Safari

2014-12-22 Thread Ira Fuchs
Safari on the iPad apparently sends a mobile useragent string which web2py uses to tailor the UI. As a result I do not see a way to get, for example, the form on the admin screen (the one that you can use to start a new app). Is there a way to get to this form on the mobile UI? Better yet, is

[web2py] Web2py on iPad using Pythonista

2014-12-22 Thread Ira Fuchs
I am trying to get web2py working on an iPad running Pythonista. It works fine although there is no Tk library so everything must be done in the console or the web interface. The problem with using the web interface is that if you leave Pythonista and thereby make it a background process in

[web2py] Re: Unable to connect to MSSQL via web2py - SSL Security Error

2014-12-22 Thread Dallas Baird
On Thursday, 25 September 2014 17:49:44 UTC+10, Alen Cerovic wrote: Can t believe it, it did the trick :) yes I am using binaries on windows 7 64bit. Can you explain me what is going on, thnx FWIW: I didn't have this problem last week, but I do this week. Yesterday I installed Sql server

[web2py] Migrate sessions from files to DB

2014-12-22 Thread harsha tanguturi
The sessions are being stored in the files but I would like to migrate them to DB without disturbing the existing sessions. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: Unable to connect to MSSQL via web2py - SSL Security Error

2014-12-22 Thread Dallas Baird
Hi all, I was not having this problem last week, all of a sudden I am. Today I had installed many SQL SERVER 2008 r2 libraries (integration services, ssms, dts backwards compatability etc). Perhaps the new installation has introduced a versioning problem with a dll? Dallas On Saturday, 27

[web2py] Re: Searching for multiple words in SQLFORM.grid

2014-12-22 Thread Ariya Owam-aram
Thank you for your sharing. It working excellent. On Friday, March 1, 2013 3:19:22 PM UTC+7, Mandar Vaze wrote: Hi, As you all know, SQLFORM.grid search does not support searching for multiple words - it throws an error Invalid Query Searching for multiple words may be a common

[web2py] Select rows

2014-12-22 Thread Oliver
I'm getting None printed in the webpage. I'm trying to print all first_name in the users table database. I'm trying to follow the select section in http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Query--Set--Rows I'm using MySQL for database and have few test

[web2py] Doubt in controllers (urgent)

2014-12-22 Thread sai7 Harsh
Sir, Could you please explain how to give a condition such that below that it need to display error like marks above 60 only can apply but some person enter 50 so it need to display error and one more thing how to keep any field in the form is optional no need to fill it -- Resources: -

[web2py] no suitable image found in web2py

2014-12-22 Thread Chandra G
Hi Friends Find below my exceptional error. I am running mac OS x Yosemite...It would be great if you solve below the error. Traceback (most recent call last): File /Users/chandramouli/Dropbox (TIS Group)/testing/Builds/Apollo/Code Src/web2py/gluon/restricted.py, line 224, in restricted

[web2py] Re: interget or string to date

2014-12-22 Thread Sébastien Loix
An old post to solve a 2014 problem. Thanks for sharing! :) El miércoles, 2 de noviembre de 2011 16:27:23 UTC+1, Vineet escribió: Recently, I wrote this function for my purpose. See if this helps you. Assuming that argument 'dte' input format is -- 03-11-2011 [CODE] import datetime,

[web2py] Auth Users Session

2014-12-22 Thread Oliver
Hi All, I really enjoy discovering the beauty of web2py. Just got a newbie question :) If I create multiple apps and use one db or sharing one db to all apps, can the login session be shared between apps? Thanks. For example from the default, we have the admin(which is lock), welcome and

[web2py] Re: pass query from client to sever

2014-12-22 Thread Massimo Di Pierro
something like that should be included in web2py. On Monday, 22 December 2014 00:07:18 UTC-6, Massimo Di Pierro wrote: We do not have a way to serialize queries in a server independent way but we should. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Doubt in controllers (urgent)

2014-12-22 Thread Dave S
On Tuesday, December 16, 2014 8:48:29 AM UTC-8, sai7 Harsh wrote: Sir, Could you please explain how to give a condition such that below that it need to display error like marks above 60 only can apply but some person enter 50 so it need to display error and one more thing how to keep

[web2py] Re: Select rows

2014-12-22 Thread Dave S
On Wednesday, December 17, 2014 12:17:53 PM UTC-8, Oliver wrote: I'm getting None printed in the webpage. I'm trying to print all first_name in the users table database. I'm trying to follow the select section in

[web2py] Re: Using android for development

2014-12-22 Thread Dave S
On Wednesday, December 17, 2014 4:58:24 PM UTC-8, Rodrigo Cesar wrote: Hi everybody, i have everyday some free time and want to use it to develop a program i'll use, but the only machine i have on hands is a android tablet, i've read it's possible to run web2py on android, my question

[web2py] Re: pass query from client to sever

2014-12-22 Thread Niphlod
it is. it's just experimental. On Tuesday, December 23, 2014 5:45:11 AM UTC+1, Massimo Di Pierro wrote: something like that should be included in web2py. On Monday, 22 December 2014 00:07:18 UTC-6, Massimo Di Pierro wrote: We do not have a way to serialize queries in a server independent

[web2py] Re: Datetime Grid Filtering ignores localized format and timezone

2014-12-22 Thread Paolo Valleri
Hi, the issue is here https://github.com/web2py/web2py/blob/master/gluon/sqlhtml.py#L1830 can you try to replace that line with the following: iso_format = {'_data-w2p_datetime_format' : T('%Y-%m-%d %H:%M:%S')} Paolo On Monday, December 22, 2014 11:02:00 PM UTC+1, mcamel wrote: Hi all, I