[web2py] Grid documentation

2012-12-04 Thread Johann Spies
Can somebody please update the book's documentation about the grid. All the arguments for using the grid are not covered in the book. There is no documentation in the code for the grid options either. e.g. What is the content of the dicts createargs, viewargs, editargs supposed to be? Regards

[web2py] Disable hidden columns export in grid

2012-12-04 Thread szimszon
Hi All! I wonder if somebody could help me. How can I disable hidden column export in grid? --

[web2py] Re: Disable hidden columns export in grid

2012-12-04 Thread Niphlod
with trunk just pass exportclasses=dict(csv_with_hidden_cols=False, tsv_with_hidden_cols=False) On Tuesday, December 4, 2012 10:35:52 AM UTC+1, szimszon wrote: Hi All! I wonder if somebody could help me. How can I disable hidden column export in grid? --

[web2py] Re: Unable to send emails (mail.send) from server

2012-12-04 Thread Niphlod
BTW: all of these are showing that all of them return *False*! ...what python version are you using ? The first log shows that no SSL is available. Please print both server.result and server.error --

[web2py] Re: Disable hidden columns export in grid

2012-12-04 Thread szimszon
Nice and working feature :) Tnx. 2012. december 4., kedd 11:26:50 UTC+1 időpontban Niphlod a következőt írta: with trunk just pass exportclasses=dict(csv_with_hidden_cols=False, tsv_with_hidden_cols=False) On Tuesday, December 4, 2012 10:35:52 AM UTC+1, szimszon wrote: Hi All! I wonder

[web2py] Re: python web2py.py -S welcome doesn't work

2012-12-04 Thread Anthony
That's the syntax when running from source. If you're using one of the binaries, you should replace python web2py.py with web2py.exe or web2py.app. Anthony On Monday, December 3, 2012 8:24:54 PM UTC-5, Michael Feingold wrote: When I type: python web2py.py -S welcome It just says:

[web2py] Re: REF: Concatinate OPTIONS

2012-12-04 Thread Anthony
Don't use CAT inside SELECT - you don't need it there. Anthony On Tuesday, December 4, 2012 1:54:57 AM UTC-5, software.ted wrote: I am still playing with SELECT(OPTION()), am having a challenge adding a ---select--- option to a list of options generated from a table. I have this, when it

[web2py] informix standard engine

2012-12-04 Thread Wouter Pronk
I'm trying to connect web2py to Informix SE (standard engine) with some succes. I've edited dal.py and removed the following dbms_version = int(self.connection.dbms_version.split('.')[0]) if lmin and (dbms_version = 10): # Requires Informix 10.0+ sql_s

[web2py] Re: Unable to send emails (mail.send) from server

2012-12-04 Thread Aurelijus Useckas
Gmail server gives an error of: *No SSL support included in this Python* I'm using 2.6v of Python, doesn't it support it? ordinary server gives an error of: *STARTTLS extension not supported by server.* Would it be possible to somehow bypass the STARTTLS initialization? I'm good with simple

[web2py] options widget causing web2py to stall with a table with 300k records

