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

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 massimo.dipie...@gmail.com 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] processing upload field.

2012-02-06 Thread Joaquin Orbe
On Fri, Feb 3, 2012 at 11:58 AM, VP vtp2...@gmail.com 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

Re: [web2py] setting blank date in new widget

2011-09-27 Thread Joaquin Orbe
On Tue, Sep 27, 2011 at 4:55 PM, apple simo...@gmail.com 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

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

2011-07-29 Thread Joaquin Orbe
On Fri, Jul 29, 2011 at 6:11 AM, JmiXIII sylvn.p...@gmail.com 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 ?

Re: [web2py] export data to OOO and Excel

2011-07-21 Thread Joaquin Orbe
On Thu, Jul 21, 2011 at 3:40 PM, Dave davidramsayreinh...@gmail.com 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

Re: [web2py] export data to OOO and Excel

2011-07-20 Thread Joaquin Orbe
On Wed, Jul 20, 2011 at 5:45 AM, Vineet vineet.deod...@gmail.com 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

Re: [web2py] About auth.requires_membership()

2011-06-06 Thread Joaquin Orbe
On Mon, Jun 6, 2011 at 2:03 PM, Cesar Bustios cesarbust...@gmail.com 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

Re: [web2py] Re: Attribute Error

2011-04-10 Thread Joaquin Orbe
On Sun, Apr 10, 2011 at 11:07 AM, Anthony abasta...@gmail.com 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

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 massimo.dipie...@gmail.com wrote: yes. I do not know how to do it with one query. On Mar 30, 3:18 pm, Joaquin Orbe joaquino...@gmail.com wrote: On Sat, Mar 26, 2011 at 6:30 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote

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

2011-03-30 Thread Joaquin Orbe
(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 joaquino...@gmail.com wrote: Hi all, I'm trying

[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

[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 joaquino...@gmail.com wrote: Hi All, I

[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

[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: class 'pyodbc.ProgrammingError'(('42000', [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax

[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: class 'sqlite3.OperationalError'(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 joaquino...@gmail.com wrote: Hi all