[web2py] DAL performance vs executesql

2012-06-21 Thread pbreit
I have an app where I pull down 5,000 records. I started with DAL and db.item.ALL and it was taking around 4 seconds. I added 5 fields to the select() which got it down to around 2 seconds. Then I implemented the same thing with executesql and got it down to 500 ms. So, selecting only the field

[web2py] how to write on the wall of Facebook Friends?

2012-06-21 Thread Amit
Hi, I have to develop one web2py application which can write on the wall of Facebook friends and send mail as well, how to achieve it in web2py? regards, Amit --

[web2py] Re: Parsing python from db fields?

2012-06-21 Thread Anthony
What OS are you using? Maybe try: {{import os}} {{from gluon.template import render}} {{=XML(render(blog.body, path=os.path.join(request.folder, 'views'), context=response._vars))}} Anthony On Friday, June 22, 2012 12:36:27 AM UTC-4, RKS wrote: > > Traceback: > > Traceback (most recent call la

Re: [web2py] Re: Users Poll: To keep the button look for the welcome app's auth options, or not ?

2012-06-21 Thread Alec Taylor
Thanks, I'll make those changes. But did you think it would also be a good change to commit to trunk? On Fri, Jun 22, 2012 at 4:26 AM, Paolo Caruccio wrote: > So you could modify #navbar in layout.html > > For example: > >   >  {{if auth.user_id:}} >  {{=auth.navbar(separators=(', ' , ' | ' , ''

[web2py] Re: Validation on all fields when updating only certain specific fields?

2012-06-21 Thread Osman Masood
Awesome, thanks for the clarification, Anthony. I thought hidden fields were normal fields processed by SQLFORM. I used the code you gave me and it works great...hope others can benefit from it too. Thanks On Thursday, June 21, 2012 6:33:29 PM UTC-7, Anthony wrote: > > candidate_form = SQL

[web2py] Creating users on checkout?

2012-06-21 Thread RKS
I'm using the standard users/login and users/register for normal operations; however, I want to include these functions in a checkout function. For the login, I've read up on auth.login but for the registration portion I have no idea where to look. I have defined checkout.html with a return(for

[web2py] Re: Parsing python from db fields?

2012-06-21 Thread RKS
Traceback: Traceback (most recent call last): File "gluon/restricted.py", line 205, in restricted File "/Applications/web2py.app/Contents/Resources/applications/dev/views/default/blogs.html", line 132, in File "gluon/template.py", line 919, in render File "gluon/template.py", l

[web2py] Re: Parsing python from db fields?

2012-06-21 Thread Anthony
Can you show the traceback and the database field content that produced that error? On Thursday, June 21, 2012 11:50:28 PM UTC-4, RKS wrote: > > Hmm. I'm going to try and play with this a little tonight and report back > tomorrow but on first try both these solutions return an error > 'NoneTyp

[web2py] Re: Parsing python from db fields?

2012-06-21 Thread RKS
Hmm. I'm going to try and play with this a little tonight and report back tomorrow but on first try both these solutions return an error 'NoneType' object has no attribute 'endswith' Don't know what that is but I'm digging in right now to find out. --

[web2py] Re: DAL IMAP errors

2012-06-21 Thread Alan Etkin
I reproduced the error with gpo2py, but I'm sure it's a bug in IMAPAdapter, as pyhead said. I'll try a patch as soon as possible. El jueves, 21 de junio de 2012 20:56:12 UTC-3, pyhead escribió: > > The test is being done on gmail IMAP. It must be a bug in IMAP DAL > implementation and not gpo2p

[web2py] Re: Args para URL en formulario

2012-06-21 Thread Alan Etkin
I opened the thread in the spanish language users list and answered to your post https://groups.google.com/group/web2py-usuarios/browse_thread/thread/08ed09635aef0ad7# El jueves, 21 de junio de 2012 14:26:32 UTC-3, Fernand

[web2py] problem with redirect using plugin_gmap

2012-06-21 Thread greaneym
I made an app called "testmap" using the plugin_gmap mentioned in an earlier post and this worked fine. But then I wanted to put the app inside of another app and am having problems with this. What ever I've tried causes the webp2y to quit. The new app is called "geoschool" and has the follow

[web2py] Re: contrib spreadsheet enhancement

2012-06-21 Thread Alan Etkin
The app is uploaded in the issues page http://code.google.com/p/web2py/issues/detail?id=860#c1 --

[web2py] Re: Validation on all fields when updating only certain specific fields?

2012-06-21 Thread Anthony
> > candidate_form = SQLFORM(db.candidate, candidate_record, > hidden={'ownerUserId': candidate_record.ownerUserId}) > > > > First, shouldn't that be name="ownerUserId" and candidate.ownerUserId? Note, hidden fields are not really part of the form object and do not get processed with

[web2py] Re: Validation on all fields when updating only certain specific fields?

2012-06-21 Thread Osman Masood
Thanks for all the help. I tried using a 'hidden' field but it still gives me the same error. This is my SQLFORM: candidate_form = SQLFORM(db.candidate, candidate_record, hidden={'ownerUserId': candidate_record.ownerUserId}) If I print candidate_record.ownerUserId, it returns 1 (successful

[web2py] Re: DAL IMAP errors

2012-06-21 Thread pyhead
The test is being done on gmail IMAP. It must be a bug in IMAP DAL implementation and not gpo2py itself. The mailbox was used by Mac Mail.app and has mailboxes with './\' characters in the names. Can anyone confirm? The IMAP RFC does not list these characters as prohibited http://www.faqs.or

[web2py] Re: Auto-generate PUT and DELETE methods

2012-06-21 Thread Anthony
Using my new Google Groups super powers, I have edited your original post, so if you'd like, you can delete this correction and we can pretend this never happened. ;-) Anthony On Thursday, June 21, 2012 6:40:37 PM UTC-4, Massimo

[web2py] Re: Validation on all fields when updating only certain specific fields?

2012-06-21 Thread Anthony
Are you saying you want to create a single form object on the server side that includes all the fields, but on the client side you want to break that up into several distinct forms, each of which would only submit one of the fields? If so, I'm not sure that's a common enough use case to warrant

[web2py] Re: Validation on all fields when updating only certain specific fields?

2012-06-21 Thread villas
If I don't want to see certain fields I suggest something like this: rec = db.thing(request.args(0)) db.thing.firstUserId.readable = db.thing.firstUserId.writable= False form = SQLFORM(db.thing, rec) But if that's not what you mean, take a look at the "hidden" parameter for SQLFORM too. e.

[web2py] Re: Auto-generate PUT and DELETE methods

2012-06-21 Thread Massimo Di Pierro
Silly me. This def PUT(table_name,record_id): return db(db[table_name]._id==record_id).delete() was supposed to be def DELETE(table_name,record_id): return db(db[table_name]._id==record_id).delete() On Thursday, 21 June 2012 13:38:01 UTC-5, Derek wrote: > > Looks like you have Get, Post, a

[web2py] Re: Parsing python from db fields?

2012-06-21 Thread Anthony
I see -- you want to be able to treat blog.body as a web2py template, not as HTML content or pure Python. Maybe try something like this: {{from gluon.template import render}} {{=XML(render(blog.body, context=response._vars))}} Or maybe use context=globals() if the template needs to access other

Re: [web2py] consider adding a div around error message

2012-06-21 Thread Richard Vézina
Of course I can do that, but to me it should not require I do that in the first place. I really think it a little glitch that is there for long time. I hope it's not causing a backward compatibility to correct it. If it brake old app and my suggested change is rejected, I will use your suggestion.

[web2py] Re: Scheduler won't run with request.requires_https()

2012-06-21 Thread Andrew
I guess these are new features. I just tried to read about them - would be good to see them added to the book (The core). On Friday, June 22, 2012 8:06:44 AM UTC+12, Anthony wrote: > > Would something like this work: > > cmd_options = request.global_settings.cmd_options > if not (cmd_options and

[web2py] Re: Multiple instances of an application-- shared controllers & views; different database

2012-06-21 Thread Niphlod
Links are allowed pretty anywhere... but some considerations are needed: - if you have a different connection string, the model with that needs to be different for each app - cache, uploads, cron, databases, errors, sessions are tied to the instance (you can't show cached values of app1 to users

[web2py] Re: Parsing python from db fields?

2012-06-21 Thread RKS
Yes. Inside the actual field I use HTML and python. If I use {{=XML(blog.body)}} then I can insert all the HTML I want inside that field from the db administration. Very helpful. But now I want to be able to insert {{=blog.title}} inside the blog.body field and when it renders int he view I wan

Re: [web2py] consider adding a div around error message

2012-06-21 Thread Paolo Caruccio
I usually make my customization of the form errors trough the controller. For example in your case I would do: form = SQLFORM(db.mytable,formstyle = 'divs') if form.process().accepted: response.flash = 'form accepted' elif form.errors: for fieldname in form.errors:

[web2py] Re: Small bug in ajax(u, t, s) function

2012-06-21 Thread Osman Masood
I ran into the same bug as well. The patch would work unless the attribute itself has quotes in it, which would need to be escaped: http://stackoverflow.com/questions/4015345/how-to-properly-escape-quotes-inside-html-attributes On Thursday, June 21, 2012 11:50:34 AM UTC-7, Thomas Le wrote: > > H

[web2py] Validation on all fields when updating only certain specific fields?

2012-06-21 Thread Osman Masood
Hey all, Was just wondering about thiscurrently web2py re-runs the form validations for every single field, even if you only update one field. For example, in the models file: db.define_table('user', format = '%(id)s') db.define_table('thing', Field('name', length=100), Field('type', length

[web2py] Re: Scheduler won't run with request.requires_https()

2012-06-21 Thread Yarin
Anthony and Niphlod- Thanks, two good solutions. Just tried Anthony's code and it's working. And yea I think that the scheduler should be tested for within requires_https() On Thursday, June 21, 2012 4:06:44 PM UTC-4, Anthony wrote: > > Would something like this work: > > cmd_options = request.

[web2py] Re: Parsing python from db fields?

2012-06-21 Thread Anthony
Are you saying the content of field.name is actually Python code that you want to execute right there within the template? In that case, maybe you could use Python eval or exec inside the {{...}}. Anthony On Thursday, June 21, 2012 2:27:48 PM UTC-4, RKS wrote: > > I have a table defined with so

[web2py] Re: Multiple instances of an application-- shared controllers & views; different database

2012-06-21 Thread Nate Atkinson
Hi, thanks It's a single instance of web2py on a single machine. There is a separate application for each branch. If doing this with links in the filesystem is the correct way, I was thinking I could write a small python script to copy what needs to be copied, link what needs to be linked, upd

[web2py] Re: Scheduler won't run with request.requires_https()

2012-06-21 Thread Anthony
Would something like this work: cmd_options = request.global_settings.cmd_options if not (cmd_options and cmd_options.scheduler): request.requires_https() Should we add a test for the scheduler to requires_https (and maybe add a global_settings.scheduler, like global_settings.cronjob): http

Re: [web2py] Re: Scheduler won't run with request.requires_https()

2012-06-21 Thread Niphlod
actually it's not possible, but as a hint, can't you enforce https at the webserver level ? Or, you could "protect" standard controllers putting request.requires_https() in those, so scheduler could access your tasks in models without "hitting" that wall. On Thursday, June 21, 2012 9:57:58 PM U

[web2py] Re: Multiple instances of an application-- shared controllers & views; different database

2012-06-21 Thread Niphlod
whoops, the above statement is true if you have different machines for every branch... reading more carefully it seems that you have n instances on the same machine. If so, are you running a single web2py instance with an application for every branch or multiple web2py running a single app for

Re: [web2py] Re: Scheduler won't run with request.requires_https()

2012-06-21 Thread Yarin Kessler
Massimo- I don't understand your answer- My question was about how to run scheduler WITH request.requires_https() turned on. Are you saying this is not possible? My main app needs https protection. My scheduler makes use of the db/models/methods of the main app, so what is your recommendation? Do

[web2py] Re: Multiple instances of an application-- shared controllers & views; different database

2012-06-21 Thread Niphlod
uhm, seems a pretty environment to let a revision control system managing it. you can use fabric to deploy automatically changes to all your "facilities". I use that and feels ok it's a bit daunting at first if you're not very well versed in unix commands, but once the script is done and

[web2py] Multiple instances of an application-- shared controllers & views; different database

2012-06-21 Thread Nate Atkinson
Hi, I'm running web2py v1.99.7 behind apache 2.2 on Ubuntu 12.04. I've written an application for work. It's web2py front end to a MySQL database. I am deploying multiple instances of the application for the different branches of our company. So, one instance for the Sacramento branch, one for

[web2py] Re: Error importing ldap_auth module

2012-06-21 Thread ehgonzalez
Ldap utilities works OK. For example: ldapsearch -x -h mycompany.com -b dc=mycompany,dc=com "(sAMAccountName=gonzalezej)". El jueves, 21 de junio de 2012 12:43:09 UTC-4:30, szimszon escribió: > > common ldap utilities are working? ldapsearch and co? > > 2012. június 21., csütörtök 17:34:45 UTC+2

Re: [web2py] consider adding a div around error message

2012-06-21 Thread Richard Vézina
I think the actual implementation works ok with anything but 'divs' form style (to be confirmed). I use divs style in my app and the error message box goes right trougth the right even if the error message is only one word. Richard On Thu, Jun 21, 2012 at 2:51 PM, RKS wrote: > An inline-block

Re: [web2py] consider adding a div around error message

2012-06-21 Thread RKS
An inline-block has auto-width and will stretch to fit the error message. I don't see why you need the extra div wrapper. You could also change your error message to be inline. On Friday, March 2, 2012 11:00:11 AM UTC-6, Richard wrote: > > Hello, > > Could we consider this change : > > Wrapping

[web2py] Small bug in ajax(u, t, s) function

2012-06-21 Thread Thomas Le
Hey guys, I found a small bug in the ajax function when you pass in field input names like "field[location]" or "blog[id]". So, if I have a form that looks like: Search Source: Resumes Open Web Location: Experience: Education: And I pass all the input field names through ajax(u,

[web2py] Re: Auto-generate PUT and DELETE methods

2012-06-21 Thread Derek
Looks like you have Get, Post, and PUT and PUT. Where's Delete? On Wednesday, June 20, 2012 4:39:33 PM UTC-7, Massimo Di Pierro wrote: > > You can do > > @request.restful() > def api(): > response.view = 'generic.'+request.extension > def GET(*args,**vars): > patterns = 'auto' >

[web2py] Re: contrib spreadsheet enhancement

2012-06-21 Thread Massimo Di Pierro
yes. please. thank you. On Thursday, 21 June 2012 11:45:03 UTC-5, Alan Etkin wrote: > > El jueves, 21 de junio de 2012 11:12:34 UTC-3, Massimo Di Pierro escribió: >> >> Love the new features. Do you have a patch yet? >> >> Mind one thing. Normally spreadsheets are rectangular. In web2py the >> sp

[web2py] Re: Scheduler won't run with request.requires_https()

2012-06-21 Thread Massimo Di Pierro
You have this line in request.requires_https() In myapp/models/db.py", line 10, in it prevents the scheduler form importing the modules. On Thursday, 21 June 2012 11:15:32 UTC-5, Yarin wrote: > > I can't get the scheduler to run when I turn on request.requires_https(). > > $ /opt/web-ap

Re: [web2py] Re: Mysql reserved words in a legacy db

2012-06-21 Thread Rene Dohmen
I did some reading in the list and several users had a problem with it. Quoting fieldNames in postgres sql is different for MySQL. Maybe a easy solution would be to add an extra optional parameter for the DAL connection statement? e.g. for MySQL: user_db = DAL('mysql://user:pass@localhost/legacy_d

[web2py] Parsing python from db fields?

2012-06-21 Thread RKS
I have a table defined with some old fashioned fields. When printing the fields in a view I use {{=XML(field.name)}} and so far this works great for all the HTML I've been putting in there all this time. Now I've come to a situation where I'm trying to print some python from a field. Might be

Re: [web2py] Re: Users Poll: To keep the button look for the welcome app's auth options, or not ?

2012-06-21 Thread Paolo Caruccio
So you could modify #navbar in layout.html For example: {{if auth.user_id:}} {{=auth.navbar(separators=(', ' , ' | ' , ''))}} {{else:}} {{='auth' in globals() and auth.navbar(separators=('' , ' | ' , '')) or ''}} {{pass}} When the user is logged in, after his/her name there will be a c

[web2py] Re: Error importing ldap_auth module

2012-06-21 Thread Derek
It looks like error 89 is being thrown by your ldap server, not from python. See here: http://www-01.ibm.com/support/docview.wss?uid=swg1IO13737 On Thursday, June 21, 2012 8:34:45 AM UTC-7, ehgonzalez wrote: > > You rigth, python version is 2.6.6. I copied ldap_auth.py from trunk but > it's t

Re: [web2py] consider adding a div around error message

2012-06-21 Thread Richard Vézina
I open a issue : http://code.google.com/p/web2py/issues/detail?id=861 On Thu, Jun 21, 2012 at 1:54 PM, Richard Vézina wrote: > Hello, > > This change have not been applied to 1.99.7. > > Is it in trunk? > > I would it to be included into the new release... > > Richard > > > On Thu, Apr 19, 2012

Re: [web2py] consider adding a div around error message

2012-06-21 Thread Richard Vézina
Hello, This change have not been applied to 1.99.7. Is it in trunk? I would it to be included into the new release... Richard On Thu, Apr 19, 2012 at 4:33 PM, Richard Vézina wrote: > Is this change proposal been include in the trunk?? > > Richard > > > On Fri, Mar 2, 2012 at 3:05 PM, Richard

[web2py] Args para URL en formulario

2012-06-21 Thread Fernando J
Hola Tengo un formulario en appadmin para dar de alta registros en una tabla En uno de los campos he de poner args para el HELPER URL En concreto, lo que quiero es meter un link y en algún caso que el href haga como en html cuando llamas a la propia página con "#" Gracias de antemano quien pueda

[web2py] Re: Error importing ldap_auth module

2012-06-21 Thread szimszon
common ldap utilities are working? ldapsearch and co? 2012. június 21., csütörtök 17:34:45 UTC+2 időpontban ehgonzalez a következőt írta: > > You rigth, python version is 2.6.6. I copied ldap_auth.py from trunk but > it's throwing same error. > > any ideas? > > El jueves, 21 de junio de 2012 10:

Re: [web2py] Re: Users Poll: To keep the button look for the welcome app's auth options, or not ?

2012-06-21 Thread Alec Taylor
Reading your code example highlights the problem. There is no | after "Welcome paolo" On Fri, Jun 22, 2012 at 2:32 AM, Paolo Caruccio wrote: > Alec, > > it seems that you aren't using last trunk. > > For example #navbar missed classes. In last trunk, indeed, we have: > > >     Welcome paolo >  

[web2py] Re: contrib spreadsheet enhancement

2012-06-21 Thread Alan Etkin
El jueves, 21 de junio de 2012 11:12:34 UTC-3, Massimo Di Pierro escribió: > > Love the new features. Do you have a patch yet? > > Mind one thing. Normally spreadsheets are rectangular. In web2py the > spreadsheet is a set of cells with names. They do not have to be displayed > in a rectangular s

Re: [web2py] Re: Users Poll: To keep the button look for the welcome app's auth options, or not ?

2012-06-21 Thread Paolo Caruccio
Alec, it seems that you aren't using last trunk. For example #navbar missed classes. In last trunk, indeed, we have: Welcome paolo http://127.0.0.1:8000/welcome/default/user/logout?_next=/welcome/default/index> ">Logout | http://127.0.0.1:8000/welcome/default/user/profi

Re: [web2py] Re: web2py hosting

2012-06-21 Thread Nico Zanferrari
> > They have improved http://www.pythonanywhere.com a lot. Now you can have a > free web2py application in few minutes and one mouse click - without any > configuration issue. And the https administrative interface is working > fine! --

[web2py] Scheduler won't run with request.requires_https()

2012-06-21 Thread Yarin
I can't get the scheduler to run when I turn on request.requires_https(). $ /opt/web-apps/web2py/web2py.py -K myapp Result: starting scheduler for "myapp"... > Currently running 1 scheduler processes > Processes started > Process Process-1: > Traceback (most recent call last): > File "/usr/li

Re: [web2py] Re: Users Poll: To keep the button look for the welcome app's auth options, or not ?

2012-06-21 Thread Alec Taylor
Confirmed, problem still exists. Here is the navbar code directly from the source generated (post-processing to prettify only): http://jsfiddle.net/ucYGN/ On Thu, Jun 21, 2012 at 7:58 PM, Paolo Caruccio wrote: > > Alec, > > could you replace the pipe with another character (i.e. "!") and see wh

Re: [web2py] Re: Key Error exception: 2 table test-case

2012-06-21 Thread Alec Taylor
On Fri, Jun 22, 2012 at 1:12 AM, Anthony wrote: >> That was an especially n00bish error on my part, thanks for pointing >> it out, but even though I've fixed it that same error is still >> occurring. >> >> Advise? > > > Same exact traceback? I don't think I saw any other fields that > mis-specifie

[web2py] Re: Error importing ldap_auth module

2012-06-21 Thread ehgonzalez
You rigth, python version is 2.6.6. I copied ldap_auth.py from trunk but it's throwing same error. any ideas? El jueves, 21 de junio de 2012 10:18:43 UTC-4:30, szimszon escribió: > > Try to use ldap_auth.py from trunk. Just copy it over the old one. > > You say Python 2.7.3 but in the error ther

Re: [web2py] Re: Key Error exception: 2 table test-case

2012-06-21 Thread Anthony
> > That was an especially n00bish error on my part, thanks for pointing > it out, but even though I've fixed it that same error is still > occurring. > > Advise? > Same exact traceback? I don't think I saw any other fields that mis-specified the type argument, but perhaps you should review a

[web2py] Re: How to play flv video files in web2py?

2012-06-21 Thread TheSweetlink
Perhaps you can store the encoded filename in the db rather than the original or add a new field to store newly encoded filename? video-js helped make playing vids easier. Best of luck, David On Tuesday, June 12, 2012 6:04:21 AM UTC-4, Charles Tang wrote: > > I am using web2py to play user's up

[web2py] Re: Upload filename - extension maintains original case

2012-06-21 Thread villas
Hi Anthony, Sorry I did not see your reply until now. The only thing I can propose is that the extension is also included in the encoding. The renamed filenames could then be totally lowercase which would be more logical (to me) at the expense of having the renamed filenames slightly longe

[web2py] Re: Error importing ldap_auth module

2012-06-21 Thread szimszon
Try to use ldap_auth.py from trunk. Just copy it over the old one. You say Python 2.7.3 but in the error there is a ... python2.6/dist-packages/ldap ... 2012. június 21., csütörtök 16:39:40 UTC+2 időpontban ehgonzalez a következőt írta: > > Hi, > > When I try to import the ldap_auth module in

[web2py] Error importing ldap_auth module

2012-06-21 Thread ehgonzalez
Hi, When I try to import the ldap_auth module in my db.py is throwing an error. Here's the traceback: Traceback (most recent call last): File "/var/www/web2pytest/gluon/restricted.py", line 205, in restricted exec ccode in environment File "/var/www/web2pytest/applications/SMS/models/db.

Re: [web2py] Re: Key Error exception: 2 table test-case

2012-06-21 Thread Alec Taylor
That was an especially n00bish error on my part, thanks for pointing it out, but even though I've fixed it that same error is still occurring. Advise? On Thu, Jun 21, 2012 at 11:56 PM, Anthony wrote: > Field('owner', auth.user, IS_NOT_EMPTY()) > > > The second argument to Field() is the type, bu

[web2py] Re: contrib spreadsheet enhancement

2012-06-21 Thread Massimo Di Pierro
Love the new features. Do you have a patch yet? Mind one thing. Normally spreadsheets are rectangular. In web2py the spreadsheet is a set of cells with names. They do not have to be displayed in a rectangular shape. They do not necessarily have rows and cols. Different cells for the same sheet

Re: [web2py] Re: Mysql reserved words in a legacy db

2012-06-21 Thread Massimo Di Pierro
You cannot handle it that way. In order to allow reserved keywords as table and field names we need changes in the dal source. massimo On Thursday, 21 June 2012 04:35:58 UTC-5, acidjunk wrote: > > I tried: > Field('`group`', ...), > AND > Field("'group'",...), > > Resulting in a ticket: > S

Re: [web2py] count a grouped select

2012-06-21 Thread Vasile Ermicioi
and how will do that in sql? and you will get the response try _select1 = db(query)._select(db.table.id,groupby) _count = db(db.table.id.belongs( _select1)).count() --

Re: [web2py] Re: Key Error exception: 2 table test-case

2012-06-21 Thread Anthony
Field('owner', auth.user, IS_NOT_EMPTY ()) The second argument to Field() is the type, but you have auth.user there. Also, your third argument is a validator, but "requires" is not the third positional argument to Field(), so that won't wor

[web2py] Re: Email form contents after submission

2012-06-21 Thread Anthony
Assuming you have defined the "mail" mailer object as in the "welcome" app db.py, something like this: if form.process().accepted: message = ''.join(['%s: %s' % (f, XML(form.vars[f], sanitize=True )) for f in db.suggestions.fields]) mail.send(to='ad...@yoursite.com', reply_to=form

[web2py] Re: Error viewing table due to invalid format!

2012-06-21 Thread Anthony
Can you show your exact web2py_ajax.html and IS_DATE() code? On Wednesday, June 20, 2012 3:12:15 PM UTC-4, rahulserver wrote: > > I changed the web2py ajax.html date format and also used the IS_DATE > constraint to get the date in dd-mm- format. When I submit the data via > sqlform, everythi

[web2py] Re: contrib spreadsheet enhancement

2012-06-21 Thread Alan Etkin
Screenshots showing the new features https://picasaweb.google.com/101593372917288717692/NewSpreadsheetFeaturesProposal?authuser=0&feat=directlink They were tested with the last stable version and the submitted patch. --

[web2py] count a grouped select

2012-06-21 Thread pkomor
There db(query).count(), but, what is the correct way to count the number of rows that have a grouped select, db(query).select(groupby)? Thanks --

[web2py] A typo in web2py Online Book (english)

2012-06-21 Thread Chun-Hung Chen
Hi, Just found a small typo but don't know where to report and the typo is in P.114 of PDF. def find_by(keyword): "finds pages that contain keyword for XML-RPC" return db(db.page.title.contains(keyword).select().as_list() There is a missing ')' after (keyword) Regards, Chun-Hung --

Re: [web2py] Python 3 is catching up to us...

2012-06-21 Thread LightDot
Luckily, it is now :) Red Hat EL = Scientific linux = CentOS version 5.x has python 2.4.3 version 6.x has python 2.6.6 Fedora 17 has python 2.7.3, while 3.x can be installed in parallel since Fedora 13. Just to note for anyone not aware how Red Hat works, all these older python versions get se

Re: [web2py] Python 3 is catching up to us...

2012-06-21 Thread Ralo Tannahill
CENTOS 6 (released in 2011) has python 2.6.6 Regards On Thursday, 21 June 2012 08:39:52 UTC+2, Manuele wrote: > > Il 21/06/2012 07:30, Jason (spot) Brower ha scritto: > > Not a big deal still at this point but wanted to point out: > > > http://www.noobslab.com/2012/06/ubuntu-1210-quantal-quetz

Re: [web2py] Re: Users Poll: To keep the button look for the welcome app's auth options, or not ?

2012-06-21 Thread Paolo Caruccio
Alec, could you replace the pipe with another character (i.e. "!") and see what happens? Il giorno giovedì 21 giugno 2012 06:13:01 UTC+2, Alec Taylor ha scritto: > > Confirmed. > > That pipe code is definitely there (just under the " href="#">web2py™ " line). > > On Thu, Jun 21, 2012 at 5:00

Re: [web2py] Re: Mysql reserved words in a legacy db

2012-06-21 Thread Rene Dohmen
I tried: Field('`group`', ...), AND Field("'group'",...), Resulting in a ticket: SyntaxError: only [0-9a-zA-Z_] allowed in table and field names, received `group` On Wed, Jun 20, 2012 at 10:29 PM, Cliff Kachinske wrote: > It occurs to me you might try this > > Field("'group'"), > > > > On We