2012-12-04 Thread onetwomany
I have a table A that is referenced by another B using the standard reference type in web2py. db.define_table('A', ... field('name') ... ) db.define_table('B', ... field('A', db.A) ... ) Previously, everything was working fine but after importing a sizeable amount of records (300k

[web2py] Re: web2py SQLFORM widget autocomplete and cyrillic letters

2012-12-04 Thread Dmitry Mosin
Fixed in 2.2.1 (2012-12-03 18:01:57) stable. Thank you, Massimo! --

[web2py] Re: Unable to send emails (mail.send) from server

2012-12-04 Thread Niphlod
On Tuesday, December 4, 2012 12:25:00 PM UTC+1, Aurelijus Useckas wrote: Gmail server gives an error of: *No SSL support included in this Python* I'm using 2.6v of Python, doesn't it support it? It should, in theory, if openssl headers are compiled into the distribution you have. That's

[web2py] Re: Unable to send emails (mail.send) from server

2012-12-04 Thread Aurelijus Useckas
Yes, I've turned the TLS off and now it works :) thanks for your very valuable tips! On Tuesday, December 4, 2012 1:45:41 PM UTC+2, Niphlod wrote: On Tuesday, December 4, 2012 12:25:00 PM UTC+1, Aurelijus Useckas wrote: Gmail server gives an error of: *No SSL support included in this

[web2py] Re: options widget causing web2py to stall with a table with 300k records

2012-12-04 Thread Niphlod
by default a Field('something', db.othertable) has attached an options widget that is generated by a requires=IS_IN_DB(db, 'othertable.id', format) If you don't want that select widget and you are fine with a normal string input, better to do something like Field('something', 'reference

Re: [web2py] Re: dashboard using bootstrap

2012-12-04 Thread Manuele Pesenti
Il 03/12/12 16:37, Richard Vézina ha scritto: I am not sure I understand your question. web2py bootstrap.js contain all the boostrap.js into one file. So you don't need to import anything else from bootstrap to create any bootstrap effect (just make sure you don't try to use something

[web2py] Re: V 2.2.1 linked_tables broken in smartgrid?

2012-12-04 Thread Rakesh Singh
Hi Apologies for the delayed response. The workaround suggested by the OP has worked in displaying the referenced column. My 2nd query may be un-related to this thread so I will post separately. Thanks Rakesh --

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Adnan Smajlovic
Just tested all four applications with nightly build and all works as expected. If we upgrade production, break it and start losing orders, it will be brutal here, but I'll scream for help... ;) On Tue, Dec 4, 2012 at 2:26 AM, Nico Zanferrari nicoz...@gmail.com wrote: I've notice yesterday

[web2py] Smartgrid searching a referenced column

2012-12-04 Thread Rakesh Singh
Hi, I am having an issue querying a referenced column using the smartgrid search widget. Let's say I have a table defined as follows: db.define_table('countries', Field('country_name', 'string', unique=True, required=True), format='%(country_name)s') Data 1 Austria 2

[web2py] How can I prevent MARKMIN to escape HTML tags from my text ?

2012-12-04 Thread David Marko
How can I prevent MARKMIN to escape HTML tags from my text ? I have a markmin text with br / tags but MARKMIN escapes all these tags. I tried XML(MARKMIN()) but it doesnt help as MARKMIN itself escapes the html (seems like). Is there a way how to avoid this? David --

Re: [web2py] Re: dashboard using bootstrap

2012-12-04 Thread Richard Vézina
About image and highchart I really don't know, but I think that if everything is html and SVG (possibily) it could resize esealy like any web page try on their site example CTRL + + and CTRL + - Richard On Tue, Dec 4, 2012 at 7:58 AM, Manuele Pesenti manuele.pese...@gmail.comwrote: e this[1]

Re: [web2py] Re: dashboard using bootstrap

2012-12-04 Thread Paolo Caruccio
For flot: put in yourapp/static/js jquery.flot.js and jquery.flot.resize.js (for scalability) usage in the view for example {{extend 'layout.html'}} h1{{=T('My first chart')}}/h1 script src={{=URL('static','js/jquery.flot.js')}}/script script

Re: [web2py] Re: ('web2py' in pycon.us.talks) == False

2012-12-04 Thread Alan Etkin
El martes, 4 de diciembre de 2012 01:35:56 UTC-3, Massimo Di Pierro escribió: Sorry. I should have clarified. I proposed a tutorial and a talk. They were rejected. I do not know if others have proposed talks on web2py. Too bad more talks on the subject should have been proposed. I want to

[web2py] Re: informix standard engine

2012-12-04 Thread Massimo Di Pierro
This is a similar problem as mssql which does not support pagination. I just committed to trunk a new adpater: DAL('informix-se://.') please give it a try and see if does what you need. You should be able to fix the problem just by tweaking the InformixSEAdapter and not the normal

[web2py] Re: options widget causing web2py to stall with a table with 300k records

2012-12-04 Thread Massimo Di Pierro
If the value of B.A comes from a A.id (represented by A.name) and you have 300,000 options, you probably do not want a dropdown but you want autocomplete. You just need: db.B.A.widget = SQLFORM.widgets.autocomplete(request, db.A.name, db.A.id) Massimo On Tuesday, 4 December 2012 01:03:39

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Massimo Di Pierro
Can you try again. The file is there but looks like it was not committed to git. Did you get from github? On Tuesday, 4 December 2012 01:26:45 UTC-6, Nico Zanferrari wrote: I've notice yesterday that the DEBUG button on the admin interface has problems: it always gives just the error invalid

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Massimo Di Pierro
This is the right attitude! On Tuesday, 4 December 2012 07:05:02 UTC-6, Adi wrote: Just tested all four applications with nightly build and all works as expected. If we upgrade production, break it and start losing orders, it will be brutal here, but I'll scream for help... ;) On Tue,

[web2py] Re: How can I prevent MARKMIN to escape HTML tags from my text ?

2012-12-04 Thread Massimo Di Pierro
You cannot. That is the point of MARKMIN. You can do MARMIN(text.replace('br/','\n\n')) On Tuesday, 4 December 2012 07:49:13 UTC-6, David Marko wrote: How can I prevent MARKMIN to escape HTML tags from my text ? I have a markmin text with br / tags but MARKMIN escapes all these tags. I

[web2py] Re: python web2py.py -S welcome doesn't work

2012-12-04 Thread Michael Feingold
Thank you both! Much helped. I was using ubuntu 12.10 64 bit by the way. Sorry about being a newb! On Monday, December 3, 2012 5:24:54 PM UTC-8, Michael Feingold wrote: When I type: python web2py.py -S welcome It just says: python: can't open file 'web2py.py': [Errno 2] No such file

Re: [web2py] Re: informix standard engine

2012-12-04 Thread Wouter Pronk
Hello Massimo, I wil try. Thank you very much! Op 04-12-12 15:49, Massimo Di Pierro schreef: This is a similar problem as mssql which does not support pagination. I just committed to trunk a new adpater: DAL('informix-se://.') please give it a try and see if does what you need. You

[web2py] Email validation url points to local host

2012-12-04 Thread Francisco Barretto
Hi there! Trying to use email validation for new users and stuck with a problem. Web2Py is running in its own container and listens localhost:8000. Apache is dealing with incoming requests at ports 80 and 443, since I've got other web applications and routes web2py requests to localhost:8000

[web2py] Re: Email validation url points to local host

2012-12-04 Thread Niphlod
http://web2py.com/books/default/chapter/29/09#Mail-and-Auth auth.messages.verify_email = 'Click on the link http://' + request.env.http_host + URL(r=request,c='default',f='user',args=['verify_email']) + '/%(key)s to verify your email' auth.messages.reset_password = 'Click on the

[web2py] Re: Email validation url points to local host

2012-12-04 Thread Francisco Barretto
Thanks, man! On Tuesday, December 4, 2012 1:10:55 PM UTC-2, Niphlod wrote: http://web2py.com/books/default/chapter/29/09#Mail-and-Auth auth.messages.verify_email = 'Click on the link http://' + request.env.http_host + URL(r=request,c='default',f='user',args=['verify_email']) +

[web2py] Re: Check if a from's boolean is true or false from the controller

2012-12-04 Thread Daniele
OK. So I removed what I had before (tables in a database) and moved to SQLFORM.factory. I now have this in my controller: form = SQLFORM.factory( Field('is_tutor', 'boolean'), Field('image', 'upload', requires=IS_EMPTY_OR(IS_IMAGE(extensions=('jpeg', 'jpg', 'png', 'gif',

[web2py] Re: informix standard engine

2012-12-04 Thread Derek
mssql 2005 and above has row_number which would allow pagination. On Tuesday, December 4, 2012 7:49:21 AM UTC-7, Massimo Di Pierro wrote: This is a similar problem as mssql which does not support pagination. I just committed to trunk a new adpater: DAL('informix-se://.') please give

[web2py] Re: Check if a from's boolean is true or false from the controller

2012-12-04 Thread Niphlod
if form.process().accepted: if form.vars.is_tutor: ...whatever, e.g. db.table.insert(**form.vars) How do you structure your db to save this data is up to your application: if you need this stored next to the auth_user table the recommended way is extending auth_user with

[web2py] Re: Unable to send emails (mail.send) from server

2012-12-04 Thread Aurelijus Useckas
one more question if I may, I'm trying to send email to my mailing list (around 1500 emails), bus I get a constant error: WARNING:web2py:Mail.send failure:{'some@email': (451, 'Sender rate 78.5 of 50 messages per 5m')} do you know what could be causing this? On Tuesday, December 4, 2012

[web2py] REF: IS_IN_SET tuple question

2012-12-04 Thread Teddy Nyambe
I have the following table: db.define_table('person', Field('title', requires = IS_IN_SET([('1','Mr'),('2','Mrs'),('3','Dr')]))) when I perform a query of added row, i get the value 1 or 2 or 3 of title instead of Mr or Mrs or Dr query = db(db.person).select() print query[0].title 2 ...how

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Richard Vézina
Hello, I just check the trunk and don't see any improvement at the dropmenu script level. I appreciate the little script to allow the bootstrap menu to works as superfish use to work, but actually they are pretty not usable in production. I explained, it may be possible that the problem I face

[web2py] Re: REF: IS_IN_SET tuple question

2012-12-04 Thread Anthony
The labels are not stored in the db -- they are only used for constructing the form input. To get the labels, you can do: db.person.title.requires.labels[query[0].title - 1] But maybe you should just store the labels themselves rather than integers. Anthony On Tuesday, December 4, 2012

[web2py] Re: Check if a from's boolean is true or false from the controller

2012-12-04 Thread Daniele
Thanks that was super helpful! On Tuesday, December 4, 2012 4:31:08 PM UTC, Niphlod wrote: if form.process().accepted: if form.vars.is_tutor: ...whatever, e.g. db.table.insert(**form.vars) How do you structure your db to save this data is up to your application: if you

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Richard Vézina
I found that just replacing delay() and fade*() by show() and hide() solve most problem. Here the code : // this code improves bootstrap menus and adds dropdown support jQuery(function(){ jQuery('.navlia').each(function(){ if(jQuery(this).parent().find('ul').length)

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Richard Vézina
This could be interesting add on : http://cherne.net/brian/resources/jquery.hoverIntent.html Richard On Tue, Dec 4, 2012 at 1:43 PM, Richard Vézina ml.richard.vez...@gmail.comwrote: I found that just replacing delay() and fade*() by show() and hide() solve most problem. Here the code : //

[web2py] Re: Check if a from's boolean is true or false from the controller

2012-12-04 Thread Daniele
Another question has come to mind...I have the following code in my controller now: if tform.process().accepted: if tform.vars.is_tutor: auth.add_membership('Tutors') db.auth_user.insert( a_bunch_of_fields = tform.vars.a_bunch_of_fields)

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Anthony
On Tuesday, December 4, 2012 1:49:24 PM UTC-5, Richard wrote: This could be interesting add on : http://cherne.net/brian/resources/jquery.hoverIntent.html Yes, that was used with the Superfish menu ( http://users.tpg.com.au/j_birch/plugins/superfish/#faq) -- makes a big difference. Anthony

[web2py] Re: Check if a from's boolean is true or false from the controller

2012-12-04 Thread Daniele
And the same goes for db.auth_user.insert() ... does it imply the logged user or not? On Monday, December 3, 2012 2:27:29 PM UTC, Daniele wrote: Hey guys, I'm wondering if there's a way from the controller to know whether a form's boolean field (checkbox) is selected or not. I only want to

[web2py] Re: Unable to send emails (mail.send) from server

2012-12-04 Thread Niphlod
talking about standards, the 451 error is labelled as Requested action aborted: local error in processing. that error that returns to you seems to pinpoint that you can only use that smtp to send a max of 50 messages in 5 minutes On Tuesday, December 4, 2012 6:09:23 PM UTC+1, Aurelijus Useckas

[web2py] Re: Unable to send emails (mail.send) from server

2012-12-04 Thread LightDot
The SMTP server you're using has restrains on the number of messages that can be sent in a certain time period. Also, make sure the provider's terms and conditions allow such usage so that you don't get suspended... In any case, these are not really errors and have nothing to do with web2py

[web2py] Re: Check if a from's boolean is true or false from the controller

2012-12-04 Thread Niphlod
depends on where do you use that kind of logic. If the user is already logged, you need to UPDATE the corresponding auth_user row with the data inserted, something among the lines of db(db.auth_user.id == auth.user_id).update(**form.vars) If instead you are requesting the user to fill that

[web2py] Re: informix standard engine

2012-12-04 Thread Massimo Di Pierro
Can you provide an example of usage? On Tuesday, 4 December 2012 10:23:14 UTC-6, Derek wrote: mssql 2005 and above has row_number which would allow pagination. On Tuesday, December 4, 2012 7:49:21 AM UTC-7, Massimo Di Pierro wrote: This is a similar problem as mssql which does not support

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Paolo Caruccio
I'm not the creator of the code in web2py_bootstrap.js that manages the dropdown behavior, I only added the code to adjust it on resize event. Originally the bootstrap dropdown hasn't a hover event (in this article the reasons explained

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Richard Vézina
I didn't check carefully how to integrate it. Does it as simple as just add a js file?? Richard On Tue, Dec 4, 2012 at 2:25 PM, Anthony abasta...@gmail.com wrote: On Tuesday, December 4, 2012 1:49:24 PM UTC-5, Richard wrote: This could be interesting add on :

Re: [web2py] Re: Unable to send emails (mail.send) from server

2012-12-04 Thread Aurelijus
thnx guys On Tue, Dec 4, 2012 at 10:11 PM, LightDot light...@gmail.com wrote: The SMTP server you're using has restrains on the number of messages that can be sent in a certain time period. Also, make sure the provider's terms and conditions allow such usage so that you don't get

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Richard Vézina
So, I did that in layout.html and it improves thing. The only little glitch is that subSubMenu are not displaying at the rigth place, they just show below the actual a hover element, they should appear beside this element. I try to figure out which piece of web2py_bootstrap.js is responsible of

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Richard Vézina
Got it! script src={{=URL('static','js/jquery.hoverIntent.minified.js')}}/script script type=text/javascript language=javascript charset=utf-8 // ![CDATA[ $(document).ready(function(){ jQuery('.navlia').each(function(){ if(jQuery(this).parent().find('ul').length)

[web2py] Booking Appliance??

2012-12-04 Thread greenpoise
Ok I deleted the previous post. I know there was a booking appliance available. Anyone has it? I need an example or something relevant to create something similar. I have playe around with the python module and its calendar but its taking me nowhere. Help! Thanks --

[web2py] Re: informix standard engine

2012-12-04 Thread Niphlod
*select id, first_name, last_name, email, password, registration_key, reset_password_key, registration_id from ( select ROW_NUMBER() over (order by id) AS total_ordering, id, first_name, last_name, email, password, registration_key, reset_password_key, registration_id from auth_user ) a where

[web2py] Comment MARKMIN source

2012-12-04 Thread Alan Etkin
I've searched the docs in the web but could not find anything useful. Is there a way to add comments to MARKMIN syntax preventing it to be rendered? i.e: I want this: ## My cheese shopping list - Gruyère /*They are probably out of this one*/ - Mozzarella /* No stock for this neither */ -

Re: [web2py] widget-select-or-add-option not working with web2py 2.0

2012-12-04 Thread Richard Vézina
There is a conflit with jquery ui dialog and bootstrap. I plan to look at it soon. I try replace jquery ui dialog by bootstrap modal by modal use to strip the embeded form tag don't know why. If you make some progress your input is appreciate Richard On Tue, Dec 4, 2012 at 12:59 AM, Naleen

Re: [web2py] web2py 2.3.1?

2012-12-04 Thread Nico Zanferrari
Il giorno martedì 4 dicembre 2012 15:56:31 UTC+1, Massimo Di Pierro ha scritto: Can you try again. The file is there but looks like it was not committed to git. Did you get from github? Yes, I've got it from github. And YES, it's already fixed. Sometimes I think you own a magic glass

[web2py] Re: Smartgrid searching a referenced column

2012-12-04 Thread Derek
I did a search on this error message and everything I saw said that there is some invalid data in the database (ie - the data doesn't match the schema). On Tuesday, December 4, 2012 6:34:00 AM UTC-7, Rakesh Singh wrote: Hi, I am having an issue querying a referenced column using the

[web2py] Re: informix standard engine

2012-12-04 Thread Massimo Di Pierro
OK. This is similar to how Oracle handles it too. How about this? class MSSQL3Adapter(MSSQLAdapter): def select_limitby(self, sql_s, sql_f, sql_t, sql_w, sql_o, limitby): if limitby: (lmin, lmax) = limitby return 'SELECT %s FROM (SELECT %s ROW_NUMBER() over

[web2py] Re: informix standard engine

2012-12-04 Thread Niphlod
uhm, aside from calculating the offset with lmin+1, I understand the effort on supporting this but . I explained why row_number is not a viable option: - orderby and limitby together will not play nice (ever :-P) and with this implementation: - you can't have an ORDER BY clause inside the

Re: [web2py] Re: Check if a from's boolean is true or false from the controller

2012-12-04 Thread Daniele Pestilli
How can I blank out all the **form.vars in the event that the form.vars.is_tutor returns false? Is there a simple way to do this or should I manually put in None for all the fields? On Tue, Dec 4, 2012 at 8:16 PM, Niphlod niph...@gmail.com wrote: depends on where do you use that kind of logic.

Re: [web2py] Re: Check if a from's boolean is true or false from the controller

2012-12-04 Thread Daniele Pestilli
There's some problem with what I'm doing now. I have form = SQLFORM.factory() with all the fields in my controller. In my db.py file, I am extending auth with auth.settings.extra_fields['auth_user']= [ Field http://127.0.0.1:8000/examples/global/vars/Field('t_image'), Field

[web2py] Re: Comment MARKMIN source

2012-12-04 Thread Massimo Di Pierro
````:comment MARKMIN(text, extra=dict(comment=lambda t:'')) On Tuesday, 4 December 2012 16:04:25 UTC-6, Alan Etkin wrote: I've searched the docs in the web but could not find anything useful. Is there a way to add comments to MARKMIN syntax preventing it to be rendered? i.e: I want

Re: [web2py] Re: Smartgrid searching a referenced column

2012-12-04 Thread Roberto Perdomo
The solution to this problem was resolved by Mike Leone and wait for the approval of Massimo. Conversation can be found here: https://groups.google.com/forum/?fromgroups=#!topic/web2py/xN0813r58N May soon be included in Web2py. 2012/12/4 Derek sp1d...@gmail.com I did a search on this error

Re: [web2py] User accessed site without logging in

2012-12-04 Thread Aurelijus Useckas
Hi Massimo, One of my users gets an error: Bad Request (request.client=unknown) Does it have anything to do with your update? Can I change the requirement somewhere? Thank you On Tuesday, July 24, 2012 11:26:21 PM UTC+3, Massimo Di Pierro wrote: Perhaps it would be safe to block access to