[web2py:24070] Re: Little recipe for ad hoc queries and ref cursors

2009-06-13 Thread Mariano Mara
really? mutt + imap + gmail: a recipe for desaster!! :) 2009/6/13 mdipierro > > the you email it to me as an attachament . the indentation is messed > up and hard to read. > > Massimo > > On Jun 13, 12:21 am, Mariano Mara wrote: > > Hi everyone. > > >

[web2py:24059] Little recipe for ad hoc queries and ref cursors

2009-06-12 Thread Mariano Mara
Hi everyone. I'm currently trying to migrate a legacy oracle database to web2py and on the past weeks I stumbled upon several issues related to how the database was originally designed and how web2py expects to interact with it. Among them: * I need support for ref cursors * I need to write so

[web2py:23420] Re: old version

2009-06-06 Thread Mariano Mara
2009/6/6 pk > > Hi together, > > where can I find the previous version of web2py (version before > 1.63) ? > thanks > Peter > If you're using the bzr repository you can download the current version and then branch to a previous one: $ bzr help branch Purpose: Create a new copy of a branch. Usag

[web2py:23241] Re: Does web2py still supports python 2.4?

2009-06-03 Thread Mariano Mara
    * source code for all platforms (requires Python 2.5, runs on > Windows and most Unix systems, including Linux and BSD) >     * latest development snapshot for BZR >     * latest development snapshot for SVN >     * Production Distribution/VMWare appliance (coming soon) > > Chri

[web2py:23236] Does web2py still supports python 2.4?

2009-06-03 Thread Mariano Mara
I'm trying to migrate a web2py app to a centos server that comes with Python 2.4.3 So far I hit errors with hashlib and uuid (easily fixed installing python-hashlib and python-uuid). However now I have a problem with the code: $ ./web2py.py Traceback (most recent call last): File "./web2py.py",

[web2py:23132] Re: Problem with left outer join

2009-06-02 Thread Mariano Mara
'")) 436 i += 1 --> 437 return execute(command[:-1], args) 438 439 DatabaseError: ORA-00904: "WOTTHT"."TASKTYPE": invalid identifier In [28]: db._lastsql Out[28]: "SELECT HourType.code, TaskType.code FROM WoTtHt, HourType LEFT OUT

[web2py:23125] Re: Problem with left outer join

2009-06-02 Thread Mariano Mara
e.code, TaskType.code FROM HourType, WoTtHt LEFT OUTER JOIN TaskType ON WoTtHt.tasktype=TaskType.id WHERE ((WoTtHt.hourtype=HourType.id AND WoTtHt.workorder=2) AND WoTtHt.valid='T'); However I cannot find a way to make DAL switch the table's order (at least with all the combination

[web2py:23100] Problem with left outer join

2009-06-02 Thread Mariano Mara
Good night everyone. Sorry to bother you guys with this but I'm totally stuck. I have the following tables defined: db.define_table("TaskType", db.Field("code", type='string', length=3, required=True, notnull=True, unique=True), d

[web2py:22844] Re: web2py and Debian

2009-05-28 Thread Mariano Mara
2009/5/28 Jurgis > > > > I have packaged > > web2py for debian and Ubuntu but don't have a registered status so > > can't push them into official repositories. > > would be cool, if one could download them from some universe place -- > maybe web2py.com for the start? :) For a start, PPA can be

[web2py:22798] Re: Possible bug with Oracle.

2009-05-27 Thread Mariano Mara
2009/5/28 SergeyPo > > My vote for it too, I've reported this problem before. > > Sergey Sorry I missed it: seems I didn't search enough. > > > On May 28, 8:13 am, Mariano Mara wrote: > > G'night everyone. > > > > I'm defini

[web2py:22794] Possible bug with Oracle.

2009-05-27 Thread Mariano Mara
G'night everyone. I'm defining a table like this: db.define_table("BillHourType", SQLField("hourtype", db.HourType), SQLField("billtype", db.BillableType), SQLField("startdate", type='date', r

[web2py:20818] Re: existing database

2009-04-29 Thread Mariano Mara
2009/4/29 ae > > I'm struggling with how to handle a database that already exists. > I've written model code for many of the tables and I can access them, > but many others don't have 'id' fields. One table has a field that is > an enum(). > > If I must resort to using db.executesql(), how shoul

[web2py:20671] Re: google code and mercurial

2009-04-27 Thread Mariano Mara
On 27.04.09 21:34, Tim Michelsen wrote: > > > bzr is the one that gives me problems (all the other which I access > > external repositories with I have been able to configure such that they > > work). > Can you run a centralized repository on a FTP server? > > This has been a real plus fo

[web2py:20651] Re: Accessing _cursor object OK?

2009-04-27 Thread Mariano Mara
On 27.04.09 10:08, ae wrote: > > It doesn't appear that executesql is used internally. > > I prefer not to have a locally modified version of gluon. > > How about: > > def executesql_with_description(self, sql): >... > > you named it _cursor! ;) You could inherit from SQLDB in your db.p

[web2py:20378] Re: Translate all strings

2009-04-23 Thread Mariano Mara
2009/4/23 Álvaro Justen [Turicas] > > On Thu, Apr 23, 2009 at 5:52 PM, Álvaro Justen [Turicas] > wrote: > > So, I propose to change all 'default strings' to T('default strings'). > > Example, in gluon/*.py we have to change: > > gluon/tools.py: class Auth: all self.messages.* > > gluon/sqlhtml.p

[web2py:20151] Re: Issue with module accessing redirect() method

2009-04-20 Thread Mariano Mara
On 20.04.09 22:03, waTR wrote: > > Also, could someone give me a link to the python doc that explains the > use of @ such as > > @cache... > def myfunc(): ... > > I always recommend this article whe it comes to decorators: http://www.siafoo.net/article/68 Mariano. --~--~-~--~~--

[web2py:20107] Re: transpose a SQLTABLE in view

2009-04-20 Thread Mariano Mara
On 20.04.09 02:29, Timmie wrote: > > Hello, > I asked how to change the output of a query result [1]. > As my table is rather huche and I do not want to force my users to do > vertical scrolling, I would like to transpose the SQLTABLE: > > instead of: > > header1 header2