[web2py] Sum result in DAL

Hi - new to Web2py and the group. I'm building an app that will need to perform Sum and Max against large sets of data. As I'm getting familiar with the DAL, I've tried the following (and other combinations) rather than fall back to db.executesql. I'm getting the correct result but can't

[web2py] Re: Broken application after upgrade.

Just continues trying to connect to any application. The application is still under development. After your suggestion, I dumped my db and deleted everything from the databases folder. It's working now...not sure what exactly happened. On Tuesday, March 27, 2012 4:54:51 PM UTC-5, pbreit

[web2py] Re: Sum result in DAL

On Tuesday, March 27, 2012 6:25:16 PM UTC-4, go94025 wrote: Hi - new to Web2py and the group. I'm building an app that will need to perform Sum and Max against large sets of data. As I'm getting familiar with the DAL, I've tried the following (and other combinations) rather than fall

[web2py] Re: how to get logout() to launch an ajax call

So if I understand this correctly, and also by looking at gluon/tools, setting session.auth = None is tantamount to logging someone off. And auth.log_event(...) is the way to add an entry to the event logger. Sweet and simple. Yes? On Wednesday, March 28, 2012 9:05:38 AM UTC+8, Anthony wrote:

[web2py] Re: how to get logout() to launch an ajax call

So if I understand this correctly, and also by looking at gluon/tools, setting session.auth = None is tantamount to logging someone off. And auth.log_event(...) is the way to add an entry to the event logger. Sweet and simple. Yes? Yes, I believe so.

[web2py] Re: Sum result in DAL

works perfectly. thanks so much for the quick response and explanation. On Tuesday, March 27, 2012 6:43:45 PM UTC-7, Anthony wrote: On Tuesday, March 27, 2012 6:25:16 PM UTC-4, go94025 wrote: Hi - new to Web2py and the group. I'm building an app that will need to perform Sum and Max

[web2py] Re: Form validation on passwords

Thanks for the pointer. Anthony. So now I have the following in my controller: def register(): form = SQLFORM.factory( Field('email', requires=[IS_NOT_EMPTY(), IS_EMAIL(forced='^.*\.edu(|\..*)$' , error_message='email must be .edu address')]), Field('pwd', requires=[IS_NOT_EMPTY(),

[web2py] how to redirect from ajax

I'm trying to figure out how the proper syntax to redirect from an ajax call using HTTP(200,Location=URL(...)). The problem is the ajax call points to either an id or an :eval. But I want to refresh the entire page -- wiping the slate clean. Is this possible?

[web2py] Re: New Google Groups functionality

Excellent, thanks for sharing this. On Wednesday, March 28, 2012 5:42:17 AM UTC+8, Anthony wrote: One more thing -- on the far right of the post editing menu is a { } icon that allows you to format text as code. For example: def index(): return dict(message='Hello World') Anthony

[web2py] Re: @auth.requires(lambda: auth.has_membership(VCARD))

Wikus, Thanks for your reply. You need web2py = 1.99.3 for the lambda to work. Just upgraded from 1.99.2 to 1.99.7 and it works. Kind regards, Annet

[web2py] Primary Key tables in MSSQL. Cannot get them to work

Hello, I posted on this issue some time ago and I'm pretty sure it was working again after a fix from DenesL. However I can't get Primary Key tables in MSSQL to work. They get created OK, but I get errors with a Form in a view. I originally made the Key a string, but then switched to integer

<    1   2