[web2py] Re: Problem with oracle query

2020-01-14 Thread 'tomt' via web2py-users
Thanks for posting your solution. I ran into the same problem and probably wouldn't have figured it out without your post. - Tom On Monday, April 15, 2019 at 5:20:36 AM UTC-6, gliporace wrote: > > I think I found the problem: > the query is sent with the table name double-quoted: > > select

[web2py] Re: Web2Py and ldap integration

2019-07-31 Thread 'tomt' via web2py-users
I have used ldap_auth successfully by implementing the following in models/db.py: from gluon.contrib.login_methods.ldap_auth import ldap_auth ... db = DAL('mysql://mydb:mydb@localhost/password') ... # --- end of web2py scaffolding ---

[web2py] Re: please help testing web3py

2019-07-28 Thread 'tomt' via web2py-users
I installed py4web on centos 7 in a virtual python environment and it works fine. http://127.0.0.1:8000/_dashboard works as advertised, however http://localhost:8000/_dashboard doesn't. When using localhost, the dashboard page comes up, but it won't display any of the installed applications or

[web2py] RSA Securid integration with web2py

2018-04-25 Thread 'tomt' via web2py-users
Hi, Has anyone integrated web2py authentication with RSA Securid? If you have, I'd appreciate it if you could share the steps you took. - Thanks in advance, - Tom -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: How can I access functions from multiple files in the controllers directory?

2016-11-03 Thread 'tomt' via web2py-users
Hi, Thanks for your reply. I tried using modules as you suggested. It works great for simple python functions, but when I try to use DAL it dies. It appears that functions in modules aren't aware of the model definitions. Chapter 4 of the manual indicates that I could probably do this by

[web2py] How can I access functions from multiple files in the controllers directory?

2016-11-01 Thread 'tomt' via web2py-users
Hi, In the controllers directory I wanted to define some functions in another file. I had hoped to import the functions to make them available to default.py but I haven't been able to get this to work. I'm hoping that someone can point out my error, and possibly a solution. In the controllers

[web2py] Re: Code change in oracle.py to allow joins in pagination.

2016-10-27 Thread 'tomt' via web2py-users
Tom On Monday, October 3, 2016 at 1:29:59 PM UTC-6, Massimo Di Pierro wrote: > > Sorry the patch does not work with the latest pydal/adapters/oracle.py. > Can I ask you to resubmit it? > > On Sunday, 25 September 2016 20:24:48 UTC-5, tomt wrote: >> >> Hi, I've attached t

[web2py] Re: Code change in oracle.py to allow joins in pagination.

2016-09-25 Thread 'tomt' via web2py-users
19:46:34 UTC-5, tomt wrote: >> >> I'd be happy to give it a try, but I'm not sure what steps to take. When >>> I go to github and click on create new pull request it appears I have to >>> select a branch to compare to. I'm uncertain if I am supposed to select >&

[web2py] Re: Code change in oracle.py to allow joins in pagination.

2016-09-23 Thread 'tomt' via web2py-users
> > I'd be happy to give it a try, but I'm not sure what steps to take. When > I go to github and click on create new pull request it appears I have to > select a branch to compare to. I'm uncertain if I am supposed to select > admin, experimental, or enter a value of my own. Does web2py

[web2py] Code change in oracle.py to allow joins in pagination.

