[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 exist

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

2010-12-04 Thread tomt
b.things(request.vars.dupe) >         vals = {} >         for k,v in record.items(): >             if k in db.things.fields: >                 vals[k] = v >         db.things.insert(**vals) >     things = db(db.things.id>0).select() >     return dict(form=form,things=things) > > On De

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

2010-12-05 Thread tomt
sion): > >         response.flash = 'Added a thing' > >     if request.vars.dupe: > >         record = db.things(request.vars.dupe) > >         vals = {} > >         for k,v in record.items(): > >             if k in db.things.fields: > >                 val

[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 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. > > W

[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 "/home/xa21/workspace/webpy4/applic

[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 wrote: > I upgraded to Version 1.90.1 and all of my applications that use mysql > stopped working. The traceback shows: > > Traceback (most rece

[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 me

[web2py] Re: Powertable remarks

2010-12-29 Thread tomt
e.blouweb.com/products?pager=full_numbers > > Bruno. > > Em 29/12/2010, às 02:49, tomt 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

[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 wrote: > Here is a complete list of working powerTable > options:https://bitbucket.org/rochacbruno/po

[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) >F

[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 apps

[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 tab

[web2py] Re: Question on using legacy tables

2012-07-25 Thread tomt
> or stable? > > 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','

[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. (Iss

[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

[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: (1452, u'Cannot add

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

2012-04-08 Thread tomt
ay? It looks like it does not like 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

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

2012-04-09 Thread tomt
ork? > > On Sunday, 8 April 2012 22:08:47 UTC-5, 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

[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-14 Thread tomt
e made web2py enormously more productive. 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 cre

[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: Add My previous code generated the same html, but it displayed a button, not just the lin

[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 what

[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 c

[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 ap

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 follo

[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 = Non

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

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

2012-10-17 Thread tomt
e error messages 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 e

[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), Field('comment','s

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

2012-11-23 Thread tomt
.represent(r) > > > Someone can help me? > ciao ;) > > Il 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.cus

[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 c

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

2012-12-07 Thread tomt
set links_placement ='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. &g

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

2012-12-10 Thread tomt
10, 2012 9: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:

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

2012-12-10 Thread tomt
thing? On Monday, December 10, 2012 12:44:30 PM 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 SQLFO

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

2012-12-14 Thread tomt
rid is readonly mode 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&

[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 subd

[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 http://server

[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, Mas

[web2py] Re: TNS error on Oracle

2012-03-06 Thread tomt
saw a similar error 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 db = DAL('or

[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: 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 dis

[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 like

[web2py] Re: Published my collection of plugins

2011-09-04 Thread tomt
uot; feature of Field, as in > SQLTABLE: > db.status_info.description.represent = lambda v: XML(v) > > On 9月4日, 午後12:38, tomt wrote: > > > Kenji, > > > Thanks for contributing your great plugins.  I've started to use > > solidtable and solidform and I expec

[web2py] Re: New Plugin: plugin_ckeditor

2011-09-13 Thread tomt
Tom On Sep 3, 10:12 pm, tomt 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 >

[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: 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
> instead of boolean. In other words this (old): > > form=SQLFORM() > if form.accepts(request,session,onaccept=crud.archive): ... > > and this (new) > > form=SQLFORM() > if form.process(onaccept=auth.archive).accepted: ... > > are equivalent. > > ma

[web2py] Re: History tables how?

2011-09-19 Thread tomt
> > 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 w

[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 display

[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: 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', Field('pointnumber','integ

[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: Please help me understand how 'lambda row, rc' works

2011-11-06 Thread tomt
er. - Tom On Nov 6, 6:42 am, Stefaan Himpe 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='

[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] 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 i

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

2011-11-14 Thread tomt
jquery-ui theme (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

[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 r

[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] 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
Thanks for the quick response. On Feb 13, 3:57 pm, Bruno Rocha wrote: > 2011/2/13 tomt > > >  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 in

[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 meant

[web2py] Re: powertable: howto adjust table width

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

[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, I'

[web2py] Re: Customize search results table

2011-02-23 Thread tomt
I'm not sure if this will help, but you can display an array of rows and not the whole table. Example: def task_powerlist_bycpa(): id=request.args(0) tasks=db(db.task.cparef==id).select(db.task.ALL) table = plugins.powerTable table.datasource = tasks table.keycolumn = 'task.i

[web2py] powertable question about get_category_name

2011-02-26 Thread tomt
Hi, I was trying to learn more from the powertable example, specifically how the represent options in the field definitions work. db.define_table('products', Field('category',db.category,label=T('CategoryW'),represent=lambda c:get_category_name(c)), I deleted the get_category_name function def

[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, but

[web2py] Re: powertable question about bStateSave

2011-04-12 Thread tomt
t. > -- > Bruno Rocha > [ About me:http://zerp.ly/rochacbruno] > > On Thu, Apr 7, 2011 at 12:49 AM, tomt wrote: > > Hi, > > > I'm using powertable and set table.dtfeatures['bStateSave'] = True > > The search parameters are saved successfully, but the pag

[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 wrote: > Hi, > > I discovered why pagination is lost.  When table.showkeycolumn = true > then at line 733 >

[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 'd

[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 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 prepopula

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

2011-07-22 Thread tomt
Hi, Your latest plugin looks great and I am eager to learn more about it. However, I got some errors when I installed web2py.app.PowerGrid.w2p and tried to run it: Traceback (most recent call last): File "/home/xa21/workspace/web2py/gluon/restricted.py", line 192, in restricted exec ccode

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

2011-07-23 Thread tomt
the auth.requires_membership line and a fresh new app with no success, but I'll try it out again with a clean install and let you know how it worked. Thanks again for the feedback, - Tom On Jul 23, 9:38 pm, Bruno Rocha wrote: > On Sat, Jul 23, 2011 at 2:34 AM, tomt wrote: > > Database

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

2011-07-24 Thread tomt
complains about '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 workin

[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] 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 erro

[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 de

[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 ca

[web2py] Re: Published my collection of plugins

2011-08-30 Thread tomt
ed theelrteversion from 1.2 to 1.3. > Additionally, 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) > > Kenj

[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] 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 = DAL('mysql:/

[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

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, u"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the

[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 lin

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

2013-09-22 Thread tomt
return dict(form=form) On Wednesday, September 18, 2013 9:57:33 PM UTC-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,

[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 c

[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: Point

[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 requ

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

2016-09-10 Thread &#x27;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, w_tm

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

2016-09-23 Thread &#x27;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 have

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

2016-09-25 Thread &#x27;tomt' via web2py-users
2016 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 suppo

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

2016-10-27 Thread &#x27;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 attac

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

2016-11-01 Thread &#x27;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: How can I access functions from multiple files in the controllers directory?

2016-11-03 Thread &#x27;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 im

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

2015-11-07 Thread &#x27;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 &#x27;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 noticed

[web2py] Re: Oracle perfomance issues with version 2.12.3

2015-11-10 Thread &#x27;tomt' via web2py-users
been introduced this performance > 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 encou

[web2py] RSA Securid integration with web2py

2018-04-25 Thread &#x27;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) - https

[web2py] what are the12 core objects

2014-07-01 Thread &#x27;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 rec

[web2py] Re: what are the12 core objects

2014-07-02 Thread &#x27;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 "web2

  1   2   >