[web2py] Re: Jeditable and SQLTables

Have a rephrased/ simplified controller, and while almost got it working, running out of ideas/ talent. The problem is in posting parameters to the controller and passing a value back to the edited field (its just not seeing them). Any ideas would be welcome, but failing that, would anyone be

[web2py] Re: Jeditable and SQLTables

Thanks Brent, Sorry for the delay - first chance to delve into this again. Still no luck. Have tried various combinations but unable to get jeditable fire in this setup. Do you have a quick example that works (just a cut and paste one would do)? TIA. --

[web2py] Re: Jeditable and SQLTables

h request.post_vars instead of > using request.args > I also modified the update clause so it would work with passing a column > name in as text. > I am using the source 1.7.1 version of jeditable from the > site<http://www.appelsiini.net/projects/jeditable>. > > > W

[web2py] Re: Jeditable and SQLTables

column. > > > Give this a-go and see if the calls to the update() are working for you. > > I'm using 1.99.7 stable of web2py. > > Regards, > Brent > > On Tuesday, 17 July 2012 16:14:40 UTC-6, Simon Ashley wrote: >> >> Thanks Brent, >> >>

Re: [web2py] displacement of password button [web2py twitter bootstrap]

Negative on that. Still have an issue from the most currently nightly build. Has anyone tracked down precisely what's causing it? TIA, --

Re: [web2py] displacement of password button [web2py twitter bootstrap]

should probably clear your browsing data and refresh. > > Not sure why you are still having the problem. Is it in both browsers or > just google chrome? > > > > > On Wed, Jul 25, 2012 at 5:57 AM, Simon Ashley wrote: > >> Negative on that. >> Still have an issue

Re: [web2py] displacement of password button [web2py twitter bootstrap]

ps: just noticed that the password buttons are different in the last 2 browsers ... On Thursday, 26 July 2012 09:57:49 UTC+10, Simon Ashley wrote: > > Was using the 21/07 truck version. > Downloaded a fresh version this morning to re check and cache cleared. > Displays differently

[web2py] Re: Accessing db['auth_user'] raises exception

Getting the following error on the latest nightly build. (have just downloaded again to make sure). Is this related? TRACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. Traceback (most recent call last): File "c:\web2py4\gluon\restricted.py", line 205, in restricted exec ccode in environmen

[web2py] Re: Accessing db['auth_user'] raises exception

gust 22, 2012 8:00:25 AM UTC+1, Simon Ashley wrote: >> >> Getting the following error on the latest nightly build. (have just >> downloaded again to make sure). Is this related? >> >> TRACEBACK >> >> 1. >> 2. >> 3. >> 4. >> 5.

[web2py] Re: Accessing db['auth_user'] raises exception

Pierro wrote: > > works with current trunk: > > $ python web2py.py -S welcome -M -N > >>> db['auth_user'] > > > > On Wednesday, 22 August 2012 19:07:13 UTC-5, Simon Ashley wrote: >> >> It helps, but it seems like a change in trunk causes

[web2py] Grid, NameError: name 'auth' is not defined

Having issues with SQLFORM.grid with the latest trunk (2012-08-22 23:37:57) throwing "NameError: name 'auth' is not defined" errors. To reproduce the error, downloaded a fresh build and unzipped to a fresh folder. In the examples application, created a new controller, with the following code ex

[web2py] Re: Grid, NameError: name 'auth' is not defined

