Re: [web2py] processing upload field.

2012-02-06 Thread Joaquin Orbe
On Fri, Feb 3, 2012 at 11:58 AM, VP wrote: > I have the following situation. > > There is a field A of type upload (image). > > There is another field B of type compute, which depends on A. > > I want to be able to process the image uploaded in field A and save > it, but before the compute in fiel

[web2py] TEXT data type deprecated in future MSSQL?

2012-03-16 Thread Joaquin Orbe
Hi Massimo, I've took a look into dal.py and found that "text" data type for MSSQLAdapter and MSSQL2Adapter is mapped to TEXT and NTEXT respectively. According to this article[0], these ones should be replaced by varchar(max) and nvarchar(max) due to will be deprecated in future versions (maybe SQ

Re: [web2py] Re: TEXT data type deprecated in future MSSQL?

2012-03-16 Thread Joaquin Orbe
On Fri, Mar 16, 2012 at 5:45 PM, Massimo Di Pierro wrote: > P.S. Please open a google code ticket about it. Done: http://code.google.com/p/web2py/issues/detail?id=722 Regards, Joaco.

Re: [web2py] setting blank date in new widget

2011-09-27 Thread Joaquin Orbe
On Tue, Sep 27, 2011 at 4:55 PM, apple wrote: > The new date/time widgets do not seem to have an option to set a blank > date/time. Once you have clicked on the date field you have to set a > date. Backspace and delete keys have no effect. > > Is there a way to leave the date field blank or to del

[web2py] error when insert record in appadmin

2011-03-05 Thread Joaquin Orbe
Hi all, I have a strange behaviour in appadmin trying to insert a record. It happens with all my tables except for auth's (auth_user, auth_group, etc). This is the error message: (('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. (102) (SQLExecDirectW)")

[web2py] Re: error when insert record in appadmin

2011-03-05 Thread Joaquin Orbe
Update: I've tried SQLite and it's the same problem: (near ")": syntax error) > locals > query : 'INSERT INTO my_table() VALUES ();' Any kind of help will be appreciated. Joaquin. On Sat, Mar 5, 2011 at 3:09 PM, Joaquin Orbe wrote: > Hi all, > >

[web2py] non redirection when authentication fails

2011-03-15 Thread Joaquin Orbe
Hi All, I have "two kind of users" in my application: admins and users. Each of them has different index function which I've decored, that's why I get these URLs when trying to login: * admins login through http://127.0.0.1:8000/myapp/default/user/login?_next=/myapp/admin/index * common users log

[web2py] Re: non redirection when authentication fails

2011-03-19 Thread Joaquin Orbe
Hi, a workaround for this (and I like it) is: auth = Auth(globals(),db, request.controller) With this I redirect to the login page for the correct controller when authentication fails. Regards, Joaquin. On Tue, Mar 15, 2011 at 12:15 PM, Joaquin Orbe wrote: > Hi All, > > I have &qu

[web2py] in-line select for counting purpose

2011-03-26 Thread Joaquin Orbe
Hi all, I'm trying to get a result for this query: select vendor.id, vendor.Name, (select count(*) from sales_order where [Status] = 1 and vendor.id = sales_order.VendorID), (select count(*) from sales_order where [Status] = 2 and vendor.id = sales_order.VendorID), (select count(*) from sales_ord

Re: [web2py] Re: in-line select for counting purpose

2011-03-30 Thread Joaquin Orbe
).select(db.vendor.id,db.vendor.Name,count) > rows2 = db(query) > (db.sales_order.Status==2).select(db.vendor.id,db.vendor.Name,count) > rows3 = db(query) > (db.sales_order.Status==3).select(db.vendor.id,db.vendor.Name,count) > > > > > > On Mar 26, 3:57 pm, Joaquin Orbe wrote: &

Re: [web2py] Re: in-line select for counting purpose

2011-03-31 Thread Joaquin Orbe
On Wed, Mar 30, 2011 at 6:56 PM, Massimo Di Pierro wrote: > yes. I do not know how to do it with one query. > > On Mar 30, 3:18 pm, Joaquin Orbe wrote: >> On Sat, Mar 26, 2011 at 6:30 PM, Massimo Di Pierro >> >> >> >> >> >> >> >> >

Re: [web2py] Re: Attribute Error

2011-04-10 Thread Joaquin Orbe
On Sun, Apr 10, 2011 at 11:07 AM, Anthony wrote: > It works for me. Are you sure you're problem is with {{=n.name}}. The error > message you got looks like a NameError, not an AttributeError. Are you > referring to a variable 'name' somewhere in your view (or controller)? Can > you show your full

Re: [web2py] About auth.requires_membership()

2011-06-06 Thread Joaquin Orbe
On Mon, Jun 6, 2011 at 2:03 PM, Cesar Bustios wrote: > Hi, is there a way to use this decorator with more than one group? For > example if i need function X to be use with groups A and B: > > @auth.requires_membership('A', 'B') > def X(): ... > > That doesn't work. How can I do that? > > Thanks >

Re: [web2py] export data to OOO and Excel

2011-07-20 Thread Joaquin Orbe
On Wed, Jul 20, 2011 at 5:45 AM, Vineet wrote: > I was looking for a library to export data to OpenOffice & Excel. > I found 2 such open source projects. > > For OOO --- > http://ooolib.sourceforge.net/ > > For Excel --- > http://www.python-excel.org/ > > What I intend to do is, keep the classes i

Re: [web2py] export data to OOO and Excel

2011-07-21 Thread Joaquin Orbe
On Thu, Jul 21, 2011 at 3:40 PM, Dave wrote: > This works great, but when i download the file it is missing the extension. > Is there an easy way to add '.xls' to the file name? > > Thanks, > Dave Hi Dave, how do you download the file? This method is an action in one controller, ie: http://127.0

Re: [web2py] web2py.com/poweredby / Quality Systems

2011-07-29 Thread Joaquin Orbe
On Fri, Jul 29, 2011 at 6:11 AM, JmiXIII wrote: > Hello, > > I was just having a look at web2py.com/poweredby and in particular Quality > Systems Tool: > http://www.qualitysystems.com > > It seems to me this tool is made with Plone instead of web2py did I > miss something ? > > Hello, why do