Re: [web2py] Why won't my bootstrap modal form close?

2014-05-27 Thread weheh
Alright, I got it to work, but it's super fugly. I created a javascript function: function hide_modal() { $("#contact-dialog").modal("hide"); } and then in my controller I replaced the response.js with this: response.js = 'hide_modal("#contact-dialog");' So that works. But WHY? I think th

Re: [web2py] Re: global name 'db' is not defined

2014-05-27 Thread Jonathan Lundell
On 27 May 2014, at 6:21 AM, Henrik Holm wrote: > On Tuesday, May 27, 2014 8:46:19 AM UTC-4, Anthony wrote: > > I suppose we could add a setting that allows you to specify model order, > though for backward compatibility, the initial model file (i.e., the one > where you make that setting) woul

[web2py] not able to include jqueryui in web2py

2014-05-27 Thread sarfaraz ahmed
Hello All, I am trying to override the web2py default theme and use customized jqueryui theme. Hence I downloaded the customized jqueryui js files and css files. Copied them to static folder of my test project. I created the jqueryui folder under static folder. I created the layout1.html file w

[web2py] I posted one question to web2py-user group not able to find it

2014-05-27 Thread sarfaraz ahmed
The question was regarding using jqueryui in web2py. -- 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

[web2py] Not able to access scheduler_task table getting error "DAL" object has no attribute "scheduler_task"

2014-05-27 Thread Keerti Agrawal
I am trying to write a callback function on scheduler_task table but its giving rror "DAL" object has no attribute "scheduler_task". when i see attributes of SAL object using dir(db) it is not having scheduler_task table or any table which is maintained by scheuler. Please help me how can i write

[web2py] Re: global name 'db' is not defined

2014-05-27 Thread Henrik Holm
On Tuesday, May 27, 2014 8:46:19 AM UTC-4, Anthony wrote: > I suppose we could add a setting that allows you to specify model order, > though for backward compatibility, the initial model file (i.e., the one > where you make that setting) would have to be first alphabetically. > Would it make

[web2py] Re: what is loader.js for?

2014-05-27 Thread chuan137
anyone kowns what it is? On Monday, May 26, 2014 2:08:24 PM UTC+2, chuan137 wrote: > > looking at my simple example from chrome developer's tool, I noticed > loader.js doing something in the background. > seems related with statistics or ads. > > can someone explain it to me? is it possible to di

Re: [web2py] how to modify form input before validation and insert into database?

2014-05-27 Thread chuan137
Thank you. On Tuesday, May 27, 2014 9:14:07 AM UTC+2, Johann Spies wrote: > > On 26 May 2014 23:26, chuan137 > wrote: > > I want to replace white spaces with underscore and capitialize each word >> before insert them into database. I am using SQLFORM(...) and I find >> onvalidation is used after

Re: [web2py] Custom Auth

