[web2py:14100] Re: limitby with mssql - can this be added to the DAL?

2008-12-24 Thread mdipierro
Making some progress but I need your help. Given this: db.define_table('t1',SQLField('name')) db.define_table('t2',SQLField('t1',db.t1),SQLField('name')) Are these valid MSSQL Statements? 1) db(db.t1.id0)._select(orderby=db.t1.name,groupby=db.t1.name) 'SELECT t1.id, t1.name FROM t1

[web2py:14101] Re: reportlab in web2py?

2008-12-24 Thread carlo
It's too heavy.  Also, reportlab is a fairly low-level API.  Unless you're going to write a higher-level abstraction layer, it wouldn't fit in web2py.  Plus, most people will want to take advantage of the speedups (which can't be included in the source version of web2py). agree it has not

[web2py:14102] Re: reportlab in web2py?

2008-12-24 Thread carlo
Found Pisa thank you, very interesting. carlo On 23 Dic, 23:21, Timothy Farrell tfarr...@swgen.com wrote: easy_install reportlab dang, that's easy! ;-) mr.freeze wrote:It would be nice to have a feature system that allows either manual uploading (similar to the application upload) or

[web2py:14105] Re: Performance tips

2008-12-24 Thread Jonathan Benn
On Dec 23, 4:41 pm, mdipierro mdipie...@cs.depaul.edu wrote: in latest trunk, _lastsql on GAE is a string but only says select , delete, insert etc. Better than nothing for now. Thanks Massimo, and Happy Holidays! --Jonathan --~--~-~--~~~---~--~~ You received

[web2py:14106] Re: Performance tips

2008-12-24 Thread Jonathan Benn
Hi Vince, Dr. DiPierro wrote: db['_execute']=lambda *a,**b: timer(db,lambda:db._execute(*a,**b)) Look carefully at the line above, I believe that there may be an infinite recursion. When you try to call db._execute, the method will itself call db._execute and then once the thread tries to

[web2py:14107] Re: reportlab in web2py?

2008-12-24 Thread Timothy Farrell
Just like you would normally run a long-running process in web2py, os.spawn is my favorite (python offers numerous methods). But...do we really want a framework that installs software on demand (without prompting an admin)? I say, let's just leave it to the humans. It's one thing to make

[web2py:14108] Re: Database Synchronization Howto and UUID

2008-12-24 Thread Fran
On Dec 24, 12:25 pm, mdipierro mdipie...@cs.depaul.edu wrote: db.dog.owner.display=lambda id: db(db.person.id==id).select()[0].name and t2.displays(db.dog) will show you the owner's name not his id. Perfect - all is now sorted :) Many thanks, F

[web2py:14109] Re: Database Synchronization Howto and UUID

2008-12-24 Thread Fran
On Dec 24, 12:25 pm, mdipierro mdipie...@cs.depaul.edu wrote: db.dog.owner.display=lambda id: db(db.person.id==id).select()[0].name and t2.displays(db.dog) will show you the owner's name not his id. Oops, still have an issue here. If the owner field is blank for a record then this fails:

[web2py:14110] Re: limitby with mssql - can this be added to the DAL?

2008-12-24 Thread Mike
Hi Massimo - They all threw errors. I listed the errors and how I fixed them below. All of this was done directly in SQL SERVER 2005, but no test data. Thanks for taking a look at this! I hope this info helps... -- --STATEMENT 1 -- --ERROR --Msg 8120, Level 16,

[web2py:14111] Re: limitby with mssql - can this be added to the DAL?

2008-12-24 Thread mdipierro
Thank you. I will send another round of tests. Massimo On Dec 24, 10:16 am, Mike michael.mcgreg...@gmail.com wrote: Hi Massimo - They all threw errors. I listed the errors and how I fixed them below. All of this was done directly in SQL SERVER 2005, but no test data. Thanks for taking a

[web2py:14114] Re: reportlab in web2py?

2008-12-24 Thread pmate
Pisa is really nice, but i'm totally pro reportlab. It's true that it is a little heavy but it's a great solution for printing in web2py Paolo On Dec 24, 3:36 pm, Timothy Farrell tfarr...@swgen.com wrote: Just like you would normally run a long-running process in web2py, os.spawn is my

[web2py:14115] Re: MERRY CHRISTMAS ALL!

2008-12-24 Thread pmate
Merry Christmas to all of you and to your families. Let's hope it will bring to all a little more of peace. Paolo On Dec 23, 6:09 pm, Yarko Tymciurak yark...@gmail.com wrote: Whether you celebrate Christmas or not, I wish you all - Peace on Earth, and Goodwill amongst People... Thanks for

[web2py:14116] Re: MERRY CHRISTMAS ALL!

2008-12-24 Thread Tito Garrido
Merry Christmas Folks! On Wed, Dec 24, 2008 at 2:26 PM, pmate pmateh...@gmail.com wrote: Merry Christmas to all of you and to your families. Let's hope it will bring to all a little more of peace. Paolo On Dec 23, 6:09 pm, Yarko Tymciurak yark...@gmail.com wrote: Whether you celebrate