Yep, sorry about that (was trying to post something quick to illustrate the issue). Part of the issue appears to be the db.auth_user table. Deleted and manually rebuilt it, and the error disappeared. Its appears that the latest trunk maybe have broken a callback link (reloads the calling form ra

[web2py] Trunk > 20012-08-19 formatting

Its appears that SQLFORM.grid formatting has changed recently in the trunk: (with no change to the application) - The Query button has been dropped, - Add button moved to on top of the query field. - Export function changed from before the table to after with hyperlinks options rath

[web2py] Re: Trunk > 20012-08-19 formatting

gt; thought a good way was to add links at the bottom. > > Notice that the old export form was problematic because did not work well > with LOADed grids. > > Anyway, it should not break existing functionality. Doesn't it look better > now? > > Massimo > > On Th

[web2py] Re: Trunk > 20012-08-19 formatting

The last issue resolved and re iteration of a warning to others. *Don't use more than one SQLFORM.grid on a form.* On Friday, 24 August 2012 12:32:01 UTC+10, Simon Ashley wrote: > > That's OK. > I'm not sure with the styling of the Export at bottom of the screen but n

[web2py] Plugin Wiki, jqgrid, crud.create error

Just playing with the plugin wiki and jqgrid with a simple example below, but it return an error: Not sure why, any ideas? # List of Plant `` name: jqgrid table: plant fields: Code,Description,SMU,Date col_width: 80 width: 700 height: 300 ``:widget # New Plant `` name: create t

Re: [web2py] Plugin Wiki, jqgrid, crud.create error

4 UTC+10, Johann Spies wrote: > > On 12 April 2012 05:38, Simon Ashley wrote: > >> Just playing with the plugin wiki and jqgrid with a simple example below, >> but it return an error: >> >> Not sure why, any ideas? >> >> >> > Did you create the t

[web2py] jstree, controller call

Having difficulties coming up with an appropriate call back from a jstree triggered from a .bind event. Javascript/ JQuery/ jsTree code is as follows: ).bind("select_node.jstree", function (event, data) { "xxx" } what we're trying to do is to make the call back ("xxx") to the controller t

[web2py] Re: jstree, controller call

Ok, I'll rephrase this: - what's the best/ simpliest way of calling a controller from a view? - using javascript? or escaping python code? On Sunday, 15 April 2012 16:30:16 UTC+10, Simon Ashley wrote: > > Having difficulties coming up with an appropriate call ba

[web2py] Re: jstree, controller call

Thanks but unfortunately this doesn't help as the controller needs to be called from within the view. (what we believe to be normal python escaping techniques i.e. {{ ... }} doesn't seems to be returning appropriate responses. Have been stuck on this for weeks now. While our javascript skills m

[web2py] Re: A helper returning an unexpected result

Thanks, was expecting a call to the the 'index' function as defined within the default controller. ('index' is just calling a simple grid - to see if something/ anything could be called) This was a derivation of an earlier thread (jstree, controller call) and was part of a many of attempts (all

[web2py] Re: jstree, controller call

var baseurl = "{{=URL('tree', 'stree', 'index', extension='load')}}" + > "/" + data.rslt.obj.attr("id"); > web2py_component(baseurl, 'theformdiv'); > } > > the "web2py_component" part call

[web2py] Re: ImportError with plugin

Has anyone come up with a solution to this? Have the same issue. On Thursday, December 1, 2011 7:08:38 AM UTC+10, haikuvend Resident wrote: > > I have downloaded a plugin from http://dev.s-cubism.com/plugin_solidform > > It consists of two files: > - controller/plugin_solidform.py (demo) > - *mo

[web2py] Re: ImportError with plugin

Answering my own question here. Its a path issue. If you insert the fill path from the applications folder, its found. On Monday, May 14, 2012 8:08:23 AM UTC+10, Simon Ashley wrote: > > Has anyone come up with a solution to this? Have the same issue. > > On Thursday, December 1, 201

[web2py] Solidform error: list indices must be integers

Any one with any ideas on this one? (been trying to trouble shoot it all morning) Environment: Version 1.99.4 (2011-12-31 04:51:15) Getting the following error, and unable to work it out. (have other areas using soldiform that are working OK) Traceback (most recent call last): File "C:\web2py\

[web2py] Re: Solidform error: list indices must be integers

Rows object. > > On Wednesday, 16 May 2012 21:32:08 UTC-5, Simon Ashley wrote: >> >> Any one with any ideas on this one? >> (been trying to trouble shoot it all morning) >> >> Environment: Version 1.99.4 (2011-12-31 04:51:15) >> >> Getting the followi

[web2py] ExecuteSQL, nested selects

trying the following expression but get an update according to the first record rather than being conditional on specific records processed: db.executesql("UPDATE Plant SET SiteID=(SELECT Site.id FROM Plant, Site WHERE Site.SiteId = Plant.SiteIdLink);") ie. all SiteID's get the value of the

[web2py] Re: ExecuteSQL, nested selects

To answer my own post, syntax should have been: db.executesql("UPDATE Plant SET SiteID=(SELECT Site.id FROM Site WHERE Site.SiteId = Plant.SiteIdLink);") Sorry about that ... On Monday, May 21, 2012 2:50:33 PM UTC+10, Simon Ashley wrote: > > trying the following expre

[web2py] Jeditable and SQLTables

Does anyone have any native python/ web2py code for a jeditable call in a table that they are willing to share i.e. a web2py version of save.php? --

[web2py] Re: Jeditable and SQLTables

OK, a little bit more infor if anyone can help: Have a requirement for get jeditable working with a grid/ table (sqlform.grid or slqtable). Current issue is that using the jeditable.js, return parameters seems incorrect i.e. editable td value is the indicator parameter rather than what should

Re: [web2py] Re: cpdb errors

Just confirming that csv imports fail with Postgres on Ubuntu 12.10, but both sqlite and mysql import fine. Suspect its a postgres issue, and will attempt different adapters/ refactor of the DAL table def to try and identify the cause Error message is fairly generic.

Re: [web2py] Re: cpdb errors

9.1 (fresh install yesterday) --

Re: [web2py] Re: cpdb errors

I hate this. Its fixed (stable) for the time being, but cant clearly identify the cause. I'm sure that there is a still memory leak and it may appear again.. Early in the process, Ubuntu was acting similarly to Windows 7 i.e. consuming memory when importing the csv file and eventually failing.

Re: [web2py] Re: cpdb errors

> > *Final conclusion:* memory leak confined to pg8000. psycopg2 works fine in Windows and Linux. > > > --

[web2py] Amazon RDS

Wondering if it is possible to connect an EC2 instance/ application to a RDS instance (MYSQL), and what the connection string should be? There is some discussions here implying that it may be possible but uncertain of the connection string. What's been suggested is db = DAL('mysql//"*connection

[web2py] Re: Amazon RDS

Never mind - RTFL. Above string works fine .Issue in the security groups. --

[web2py] Re: smartgrid - display linked_tables link as a dropdown button instead

Its high on our list as well. That plus a denser edit/create/view layout similar to Scubism's Solid Form. --

[web2py] Re: smartgrid - display linked_tables link as a dropdown button instead

My original post hasn't turned up yet, so this may be a duplicate. There was an earlier request (last year) by Massimo, with code written by Martin Mulone to address the dropdown button issue. It may have slipped through the system and never implemented. https://groups.google.com/forum/#!search

[web2py] 2 grids loaded in a single form: back button reference

Trying to embed multiple grids (or at least 2 of them) on a single page using load statements as per the following controller, functions and views. It seems to work fine until you click view or edit, from the called grid, on the calling grid (step2). The related edit and view seem to be rendered

[web2py] Date null display

Traditionally in other field types you could display a null value with an expression similar to the following: db.table.datefield.represent = lambda value, row: A(value) if value else 'unknown' Occasional we have a requirement to display null values as alternatively i.e. None, Unknown, Not rec

Re: [web2py] Date null display

Thanks Bruno, that works. (had tried that earlier, but didn't get it. Time to flex off for the weekend, me thinks) -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an e

[web2py] Re: 2 grids loaded in a single form: back button reference

Thanks Niphlod, that worked. (Eventually. Had some weird caching going on. The submit was originally redirecting to an unrelated controller and function. Eventually cleared itself after deleting and reinserting the formname attribute. Using current trunk) -- --- You received this message

[web2py] DAL update with a accumated field

Having problems updating from with a row with a db.table.field.count() field (similarly with sum(), min(), max() etc.) i.e. def update_flea_count(): query = db(db.fleas.id>0).select(db.fleas.dog_name, db.fleas.flea_name.count(), orderby=db.fleas.dog_name, groupby=db.fleas.dog_name) for

[web2py] Re: DAL update with a accumated field

Sorry, the error should have read: File "C:/web2py16/applications/lconfirm/controllers/dogs.py" , line 27, in update_flea_count db.dogs.update_or_insert(db.dogs.dog_name == row.dog_name, AttributeError: 'Row' object has

[web2py] admin app 4 x slower with 2.2.1 versus 2.0.9

Experiencing slow screen loads using the standard admin app when editing an application. Both admins load the same amount of data (900k) but 2.0.9 load in 2.3secs, with 2.2.1 taking over 10secs. Are there any setting/ tricks to improve 2.2.1's performance? (900k seems high, when intensive/ co

[web2py] DAL update with date arithmetic

Uncertain why the first fails with the following error: TypeError: unsupported operand type(s) for -: 'datetime.datetime' and 'Field' and the second works. def Update_RData3_dslr(): import datetime today = datetime.date.today() db(db.HData.id>0 and db.HData.lrace).update(dslr = (req

[web2py] Re: admin app 4 x slower with 2.2.1 versus 2.0.9

Exiting a controller to return to the main page (back button). i.e. loads /admin/default/design Downloaded a new source/ nightly build and seems to be better - 5.3 seconds, 839k, but still seems a little bit long. --

[web2py] Re: DAL update with date arithmetic

OK, thanks for that :) --

[web2py] Re: admin app 4 x slower with 2.2.1 versus 2.0.9

just to be clear we're running localhost on an i7 with 8g ram. The benchmark is taken returning back to the *admin/default/design/someapp *page from inside a controller. (hitting the *back* button to right of screen) (original reply may have been a bit confusing) Benchmarks with Win7 1. Chrom

[web2py] Re: admin app 4 x slower with 2.2.1 versus 2.0.9

Ubuntu 12.04, with a standard web2py install /apache/sqlite: Chromium /admin/default/design 2.51 sec (repeatable) Firefox - 2.47 (repeatable) (on load 4.7) Summary: 2x as quick as Win7 / Rocket. Slower than expected but acceptable. Certainly more productive than Win7 which was becoming a pain.

[web2py] Re: admin app 4 x slower with 2.2.1 versus 2.0.9

Thanks but bulky, with all due respect, maybe not. >From one perspective, its less than 5% of our client/ server applications. Currently the web2py app is approx 120 tables, and 250 functions (over 25 controllers). C/S apps which we intend to convert handle the equivalent of 900 tables, 10,000

[web2py] Re: admin app 4 x slower with 2.2.1 versus 2.0.9

#Niphlod. Sorry for my original original comment/ response. I always realised that there was a going to be a limit/ scalability issue with the admin app. It was intended more to stimulate debate/ ideas on how to handle bulky apps. (was hoping that we would come across it later rather than soon

[web2py] Re: admin app 4 x slower with 2.2.1 versus 2.0.9

Yep, that makes a lot of sense. Tried that approach with Komodo, and certainly is more productive. Just a change in mind set. Thanks for your reply. --

[web2py] Icons/ imgs rather than labels for Grid headers

Have a requirement to produce grids / tables with icons rather than label headers. In messing around, haven't come up with a good solution, and looking for ideas (header labels are are normally translated as a strings). Would manipulated the grid / table variable before return it as a dict be

[web2py] Re: Icons/ imgs rather than labels for Grid headers

Thanks. Will give that another look. Have tried this approach (many attempts) but could not generate the correct HTML. (will play around with the class as the default seems to translate the =IMG element as text/string) If you have a snippet of a working example, would appreciate it. --

[web2py] Re: Icons/ imgs rather than labels for Grid headers

> > ahaa, thanks Paulo, that make sense i.e. to do it all in the view > > --

[web2py] Re: we should support this in DAL

What issues are you coming up against with Mongo/ nosql ports and DAL operations? Interested because we need to start investigating this. On Sunday, November 18, 2012 12:02:12 PM UTC+10, Adi wrote: > > Definitely would be nice to support NoSQL. > > I tried the existing DAL with MongoDB and grid

Re: [web2py] Re: we should support this in DAL

The part would would have interested us is potential to re factor live systems, particularly with changing tenancy requirements. Thinking that while the DAL, by necessity will have relational database tendencies and may never have full nosql capability, it would be interesting to explore areas

Re: [web2py] Re: we should support this in DAL

and then implemented > as a nosql version of DAL. Not sure how I could help, if not with coding, > then with testing at least? > > > On Sun, Nov 18, 2012 at 5:02 PM, Simon Ashley > > wrote: > >> What issues are you coming up against with Mongo/ nosql ports and DAL >

[web2py] Re: we should support this in DAL

+1 for moving in this direction. On Saturday, November 17, 2012 10:19:15 PM UTC+10, Massimo Di Pierro wrote: > > http://labs.codernity.com/codernitydb/index.html > --

Re: [web2py] Re: we should support this in DAL

In the not to distant future we need to refactor reasonable large SQL databases. Current open source choices are limited to MySQL and PostgreSQL. (trying to avoid vendor lock in issues). Interest in this thread is as a prompt to explore nosql pros and cons. Both SQL options are mature, well de

Re: [web2py] Re: we should support this in DAL

The bottom line seems to be that we/ others need to start to use nosql engines to sort the issues. My guess is that, currently, critical mass is not present to rely on it for production sites. --

[web2py] Conditional {{extend layout.html}}?

Wondering if it is possible to have a conditional {{extend layout.html}} similar to the following? {{if session.call:}} {{extend 'layout_XXX.html'}} {{pass}} {{if not session.call:}} {{extend 'layout.html'}} {{include 'YYY.html'}} {{pass}} Required for users with requiring diff

Re: [web2py] Conditional {{extend layout.html}}?

Thanks, excellent, that works .. (compiling wont been an immediate issue) >> >> > > --

[web2py] Multiple connections/ databases with same app

Quick question - is this do able i.e. some tables - e.g. db = DAL('sqlite://storage.sqlite), other tables - db1 = DAL('mysql://root: ) etc, within the same application/controller/function? If so, will write up an issue we're having. TIA --

Re: [web2py] Multiple connections/ databases with same app

Ok then, should this work? (Version 2.3.2 (2012-12-17 15:03:30) stable, source, nightly build, from 12/31) *Connection* db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all']) db1 = DAL('mysql://root:www@localhost:3306/xxx', migrate=True, fake_migrate= False, check_reserved=['commo

Re: [web2py] Multiple connections/ databases with same app

Sorry Alec, I saw that just as posted it and tried to delete it. It came through again afterwards. This wasn't the issue, just an example returning the same error. Solved it ... was in the query=db() statements, which should have been changed to query=db1() etc. Thanks for your reply.

[web2py] Re: cpdb errors

Interesting but encountering similar problems to *backseat *on windows 7 using the following command from a prompt in web2py root folder: i.e. c:\web2py> set path=%path%;c:\web2py\gluon c:\web2py> c:\python27\python scripts\cpdb.py -d gluon -f application\app\databases -y 'sqlite://storage.sqli

[web2py] Re: cpdb errors

Thanks Mart, That's sort of fixed it, but starting to get additional issues with the auth tables. Think have seen this before with csv imports and have gotten around by deleting suspe

[web2py] Re: cpdb errors

Thanks Mart, That gives me some clues and a renewed focus. Issue may be with postgres (at least the install I had - has been deleted and will be installed). Will also try ubuntu environment. Will report back ... --

[web2py] Re: cpdb errors

That's a negative on cache.py. It's from a nightly build pulled about 5 days ago. The csv in question is about 150k records. (have pruned it down to a test of 10 records, and they import OK). Has about 140 fields, quite a few nulls, and have compensated for the adapter's postgres decimal precisi

[web2py] Re: Web2Py on AWS Elastic Beanstalk

Isaac, if you do a search on this group, you'll find a bit more info. Failing that, we may need to do the same in the next few days ... --

[web2py] Re: Ryan Singer at Future of Web Apps

Interesting ... We are working on a rewrite of an existing system from another environment. (50 tables, 200 screens and reports) Like paper sketches, they always work well. Using (trialing) Enterprise Architect (EA) and using that to setup table and user interactions. (as well as providing proj

[web2py] Postgres unknown reference field type

Moving from SQLite to Postgres and when running Database Administration we're getting unknown field type errors when using a db reference i.e. Field('Client', db.Client) Any advice or work arounds? TIA, Traceback (most recent call last): File "C:\web2py\gluon\restricted.py", line 204, in restri

[web2py] Re: Postgres unknown reference field type

ooks like you have > > Field('Client', 'db.Client'), > > instead of > > Field('Client', db.Client), > > is that possible? > > On Jan 18, 6:25 pm, Simon Ashley wrote: > > > > > > > > > Moving from SQLite to Post

[web2py] Re: SQLFORM.smartgrid query/search don't work for related tables

+1 for a resolution on this. On Jan 19, 1:20 pm, Jim Steil wrote: > Adnan > > I did not get this working, but that doesn't mean it has been resolved. > I've given up on the search that is included in grid/smartgrid and have > been working on a solution whereby you can override the default behavio

[web2py] Rackspace install.

Have totally run out of time, and have posted on expect4solutions a job for someone to complete an install/ fresh install on rackspace. Postgres / apache (or equivalent). Need a turnaround in the next 36 hours as required for Monday. Contact me privately. TIA,

[web2py] Re: Rackspace install.

Thanks, the job has been let and is under way ... On Jan 20, 8:42 pm, Simon Ashley wrote: > Have totally run out of time, and have posted on expect4solutions a > job for someone to complete an install/ fresh install on rackspace. > Postgres / apache (or equivalent). > Need a turna

[web2py] Re: Web2py cookbook

Its available now on packtpub On Monday, March 12, 2012 8:27:44 PM UTC+10, bussiere adrien wrote: > > Does anyone know when the web2py cookbook will be available please ? > > Regards > Bussiere > > "Les nouvelles technologies offrent pleins de nouvelles possibilités, > pleins de possibilités d'err

[web2py] Tree view, Rendering

Pretty new to this and stumbling a little. We need to generate a Treeview structure with the bottom node ending with some links to other pages (graphs etc) Have a 7 level deep structure (each level in a different table) with each level have a table format simple to the following: db.define_t

[web2py] Re: Tree view, Rendering

Tuesday, April 3, 2012 4:25:52 PM UTC+10, mart wrote: > > do you mean that you are looking to parse a directory structure (7 dirs > deep) and dump the results to tables ? > > On Monday, April 2, 2012 8:21:12 PM UTC-4, Simon Ashley wrote: >> >> Pretty new to this and stum

[web2py] Re: Tree view, Rendering

e) and ended writing > the logic in web2py and using jstree as a ui in the frontend.. > I defintely learned some javascript in the way, but at the time those > wonderful plugins didn't exist :P > > Il giorno martedì 3 aprile 2012 12:04:05 UTC+2, Simon Ashley ha scritto: >&

[web2py] SQLFORM.grid representation

Have a Model as follows: from gluon.tools import Auth auth=Auth(db) auth.define_tables() db.define_table('person',Field('name'),format='%(name)s') db.define_table('dog',Field('name'),Field('owner',db.person)) db.dog.owner.requires = IS_IN_DB(db, 'person.id', db.person._format) and a controller:

[web2py] Re: SQLFORM.grid representation

ults.  But, if I go through > appadmin and list out my table the owner name does appear. > >      -Jim > > On 9/12/2011 9:51 PM, Simon Ashley wrote: > > > > > > > > > Have a Model as follows: > > > from gluon.tools import Auth > > auth=Auth(db

[web2py] Re: SQLFORM.grid representation

t; your example and can reproduce your results.  But, if I go through > appadmin and list out my table the owner name does appear. > >      -Jim > > On 9/12/2011 9:51 PM, Simon Ashley wrote: > > > > > > > > > Have a Model as follows: > > >

[web2py] Re: SQLFORM.grid representation

7;, 'dog.owner'] >     table = SQLFORM.grid(db.dog, columns=columns) >     return dict(table=table) > > columns affect the grid column displaying only. Pass to column the field you > want to display, no need to put readable=False. > > 2011/9/14 Simon Ashley > > > > &g

[web2py] Google App Engine Launcher and Deployment

Just a first time play with this. (Environment: Python 25, current Web2Py nightly source {copied to the Python25 root} and fresh copy of the Google App Engine Launcher) App is working fine from a command line python25 call When run from the Launcher -> Browse, is fine with a static page, but when

[web2py] Re: Google App Engine Launcher and Deployment

Thanks. Issue 474. On Oct 16, 12:47 am, Massimo Di Pierro wrote: > could be a bug in toolbar.  I never tried it in GAE. Open a ticket and > will fix it asap. > > On Oct 15, 2:05 am, Simon Ashley wrote: > > > > > > > > > Just a first time play with this.

[web2py] Re: web2py on gae

Are you able to post more details of the errors you get? Generally it works as expected (but with some caveats on the GAE side). We've currently going through that exercise, and noting that there could issues with SQL cloud which we haven't resolved yet (i.e. runs nosql OK but not mysql) On Oct 1

[web2py] GAE - SQL cloud connection

Having an issues connecting to the SQL cloud. Have a simple application which works on SQLite. Able to deploy to GAE using the following: db = DAL('gae') However if its changed to: db = DAL('google:sql://cdmr01:csm/csmcel05',migrate_enabled=True) # cdmr01:csm is the sql cloud instance and c

[web2py] Re: Multiple tables: update/insert/delete: in one form

Since no one has replied for a couple of days, I'll toss my 2 cents in. Don't how much value this could be, as we just evaluating web2py and python but in another environment we could have written data in the normalised records to a temporary record in a denormalised, virtual table, update and save

[web2py] Re: Multiple tables: update/insert/delete: in one form

t code, but can you suggest an approach to > tackle the task? > > Dear Massimo & other friends, > can you pl. suggest something to solve my problem? > > Thanks, > Vineet. > > ========= > On May 15, 5:07 pm, Simon

[web2py] Re: Multiple tables: update/insert/delete: in one form

========= > > On May 16, 4:33 pm, Simon Ashley wrote: > > > > > > > > > Memory tables referred to have no ability to write to disk. Generally > > we've used these for report accumulations. You could use a MySQL table > > and delete

[web2py] Re: Multiple tables: update/insert/delete: in one form

Vineet, We're doing the same in a different client server environment. Lots of business logic, 700+ tables, 10,000+ tasks to translate. We intend writing a high level tool as a web2py code generator, that will serve as a gateway between the 2. However we're probably at a lower level on the learnin

[web2py] Scheduler - calling functions outside a model?

Have a query on the scheduler and whether functions need to be defined inside a model or can be offload to a controller? (have seen a passing comment by Niphlod - which I can no longer find - that it may not be the case with ComfortScheduler but haven't been able to confirm it or worked out how

[web2py] Re: Scheduler - calling functions outside a model?

irements... how can a "controller" > function can be scheduled as a task? > On the last comma you talk about extensive routines: aren't they in a > module ? > > On Saturday, May 4, 2013 4:12:21 PM UTC+2, Simon Ashley wrote: >> >> Have a query on the scheduler

[web2py] Re: Scheduler - calling functions outside a model?

Extending on from my earlier reply, (which hasn't shown up yet), I think what you're suggesting is to store the code as a module, and import it as required from a model. Am I correct in assuming that this would have less performance impact than storing the code in a model? -- --- You receive

[web2py] Re: Scheduler - calling functions outside a model?

Went close with the LOAD('controller', 'yourfunction'), but fell at the environment when trying to write to the sql.log i.e. Traceback (most recent call last): File "C:\web2py19\gluon\scheduler.py", line 237, in executor result = dumps(_function(*args, **vars)) File "applications\xml2\mod

[web2py] Re: Scheduler - calling functions outside a model?

2.4.6 - stable -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/group

[web2py] Re: Scheduler - calling functions outside a model?

Thanks Simone, Turned out to be the following: path = os.path.join(request.folder, 'data\\') - os.chdir(path) - for files in os.listdir('*.*'): + for files in os.listdir(path): -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubs

  1   2   >