2016-09-10 Thread 'tomt' via web2py-users
Hello, I have patched the select_limitby routine in oracle.py to allow for successful pagination when joins are used. This is an example of the sql it generates: SELECT c0 "STATUSPOINT.POINTNUMBER", c1 "STATUSPOINT.POINTNAME", c2 "AOR.REFERENCENAME", c3 "AOR.AOR" FROM ( SELECT w_tmp.c0,

[web2py] Re: SQLFORM.grid problems with Oracle database tables

2016-09-06 Thread 'tomt' via web2py-users
Nico, Thanks for your response. The tables were already joined in the query definition inside the controller. query = ((db2.STATUSPOINT.POINTNUMBER < 100)&\ (db2.STATUSPOINT.POINTACCESSAREA == db2.AOR.AOR)) I feel quite certain that the problem is associated with the extra SQL

[web2py] SQLFORM.grid problems with Oracle database tables

2016-09-05 Thread 'tomt' via web2py-users
Hi, I have been using SQLFORM.grid to display some legacy Oracle tables. While it works fine when the query is for a single table, as soon as the query involves a join between two tables the grid returns multiple duplicate entries. (I'm using web2py 2.13.4-) The result looks like this:

[web2py] Re: Oracle perfomance issues with version 2.12.3

2015-11-10 Thread 'tomt' via web2py-users
issue. If you don't find a performance issue on pydal, then there should be > something in the SQLFORM.grid part. > > Paolo > > On Sunday, November 8, 2015 at 6:16:31 AM UTC+1, tomt wrote: >> >> Hi, >> >> I encountered really slow responses when I was using

[web2py] dbstats with oracle doesn't show sql selects or timing

2015-11-07 Thread 'tomt' via web2py-users
Hi, I'm using web2py 2.12.3 connecting to oracle 10.2 I tried to use the dbstat function of {{=response.toolbar()}} to examine database performance, but the sql select and its timing isn't printed. This feature works as expected when I'm connecting to a mysql database. Is this a bug, or just

[web2py] Oracle perfomance issues with version 2.12.3

2015-11-07 Thread 'tomt' via web2py-users
Hi, I encountered really slow responses when I was using my web2py app to access an oracle database. I tried to use dbstats in response.toolbar to measure this, but it wouldn't show the sql or any timing information. I decided to try downgrading to an older web2py version, 2.11.2, and

[web2py] Re: what are the12 core objects

2014-07-02 Thread 'tomt' via web2py-users
- thanks for the response -- 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] what are the12 core objects

2014-07-01 Thread 'tomt' via web2py-users
The preface says that the API includes just 12 core objects What are they? - Thanks in advance -- 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

[web2py] Can I temporarily disable record_versioning?

2013-10-25 Thread tomt
Hi, I appreciate the db.table._enable_record_versioning() capability provided by web2py, but there are some occasions when I'd like to modify a table that has record versioning implemented and not modify the archive. Is there some way that I can temporarily disable record versioning? I guess I

[web2py] Re: SQLFORM.grid: how can I return to a page after a custom edit function

2013-09-22 Thread tomt
-6, tomt wrote: Hi, I'm looking for suggestions or examples on how I can implement a custom edit function for SQLFORM.grid that will remember the page it was called from, and return to it once the editing is complete. I was able to call the custom edit function easily enough by using

[web2py] SQLFORM.grid: how can I return to a page after a custom edit function

2013-09-18 Thread tomt
Hi, I'm looking for suggestions or examples on how I can implement a custom edit function for SQLFORM.grid that will remember the page it was called from, and return to it once the editing is complete. I was able to call the custom edit function easily enough by using the 'links' parameter

Re: [web2py] Re: web2py 2.6.1 is OUT - IMPORTANT READ

2013-09-14 Thread tomt
Hi, I am getting a mysql error after upgrading to 2.6.1(and 2.6.2) Web2py doesn't throw a ticket, rather the mysql error shows up directly on the browser: Query Not Supported: (1064, uYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the

[web2py] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

2013-09-08 Thread tomt
Simon, I wanted to thank you for the answer you posted. As a casual user of web2py, I would have never figured this out on my own, but your clear example showing db, controller and view made it easy for me to understand and to implement. It would be great if the experienced users of web2py would

[web2py] Question about using _enable_record_versioning to another database

2013-07-20 Thread tomt
It appears that if I use _enable_record_versioning to archive a table to another database, then that database must have an auth_user table. Is there any way to archive a table to another database and have it refer to the auth_user table in the local database? # local database db =

[web2py] Re: Use model in another app

2013-07-04 Thread tomt
Occasionally I have written a web2py app that makes use of a model/db from another app. Basically, all that I do is define additional database connections in models/db.py to the old app, and redeclare all the table definitions. I attempt to prevent accidental structure changes to the external

[web2py] Re: Help on fake_migration

2013-04-05 Thread tomt
I migrate applications fairly often, and using fake_migrate_all works best for me: db = DAL(...,fake_migrate_all=True) On Friday, April 5, 2013 5:24:33 PM UTC-6, Tito Garrido wrote: Hi Folks! I am trying to migrate my web2py application from one server to another. I have pack my

[web2py] Re: problem with latest trunk SQLFORM.grid

2012-12-14 Thread tomt
so it is always visible (when it properly parse the arguments). I am missing something? On Monday, 10 December 2012 21:48:09 UTC-6, tomt wrote: I simplified the controller to better understand the problem I'm seeing. def test(): id = 2 query = (db.staffnotes.staffid == id

[web2py] Re: problem with latest trunk SQLFORM.grid

2012-12-10 Thread tomt
:21:29 AM UTC-6, Massimo Di Pierro wrote: Are you logged in when you try accessing the grid? Do you get a not authorized when trying to visualize the grid or when searching or when visualizing a record? Massimo On Sunday, 9 December 2012 19:23:20 UTC-6, tomt wrote: Hi, Recent changes

[web2py] Re: problem with latest trunk SQLFORM.grid

2012-12-10 Thread tomt
UTC-6, tomt wrote: Yes, I am logged in. On the initial call of the controller the grid is displayed without and error. When I select a new value from the dropdown form, a new query is used and passed to SQLFORM.grid, and this is when the 'not authorized' flash is generated

[web2py] Re: SQLFORM.grid: search and links

2012-12-07 Thread tomt
I would also like to be able to change the position of the 'links' column. I see that your post didn't receive any answers. Did you figure out how to do this? If you did, I would appreciate if you could tell me how. - Tom On Sunday, January 29, 2012 4:33:21 PM UTC-6, backseat wrote: I've a

[web2py] Re: SQLFORM.grid: search and links

2012-12-07 Thread tomt
='left' which results in the 'links' column appearing on the first column. Great, problem solved. On Friday, December 7, 2012 10:02:53 PM UTC-6, tomt wrote: I would also like to be able to change the position of the 'links' column. I see that your post didn't receive any answers. Did you figure

Re: [web2py] Re: powerTable AttributeError: 'DAL' object has no attribute 'virtual'

2012-11-23 Thread tomt
giorno venerdì 23 novembre 2012 20:44:02 UTC+1, palomar ha scritto: i think response.files.append(URL(r=request,c='static',f='plugin_powertable/ui/css/%s/jquery-ui-1.8.24.custom.js')) ;) Il giorno giovedì 18 ottobre 2012 06:06:33 UTC+2, tomt ha scritto: After a little digging around on the web