2014-05-27 Thread Brian M
Greg, I know this is an old thread, but did you ever come up with a solution? I've got an asp.Net app that I'd be nice to be able to authenticate against. Thanks Brian On Wednesday, October 9, 2013 9:22:07 PM UTC-5, GregD wrote: > > We have to use tables from sql server (aspnet_user and aspnet_

Re: [web2py] Why won't my bootstrap modal form close?

2014-05-27 Thread weheh
Richard - this modal is a component. I'm rapidly coming to the conclusion that there's some jQuery variable scope issue at play. I just haven't found it, yet. Very frustrating. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source c

[web2py] I am using Haystack module created by Massimo, does it support insertorupdate?

2014-05-27 Thread Kenneth
I see that it updates indexes when it updates,deletes or insert. Does it refresh indexes when I use insertorupdate on DAL? Thank you! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issu

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

2014-05-27 Thread 'Michael Gheith' via web2py-users
I have two pretty basic tables: db.define_table('tiers', Field('name', 'string'), Field('created_on', 'datetime', default=request.now), format = '%(name)s') db.define_table('metrics', Field('tier_id', 'reference tiers'), Field('total_count', 'integer'), Field('total_size',

[web2py] Re: Post Request Timeout

2014-05-27 Thread Anthony
Hard to say what's going on without knowing more. This may not be related to your problem, but when you iterate over request.post_vars (or any dictionary-like object), you are iterating over the keys, not the values. Also, there is no guarantee regarding the order of the keys, so fieldKeys[0] c

[web2py] Re: Verify password does not fit formstyle

2014-05-27 Thread Anthony
Please submit a Google Code issue about this. We need a way for Auth forms to work with custom formstyles. On Sunday, May 25, 2014 10:50:15 AM UTC-4, Jaime Sempere wrote: > > Hi, > > I am having the same issue pointed here by Ricardo Pedroso: > > > https://groups.google.com/forum/#!searchin/web2p

[web2py] Re: global name 'db' is not defined

2014-05-27 Thread Anthony
Also, note that you can move your model definitions to modules and then import and run them in any order you want. Anthony On Tuesday, May 27, 2014 8:46:19 AM UTC-4, Anthony wrote: > > On Tuesday, May 27, 2014 8:09:43 AM UTC-4, Henrik Holm wrote: >> >> Anthony, >> >> Not sure really - I was wond

Re: [web2py] Re: json query

2014-05-27 Thread Manuele Pesenti
Il 27/05/14 13:56, Anthony ha scritto: > I'm not sure if the DAL includes any code to de-code JSON queries, but > I found this web2py slice written around the same time that > Query.as_json was added to the DAL: > http://www.web2pyslices.com/slice/show/1593/class-for-building-db-queries-from-python

[web2py] Re: 2.9.5 crashes @ startup

2014-05-27 Thread Derek
Well, you are getting a write fault. -2146893795 Error_Write_Fault Do you have it in a read-only folder? On Tuesday, May 27, 2014 5:12:13 AM UTC-7, Dick Schrauwen wrote: > > OS: win vista > web2py 295 > Starting up by double-click: won't run > From commandline gives: > > C:\PROJ-new\web2py295>c

[web2py] Re: How to make session variables persist even after logout ?

2014-05-27 Thread Derek
Yes, as Massimo and I have suggested, you should store them in extra_fields. That way they will be associated with the users. Another alternative is to use an extra cookie, but that seems like a waste of bandwidth. On Friday, May 23, 2014 9:06:12 PM UTC-7, Mandar Vaze wrote: > > Derek, > > May

Re: [web2py] Why won't my bootstrap modal form close?

2014-05-27 Thread Richard Vézina
when you modal is loaded in html do CTRL+U and copy/paste the source here... You don't need XML() for response.js Do you really test you modal as a component? response.js is only working in context of a component. Richard On Tue, May 27, 2014 at 2:09 PM, weheh wrote: > I forgot to mention t

[web2py] Re: Post Request Timeout

2014-05-27 Thread Dave S
On Thursday, May 22, 2014 1:44:52 PM UTC-7, Cory wrote: > > Hi, > I have a url that is supposed to receive a post request that contains xml. > This post request is a callback from an api. > For some reason the post request cannot connect to the url I have > specified. The view that is supposed

Re: [web2py] Why won't my bootstrap modal form close?

2014-05-27 Thread weheh
I forgot to mention that I also tried response.js = XML('$("#contact-dialog").modal("hide");') and this threw an internal server error, which surprised me a bit, since I've wrapped response.js statements with the XML helper before without incident. Here's the traceback: Traceback 1.

Re: [web2py] Database help

2014-05-27 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 27-05-2014 16:42, jimbo escreveu: > Newbie stuff. A few months ago I asked about using web2py to run a simple > internal database, with contact details such as tel number address etc. > Anthony > came up with a brilliant solution using just a few

[web2py] Re: Redirect to grid page

2014-05-27 Thread Tom Russell
Works great Jim, Thank you very much. On Tuesday, May 27, 2014 12:52:33 PM UTC-4, Jim S wrote: > > I would try something like this: > > rows_per_page = 20 # this should be set to whatever the 'paginate' > parm is set to on your call to SQLFORM.grid - default is 20 > page_number = int(query).c

[web2py] Re: Redirect to grid page

2014-05-27 Thread Jim S
I would try something like this: rows_per_page = 20 # this should be set to whatever the 'paginate' parm is set to on your call to SQLFORM.grid - default is 20 page_number = int(query).count() / rows_per_page ) + 1# 'query' should be the same query that you pass to SQLFORM.grid redirec

Re: [web2py] How to migrate to UUID references in db without messing up reference fields

2014-05-27 Thread Philip Kilner
Hi Ian, I've spent some time looking at available options, and I think I can solve my own issues without using UUIDs at all. I really wanted to continue to use integer IDs, partly because in some cases these fields are exposed to my users as order/document/transaction IDs. I also wanted to stay a

[web2py] Re: Redirect to grid page

2014-05-27 Thread Tom Russell
Jim, Yes I have a grid page in place which is where I go now. The grid though has a lot of records and I just want to go to that last record in that grid. Since its pagination thats what I am looking for, is how to go to the last page in the grid. On Tuesday, May 27, 2014 12:17:02 PM UTC-4, Ji

[web2py] Re: call java jar from web2py

2014-05-27 Thread Leonel Câmara
I guess you can try running web2py on jython (there was a new release recently) and then, if it works, it should be easy. You can also try jpype http://jpype.sourceforge.net/index.html What I would probably do is run a java application server and just have the java application communicating

[web2py] Re: Redirect to grid page

2014-05-27 Thread Jim S
When you say that you want to go to the 'grid' page, do you mean a page with a SQLFORM.grid on it and you want to go into 'edit' mode on a specific record on the grid? -Jim On Tuesday, May 27, 2014 10:42:31 AM UTC-5, Tom Russell wrote: > > I have a simple form where I have a submit button that

[web2py] call java jar from web2py

2014-05-27 Thread António Ramos
hello is there an easy way to have my web2py app call a class from a jar file? Regards António -- 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 receiv

Re: [web2py] Database help

2014-05-27 Thread Richard Vézina
Would help to know what you want to stored (the other columns) and what you model so far... Richard On Tue, May 27, 2014 at 11:42 AM, jimbo wrote: > Newbie stuff. A few months ago I asked about using web2py to run a simple > internal database, with contact details such as tel number address et

[web2py] Database help

2014-05-27 Thread jimbo
Newbie stuff. A few months ago I asked about using web2py to run a simple internal database, with contact details such as tel number address etc. Anthony came up with a brilliant solution using just a few lines of code, this has worked very well. Now the database has grown, that is it/they hav

[web2py] Redirect to grid page

2014-05-27 Thread Tom Russell
I have a simple form where I have a submit button that runs some code. After the code runs and the data is inserted into my table I do a simple redirect like so: redirect(URL('voltrin_data')) That just goes to a page I have set up with a grid. I notice if I am editing a record and press submit

Re: [web2py] Why won't my bootstrap modal form close?

2014-05-27 Thread Richard Vézina
You could try with plain HTML instead of using helper... XML("""PLAIN HTML MODAL""") Just to make sure that it works... I suspect that the modal is not construct exactly as it should... Richard On Tue, May 27, 2014 at 10:27 AM, weheh wrote: > Richard - Thanks, but that is exactly what I'm u

Re: [web2py] Why won't my bootstrap modal form close?

2014-05-27 Thread weheh
Richard - Thanks, but that is exactly what I'm using: response.js = $("#contact-dialog").modal("hide"); and it's not working. The function wrapper was an act of desperation but it doesn't work either. On Tuesday, May 27, 2014 9:56:32 PM UTC+8, Richard wrote: > > I think you just need : $("#contac

Re: [web2py] Why won't my bootstrap modal form close?

2014-05-27 Thread Richard Vézina
This may help also : http://linuxapuntes.blogspot.com.ar/2013/03/plugin-modal-bootstrap-web2py.html On Tue, May 27, 2014 at 9:56 AM, Richard Vézina wrote: > I think you just need : $("#contact-dialog").modal("hide"); > > Instead of : > > (function() {$("#contact-dialog").modal("hide");})(); > >

Re: [web2py] Why won't my bootstrap modal form close?

2014-05-27 Thread Richard Vézina
I think you just need : $("#contact-dialog").modal("hide"); Instead of : (function() {$("#contact-dialog").modal("hide");})(); Since you don't need to check if document is ready... But if you want to keep it I guess you miss a $ *$*(function() {$("#contact-dialog").modal("hide");}); Not sure

[web2py] Re: how to modify form input before validation and insert into database?

2014-05-27 Thread Anthony
You could modify request.post_vars before creating the form, or create a custom validator for the relevant field(s). No need to use SQLFORM.factory. Anthony On Monday, May 26, 2014 5:26:15 PM UTC-4, chuan137 wrote: > > I want to replace white spaces with underscore and capitialize each word > b

[web2py] Re: global name 'db' is not defined

2014-05-27 Thread Anthony
On Tuesday, May 27, 2014 8:09:43 AM UTC-4, Henrik Holm wrote: > > Anthony, > > Not sure really - I was wondering if there might be a way to specify the > order of which the files would be executed. > I suppose we could add a setting that allows you to specify model order, though for backward com

[web2py] problrm in smart sql grid

2014-05-27 Thread Raj
Hi Web2py User i am using smart sql grid. i am trying to take value from drop down. according to that i am fetching data in grid. my grid is working fine but when ever i click on edit view buttons. i will not work as it should to be bork. it refress the same page. plese my code below view

[web2py] Re: global name 'db' is not defined

2014-05-27 Thread Henrik Holm
On Thursday, May 22, 2014 8:41:16 PM UTC-4, Dave S wrote: > On Thursday, May 22, 2014 12:53:34 PM UTC-7, Derek wrote: > >> rename db.py to 0.py. it doesn't have to be named db.py. >> > > Isn't that the same sort of "kludge" as application.py ---> > x_application.py? > Somehow this feels less "k

[web2py] 2.9.5 crashes @ startup

2014-05-27 Thread Dick Schrauwen
OS: win vista web2py 295 Starting up by double-click: won't run >From commandline gives: C:\PROJ-new\web2py295>cd web2py C:\PROJ-new\web2py295\web2py>web2py.exe Traceback (most recent call last): File "", line 6, in File "__main__.py", line 128, in File "__main__web2py__.py", line 18, in

[web2py] Re: global name 'db' is not defined

2014-05-27 Thread Henrik Holm
Anthony, Not sure really - I was wondering if there might be a way to specify the order of which the files would be executed. Henrik On Thursday, May 22, 2014 8:50:39 PM UTC-4, Anthony wrote: > > For now I have renamed the file to x_application.py, but this seems like >> kind of a kludge. Is

Re: [web2py] Re: AWS Elastic Beanstalk installation Recipe

2014-05-27 Thread Diogo Munaro
Thx massimo... I will plain a deploy structure and then I'll post here. Perhaps web2py migration just need read database structure and view diff between database structure and model structure. Have you thought about that? It sound great for deploy! Couldn't be? 2014-05-27 1:26 GMT-03:00 Massimo

[web2py] Re: json query

2014-05-27 Thread Anthony
I'm not sure if the DAL includes any code to de-code JSON queries, but I found this web2py slice written around the same time that Query.as_json was added to the DAL: http://www.web2pyslices.com/slice/show/1593/class-for-building-db-queries-from-python-dictionaries Anthony On Tuesday, May 27,

[web2py] contact importer

2014-05-27 Thread Leonel Câmara
I'm in the process of implementing "invite contacts" functionality for one of my projects. I'm wondering if anyone has integrated something like: https://github.com/mengu/contact_importer with web2py. I'm also interested in whatever solutions you guys are using as I'm not keen on reinventing th

Re: [web2py] Re: Error message: function not callable.

2014-05-27 Thread Maurice Waka
Thanks. I got the solution...as you said. it should be : test.test() What I did, in the controller: from applications.x.x import test def display_test(); result = test.test() return locals HTML view {{extend 'layout.html'}} {{=result}} On Mon, May 26, 2014 at 4:47 PM, Anthony wrote: > "tes

Re: [web2py] Re: There were changes in MS SQLServer driver?

2014-05-27 Thread Nguyen Minh Tuan
Thanks Derek! On 24 May 2014 00:55, Derek wrote: > if you read the whole thing, he changed the way it works. > > db = DAL('mssql://dsn=192.168.0.52;user=usr1;password=pwd1;') > > hint: You have to use DBAPI 2.0 connection strings. > > http://legacy.python.org/dev/peps/pep-0249/#footnotes > > On

[web2py] json query

2014-05-27 Thread Manuele Pesenti
Hi! Looking in the code[1] I noticed that it's possible to serialize Query object into json string... how can I rebuild the query object server side? Thank you very mutch M. [1] https://github.com/web2py/web2py/blob/master/gluon/dal.py#L10430 -- Resources: - http://web2py.com - http://web2

[web2py] Re: Verify password does not fit formstyle

2014-05-27 Thread Annet
Hi Jaime, Could you copy and past all your definition of def bootstrap3(form, fields) > ? > This is my bootstrap3 function. def bootstrap3(form, fields): parent = FIELDSET() for id, label, controls, help in fields: if not help: _help = '' else:

Re: [web2py] how to modify form input before validation and insert into database?

2014-05-27 Thread Johann Spies
On 26 May 2014 23:26, chuan137 wrote: I want to replace white spaces with underscore and capitialize each word > before insert them into database. I am using SQLFORM(...) and I find > onvalidation is used after validation. > > but I want to use this field as a unique keyword, which used in query

Re: [web2py] Internal error - after setting up the existing application on new web2py system

2014-05-27 Thread Johann Spies
On 24 May 2014 08:36, Nishmita Singhla wrote: Hey Fellow programmers, > > *Ticket ID* > > 127.0.0.1.2014-05-24.11-24-31.e7ecce1d-a357-4b8f-b912-1eb609468d81 'exceptions.RuntimeError'> Failure to connect, tried 5 times: Traceback (most > recent call last): File "/home/mdipierro/make_web2py/web2py