[web2py] Record versioning

2012-10-23 Thread tomt
Hi, I'm using auth.signature and db.my_table._enable_record_versioning() to enable record versioning on a table. db.define_table('mytable', Field('staffid','string'), Field('date','datetime',requires=IS_DATETIME(format='%Y-%m-%d %H:%M:%S'), default=request.now),

Re: [web2py] Re: powerTable AttributeError: 'DAL' object has no attribute 'virtual'

2012-10-17 Thread tomt
are gone and now powertable works with no problems. On Sunday, October 14, 2012 9:10:17 PM UTC-6, tomt wrote: I noticed another problem with powertable and web2py 2.0.9 When I created a new app under web2py 2.0.9 and tried to implement a powertable it exhibited some unusual behaviour

Re: [web2py] Re: powerTable AttributeError: 'DAL' object has no attribute 'virtual'

2012-10-14 Thread tomt
I noticed another problem with powertable and web2py 2.0.9 When I created a new app under web2py 2.0.9 and tried to implement a powertable it exhibited some unusual behaviour. On initial callup, the powertable showed all records instead of the number specified by iDisplayLength and the columns

[web2py] Re: powerTable AttributeError: 'DAL' object has no attribute 'virtual'

2012-10-08 Thread tomt
Thanks to everybody for fixing this! You might also want to make a similar change at about line 244: try: field = sqlrows.db[tablename][fieldname] # except KeyError: except (KeyError,AttributeError): field =

Re: [web2py] Re: powerTable AttributeError: 'DAL' object has no attribute 'virtual'

2012-10-02 Thread tomt
I also have been having the same issue. I'm running web2py 2.0.9 I only have one db = DAL statement. All of my DAL is in models/db.py. I don't have any files in the modules directory. I haven't specifically stored a rows object in session, although the controller does have a couple of the

[web2py] Re: Question on using legacy tables

2012-07-25 Thread tomt
? On Tuesday, 24 July 2012 23:28:29 UTC-5, tomt wrote: I use several legacy tables in my web2py applications A typical definition that I use is: db2.define_table('analogpoint', Field('pointnumber','integer',writable=False), Field('pointname','string',writable=False), primarykey

[web2py] Re: Question on using legacy tables

2012-07-25 Thread tomt
wrote: There is a solution in trunk. Please give it a try. On Wednesday, 25 July 2012 20:36:07 UTC-5, tomt wrote: Hi, I was using a version of trunk. I downloaded today's version and got the same error. I opened a ticket as suggested. (Issue 908) On Wednesday, July 25, 2012 7:38:47 AM UTC

[web2py] Re: Question on using legacy tables

2012-07-25 Thread tomt
More good news. I discovered that this fix now allows me to use SQLFORM.grid on legacy tables that don't have an 'id' field! On Wednesday, July 25, 2012 9:10:38 PM UTC-6, tomt wrote: I tried the latest trunk, and it solves the problem I described. This is great and it will make it much

[web2py] Question on using legacy tables

2012-07-24 Thread tomt
I use several legacy tables in my web2py applications A typical definition that I use is: db2.define_table('analogpoint', Field('pointnumber','integer',writable=False), Field('pointname','string',writable=False), primarykey=['pointnumber'], migrate=False ) I can access this

[web2py] Re: confused with install on centos 5.7

2012-05-24 Thread tomt
I installed web2py with mod_wsgi on centos 5.2. I haven't used it extensively, but I did get it to work for a couple of my web2py applications. Instead of running the install script, I manually implemented most of the steps from the setup-web2py-fedora.sh script. The following is a record of

[web2py] Re: confused with install on centos 5.7

2012-05-24 Thread tomt
I installed web2py with mod_wsgi on centos 5.2. I haven't used it extensively, but I did get it to work for a couple of my web2py applications. Instead of running the install script, I manually implemented most of the steps from the setup-web2py-fedora.sh script. I have selinux disabled in this

[web2py] bootstrap css problem

2012-04-25 Thread tomt
Hi, I just tried bootstrap.min.css in trunk. I noticed one small problem. The buttons on SQLFORM.grid no longer show up, instead I get links for add, edit, and delete. The html generated for the add is: span class=buttontext button title=AddAdd/span My previous code generated the same html,

[web2py] Re: new feature in trunk: full auditing

2012-04-14 Thread tomt
. Thanks to all the developers for all these improvements. - Tom On Friday, April 13, 2012 10:53:10 PM UTC-6, tomt wrote: I'm have been trying to test this new audit function in trunk, but so far the mything_archive table has never been created in any of my tests. Is this the current state

[web2py] Re: new feature in trunk: full auditing

2012-04-13 Thread tomt
I'm have been trying to test this new audit function in trunk, but so far the mything_archive table has never been created in any of my tests. Is this the current state of the implementation, or am I missing something? I downloaded the latest trunk and used it web2py admin to create a new app.

[web2py] Re: new feature in trunk: full auditing

2012-04-09 Thread tomt
, tomt wrote: Hi, Thanks for your response. I deleted the database as you suggested and changed signature=False. The problem did go away and I was able to add users without the error. I then reverted to signature=True. While subsequent modifications did show the signature

[web2py] Re: new feature in trunk: full auditing

2012-04-08 Thread tomt
the self reference in auth_user. On Saturday, 7 April 2012 22:09:31 UTC-5, tomt wrote: Hi, I tried using your new versioning feature in trunk. I created an app using a mysql database: db = DAL('mysql://version:version@localhost/version') When I used the admin function to define a new user I

[web2py] Re: new feature in trunk: full auditing

2012-04-07 Thread tomt
Hi, I tried using your new versioning feature in trunk. I created an app using a mysql database: db = DAL('mysql://version:version@localhost/version') When I used the admin function to define a new user I received the following error: class

[web2py] Re: Smarttable SQLFORM.grid

2012-03-28 Thread tomt
You may be thinking of 'powertable'. This plugin presents a grid that includes a typeahead search function. It can be found at https://bitbucket.org/rochacbruno/powertable. - Tom On Monday, March 26, 2012 2:24:42 PM UTC-6, greenpoise wrote: What I was looking for was a type-ahead function

[web2py] Re: TNS error on Oracle

2012-03-06 Thread tomt
to what you reported: Traceback (most recent call last): File /home/tomt/web2py/gluon/restricted.py, line 194, in restricted exec ccode in environment File /home/tomt/web2py/applications/scadadb/models/db.py, line 17, in module db = DAL('oracle://user/password@server:port/service_name

[web2py] Re: web2py 1.99.5 is OUT

2012-03-01 Thread tomt
Hi, I just installed 1.99.5. Clicking on the database administration button doesn't bring up the usual database administration form. Instead it brings up http://127.0.0.1:8000/admin/default/site. (The link value for the button is http://127.0.0.1:8000/app1/appadmin/index) On Mar 1, 5:28 pm,

[web2py] Re: how to deploy web2py not in the apache root (help with url rewriting)

2012-02-08 Thread tomt
Hi, I have had some success using wsgi on a fedora system by installing the following config file in /etc/httpd/conf.d . It's basically the config from the online manual with rewrite rules taken from the user group. I have two applications, 'cpa4' and 'master' that are accessed with

[web2py] How can I use an alternate(non-root) directory in a production deployment?

2012-01-12 Thread tomt
I followed the manual's instruction for deploying web2py in a production environment using apache and wsgi, and it works as advertised. Calling http://domain.com/app1/default/function works just like it did when I ran the rocket server from the command line. I really want web2py to run from a

[web2py] Re: Access remote oracle database

2011-11-24 Thread tomt
Do you have the oracle client installed on your web2py machine? If you do, you should be able to test the connection to oracle with 'sqlplus database/password'. oracle-instantclient is available for free from www.oracle.com/technetwork/index.html. I'm using this on my linux machine to access a

[web2py] Re: help please on adding jquery-ui theme to SQLFORM.grid

2011-11-14 Thread tomt
(or in your layout.html file if needed on most/all pages). Anthony On Sunday, November 13, 2011 9:45:45 PM UTC-5, tomt wrote: Hi, I'm looking for an example of how to install and use a jquery theme for SQLFORM.grid I see that I can implement jquery-ui by defining: form = SQLFORM.grid

[web2py] help please on adding jquery-ui theme to SQLFORM.grid

2011-11-13 Thread tomt
Hi, I'm looking for an example of how to install and use a jquery theme for SQLFORM.grid I see that I can implement jquery-ui by defining: form = SQLFORM.grid(query=db.table.field=='3',ui='jquery-ui') I see that I can download a theme from http://jqueryui.com/download but I don't know where to

[web2py] help on howto redirect user based on their auth_membership

2011-11-10 Thread tomt
Hi, Is there a way to redirect a user to a specific controller based on their auth_group.role and/or auth_membership? I would like a view only user to be redirected to one controller after login, and a supervisor user go to a different controller after login. Any suggestions? Thanks, - Tom

[web2py] Re: Please help me understand how 'lambda row, rc' works

2011-11-06 Thread tomt
On Nov 6, 6:42 am, Stefaan Himpe stefaan.hi...@gmail.com wrote: tomt wrote: I wanted to implement the 'extracolumns' feature of SQLTABLE and the example provided in the source code is:      :param extracolums = [{'label':A('Extra',_href='#'),                      'class': '', #class name

[web2py] Please help me understand how 'lambda row, rc' works

2011-11-05 Thread tomt
I wanted to implement the 'extracolumns' feature of SQLTABLE and the example provided in the source code is: :param extracolums = [{'label':A('Extra',_href='#'), 'class': '', #class name of the header 'width':'', #width in pixels or %

[web2py] Re: table without id

2011-10-11 Thread tomt
Hi, I have been able to access legacy databases that don't have an id field. In the following example 'pointnumber' is the primary key, and is unique. I was able to read values from this table with DAL. I used the following model: db2.define_table('statuspoint',

[web2py] Question about SQLFORM.grid and legacy tables

2011-09-22 Thread tomt
Hi, I was wondering if SQLFORM.grid can be used to display legacy tables that don't contain a field called 'id', and if so, how? I have this table definition: db2.define_table('statuspoint', Field('pointnumber','integer'), Field('pointname','string'), Field('station','integer'),

[web2py] Re: How to use SQLFORM.grid

2011-09-21 Thread tomt
Hi, Can SQLFORM.grid be used to display legacy tables, specifically a table that doesn't have a field named 'id', and if so, how? The following is an example of a table I'm currently using in the latest trunk. Dbadmin displays it successfully, but web2py throws an exception when I try to

[web2py] Re: History tables how?

2011-09-19 Thread tomt
you can do form=SQLFORM() if form.accepts(request,session):       crud.archive(form) With trunk: form=SQLFORM() if form.process(onsuccess=auth.archive).accepted: ... onsuccess not onaccept On Sep 18, 10:46 pm, tomt tom_tren...@yahoo.com wrote: Massimo, Thanks for the quick

[web2py] Re: History tables how?

2011-09-18 Thread tomt
Hi, Could you please elaborate on this a bit? Does this capability exist in 1.98.2? I couldn't find any documentation on it. Do I have to write some additional code to make this work? If I implement your example literally: form=SQLFORM(db.things,row).process(onaccept=auth.archive) The error

[web2py] Re: History tables how?

2011-09-18 Thread tomt
, tomt tom_tren...@yahoo.com wrote: Hi, Could you please elaborate on this a bit? Does this capability exist in 1.98.2?  I couldn't find any documentation on it.  Do I have to write some additional code to make this work?  If I implement your example literally: form=SQLFORM

[web2py] Re: The web2py grid/crud plugin you've always dreamed about!

2011-09-17 Thread tomt
Hi, I have a question about using powertable. When I try to build a powertable on the following select: tasks=db(db.task.cpaid==3).select(db.task.cpa,db.task.description,db.task.ls_js) I get the following error: File /home/xa21/workspace/web2py/applications/cpa4/models/ plugin_powertable.py,

[web2py] Re: New Plugin: plugin_ckeditor

2011-09-13 Thread tomt
3, 10:12 pm, tomt tom_tren...@yahoo.com wrote: Hi, Doesplugin_ckeditorwork with internet explorer? It works great with firefox, but I have problems using it with IE. When I call up the application with IE8 like this:http://server:8000/application/default/editthis   The text area doesn't

[web2py] Re: Published my collection of plugins

2011-09-04 Thread tomt
of Field, as in SQLTABLE: db.status_info.description.represent = lambda v: XML(v) On 9月4日, 午後12:38, tomt tom_tren...@yahoo.com wrote: Kenji, Thanks for contributing your great plugins.  I've started to use solidtable and solidform and I expect that I will use them a lot because they really

[web2py] Re: Published my collection of plugins

2011-09-03 Thread tomt
Kenji, Thanks for contributing your great plugins. I've started to use solidtable and solidform and I expect that I will use them a lot because they really improve the look and usability of the web2py apps I've been working on. I was wondering if solidtables has a formatting option that will

[web2py] Re: New Plugin: plugin_ckeditor

2011-09-03 Thread tomt
Hi, Does plugin_ckeditor work with internet explorer? It works great with firefox, but I have problems using it with IE. When I call up the application with IE8 like this: http://server:8000/application/default/editthis The text area doesn't load the ckeditor Surprisingly, when I call it

[web2py] Re: Published my collection of plugins

2011-08-30 Thread tomt
, since the version 1.3 had a serious IE problem, I applied some patches for it. I also slightly modified the plugin css not to conflict with the site css. (https://github.com/kenji4569/sqlabs/issues/39) Kenji On 8月30日, 午前11:38, tomt tom_tren...@yahoo.com wrote: Hi, Thanks

[web2py] Re: Published my collection of plugins

2011-08-29 Thread tomt
Hi, Thanks for the great contributions to web2py. I'm looking forward to trying them. I implemented web2py.plugin.elrte_widget.w2p and while it worked great with firefox, I had some problems using internet explorer. Specifically, the dropdown boxes, such as the colorpicker, disappear before I

[web2py] Re: New Plugin: plugin_ckeditor

2011-08-26 Thread tomt
FYI: I ran into a problem using plugin_ckeditor when running web2py on python 2.5.2. It generates an error associated with modules/ plugin_ckeditor.py at line 44: 43 *self.settings.extra_fields.get(upload_name, []), 44 migrate = migrate, When I upgraded python to 2.7.2 everything worked as

[web2py] Problem with Oracle access and web2py database administration

2011-08-23 Thread tomt
I recently tried to access some legacy tables in an Oracle database with web2py. The connection string and model I generated in db.py allows successful connection and queries from the command line are successful, when I try to use the web2py database administration function I get the following

[web2py] Re: New Plugin: plugin_ckeditor

2011-08-05 Thread tomt
Hi, I was having trouble editing existing data with web2py_ckeditor until I applied Bruno's patch. Before applying this patch, the plugin could save new data, but it wouldn't edit existing data. It always started with an empty textarea. Now it works as I would expect. (I'm using web2py Version

[web2py] Re: The web2py grid/crud plugin you've always dreamed about!

2011-07-24 Thread tomt
'by' in db.py db.define_table('comments',Field('by'),Field('comment','text')) 'by' is listed as a reserved word in mysql and sqlite, so I assume that's the problem. Anyways, with these changes everything is working fine now. Thanks - Tom On Jul 23, 10:02 pm, tomt tom_tren...@yahoo.com wrote: Bruno, Thanks

[web2py] Howto prepopulate a sqlform's drop-down field

2011-06-10 Thread tomt
Hi, I've written a controller to add a record using sqlform, and I want to prepopulate several of the fields. I've had some success using form.var.field = x, but I haven't been able to prepopulate the one field that uses a dropdown list. In the controller I listed below, I have success on the

[web2py] Re: Howto prepopulate a sqlform's drop-down field

2011-06-10 Thread tomt
. Sorry for the wasted post... On Jun 10, 8:05 pm, tomt tom_tren...@yahoo.com wrote: Hi, I've written a controller to add a record using sqlform, and I want to prepopulate several of the fields.  I've had some success using form.var.field = x, but I haven't been able to prepopulate the one field

[web2py] Re: powertable question about bStateSave

2011-04-12 Thread tomt
/rochacbruno] On Thu, Apr 7, 2011 at 12:49 AM, tomt tom_tren...@yahoo.com wrote: Hi, I'm using powertable and set table.dtfeatures['bStateSave'] = True The search parameters are saved successfully, but the page position is not being restored. The cookie created by powertable saves iStart

[web2py] Re: powertable question about bStateSave

2011-04-12 Thread tomt
Whoops, I made a mistake. Page position is lost when: table.showkeycolumn = False but the solution is the same... fnDraw(false) On Apr 12, 8:02 pm, tomt tom_tren...@yahoo.com wrote: Hi, I discovered why pagination is lost.  When table.showkeycolumn = true then at line 733 hidekeycolumnjs

[web2py] powertable question about bStateSave

2011-04-06 Thread tomt
Hi, I'm using powertable and set table.dtfeatures['bStateSave'] = True The search parameters are saved successfully, but the page position is not being restored. The cookie created by powertable saves iStart and iEnd but they don't appear to be used. I looked at the plugin_powertable.py code,

[web2py] Re: New Widget and Slice - SELECT_OR_ADD_OPTION

2011-02-20 Thread tomt
I just tried your widget and it's a great idea. I was wondering if this concept could be expanded to allow a user to edit a record with a similar popup dialog. At first glance it seems that this might be possible, but I don't understand your code well enough to say for sure. A second question,

[web2py] Re: powertable: howto adjust table width

2011-02-15 Thread tomt
Thanks, This worked nicely. On Feb 15, 8:24 am, Bruno Rocha rochacbr...@gmail.com wrote: Now I tested here and works. - {{extend 'layout.html'}} style .tablewrapper{  width:400px !important;} /style div class='tablewrapper' {{=table}} /div

[web2py] Re: powertable: howto adjust table width

2011-02-14 Thread tomt
Thanks for the response, but I had limited success. I can control the width of the scroll area, but not the header or trailer. I used the following options: table = plugins.powerTable ... table.dtfeatures['bAutoWidth'] = False table._width='700' (I wasn't quite sure what you

[web2py] Question about powertable error

2011-02-13 Thread tomt
Hi, I am using powertable to display a subset of a table's rows: ... id=request.args(0) tasks=db(db.task.cparef==id).select(db.task.ALL) table = plugins.powerTable table.datasource = tasks ... This works just fine, but when I try to specify the columns table.columns =

[web2py] Re: Question about powertable error

2011-02-13 Thread tomt
13, 3:57 pm, Bruno Rocha rochacbr...@gmail.com wrote: 2011/2/13 tomt tom_tren...@yahoo.com  table.columns = ['tasks.title'] Try with:   table.columns = ['task.title'] where 'task' is the name of the table, 'title' the name of the field.

[web2py] powertable: howto adjust table width

2011-02-13 Thread tomt
Hello, I would like to be able to change the width of the powertable output. It seems to be set at a fixed value. I was able to influence the column width by setting .dtfeatures['bAutoWidth'] = False but the header and trailer remain the same width. Is this controlled by an option? Is it set

[web2py] Re: testing ldap communication?

2011-02-12 Thread tomt
When I tried to get ldap_auth working I used wireshark to look at the protocol exchange. I was able to see that I had the ou set incorrectly and when corrected the authentication worked perfectly. ... some changes I made to db.py . from gluon.contrib.login_methods.ldap_auth import

[web2py] Can I share web2py authorization db across multiple apps

2011-01-25 Thread tomt
Hi, I have been building several small web2py apps and I was hoping that there was a way of sharing the authorization information among these apps. Currently each app I create has it's own set of auth_ tables requiring users to register for each app. It would be a great time- saver if these

[web2py] looking for advice on validation

2011-01-16 Thread tomt
Hi, I have learned to use SQLFORM to generate forms. The validation defined in the db model works as expected, but there are times when I want to write a controller that uses a different validation than what is defined in the model. (Specifically, I want to force a different date validation)

[web2py] Re: Powertable remarks

2011-01-01 Thread tomt
Hello, In-line editing is listed as a feature of powertable. Would it be possible for you to include a working example of this in your demo? Thanks, - Tom On Dec 29 2010, 9:49 pm, Bruno Rocha rochacbr...@gmail.com wrote: Here is a complete list of working powerTable

[web2py] Re: Powertable remarks

2010-12-29 Thread tomt
/12/2010, às 02:49, tomt tom_tren...@yahoo.com escreveu: Hi Bruno, I've just tried using your powertables plugin and I love it. The general appearance is great and the default search function is exactly what I was looking for.  I'm looking forward to trying out the features you've

[web2py] Re: Powertable remarks

2010-12-28 Thread tomt
Hi Bruno, I've just tried using your powertables plugin and I love it. The general appearance is great and the default search function is exactly what I was looking for. I'm looking forward to trying out the features you've planned. One small concern I have is the example I implemented allows

[web2py] Re: web2py 1.90.1 is OUT

2010-12-18 Thread tomt
I upgraded to Version 1.90.1 and all of my applications that use mysql stopped working. The traceback shows: Traceback (most recent call last): File /home/xa21/workspace/webpy4/gluon/restricted.py, line 188, in restricted exec ccode in environment File

[web2py] Re: web2py 1.90.1 is OUT

2010-12-18 Thread tomt
Updating to 1.90.2 fixed all the mysql problems I listed and all my apps are working again. Thanks alot - Tom On Dec 18, 7:13 pm, tomt tom_tren...@yahoo.com wrote: I upgraded to Version 1.90.1 and all of my applications that use mysql stopped working. The traceback shows: Traceback (most

[web2py] Re: Newbie question:add new record as a copy of an existing row in SQLFORM

2010-12-06 Thread tomt
Thanks for the example and the reference. - Tom On Dec 6, 5:58 pm, villas villa...@gmail.com wrote: Hi tomt I believe it takes the fields from the specified source table and lines them up with a target table.  Any fields which don't match and the id are discarded. What Denes means

[web2py] Re: Newbie question:add new record as a copy of an existing row in SQLFORM

2010-12-05 Thread tomt
()     return dict(form=form,things=things) On Dec 3, 6:12 pm, tomt tom_tren...@yahoo.com wrote: Hi, I've started to write a simple application to learn web2py. I am using SQLFORM to insert, modify and delete records. So far everything is working as planned. I would like to give

[web2py] Re: Newbie question:add new record as a copy of an existing row in SQLFORM

2010-12-04 Thread tomt
        db.things.insert(**vals)     things = db(db.things.id0).select()     return dict(form=form,things=things) On Dec 3, 6:12 pm, tomt tom_tren...@yahoo.com wrote: Hi, I've started to write a simple application to learn web2py. I am using SQLFORM to insert, modify and delete records. So far everything

[web2py] Newbie question:add new record as a copy of an existing row in SQLFORM

2010-12-03 Thread tomt
Hi, I've started to write a simple application to learn web2py. I am using SQLFORM to insert, modify and delete records. So far everything is working as planned. I would like to give the user the ability add a new record as a copy of an existing one. The idea is that the user would view an