[web2py] Re: play audio file from controller

2014-11-18 Thread LoveWeb2py
Quick update: When I type AudioFile.name it brings back the path, but it exposes the full path. There has to be a better way? I hope? On Tuesday, November 18, 2014 6:55:40 PM UTC-5, LoveWeb2py wrote: > > Thanks, Massimo! > > In my controller am I right in thinking I can have somethi

[web2py] Re: play audio file from controller

2014-11-18 Thread LoveWeb2py
Figured it out following this thread: https://groups.google.com/forum/#!searchin/web2py/response.download/web2py/KLK9i_7eNOc/BXTrCefrUtoJ Had to set args = to my db query.filename Thank you! On Wednesday, November 5, 2014 11:19:17 PM UTC-5, LoveWeb2py wrote: > > *Hello,* > > *I&#x

[web2py] Bug with submit button?

2014-11-19 Thread LoveWeb2py
This only seems to happen when I run a local copy of my appliance, but here it goes. First the code: controller: def submit_answer(): session.incorrect = False points = 0 responsejs=False tabTracker = False sound = None answer=FORM('Answer: ',

[web2py] Re: Bug with submit button?

2014-11-19 Thread LoveWeb2py
Hi Anthony, Yes - I confirmed the byte count and they're exactly the same. On Wednesday, November 19, 2014 10:16:39 PM UTC-5, Anthony wrote: > > Are you using the same version of web2py.js in both places? > > On Wednesday, November 19, 2014 9:50:26 PM UTC-5, LoveWeb2py wrote

[web2py] Re: Bug with submit button?

2014-11-20 Thread LoveWeb2py
2.9.11 On Thursday, November 20, 2014 6:04:15 AM UTC-5, Leonel Câmara wrote: > > What version is this? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) ---

[web2py] Possible to use CAS/Single Signon with custom auth_db?

2014-11-21 Thread LoveWeb2py
Hello, I'm trying to use Web2py's CAS feature and database cooperation. I tried to follow this article: http://www.web2pyslices.com/slice/show/1877/single-login-by-two-different-ways And it looks good, but what if I'm using custom authentication? The appliance found here: https://github.com/

[web2py] Re: Possible to use CAS/Single Signon with custom auth_db?

2014-11-23 Thread LoveWeb2py
1 PM UTC-5, Massimo Di Pierro wrote: > > If you add fields to auth_user than you can still use CAS. If you use your > own authentication logic, than I cannot say without more details. > > > > On Saturday, 22 November 2014 00:55:52 UTC-6, LoveWeb2py wrote: >> >>

[web2py] assign users to default group on register?

2014-11-25 Thread LoveWeb2py
Hello, Is there an easy way to assign users to a default group when registering? I'm going through the Auth source code and didn't see anything for the class developed. Any advice appreciated -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2

[web2py] Re: new feature in trunk: TODO panel in admin editor

2014-12-20 Thread LoveWeb2py
How do we add to the TODO panel? I've tried double clicking and looking for additional documentation but can't seem to find anything. On Sunday, December 8, 2013 4:36:00 AM UTC-5, Paolo Valleri wrote: > > Dear all, > the online editor has got a new TODO panel in which are listed all TODO > you m

[web2py] Re: new feature in trunk: TODO panel in admin editor

2014-12-21 Thread LoveWeb2py
Wow! Awesome. Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2

[web2py] Updated appliances or web2py blog?

2015-01-11 Thread LoveWeb2py
Hello, I'm looking to implement a nice blog for my site. I'd like to use a web2py appliance if there is one available. I went through the old appliances but they all seem fairly old. Is there an site which has a list of all the current web2py projects or more specifically blogs that I could im

[web2py] Include auth.user in XML?

2015-01-24 Thread LoveWeb2py
Hello, I have a simple app where I return data in XML and I'm wondering if I can also include auth.user. Here is some code: def questions(): response.title = None all_questions = questionsinmydatabase try: for question in all_questions: if question['id']==int(requ

[web2py] Re: Include auth.user in XML?

2015-01-25 Thread LoveWeb2py
Figured it out by following Massimo's advice in this thread: https://groups.google.com/forum/#!newtopic/web2py/web2py/rOEGF7jkJco Thanks, Massimo! On Saturday, January 24, 2015 at 3:42:13 PM UTC-5, LoveWeb2py wrote: > > Hello, > > I have a simple app where I return data in XML

[web2py] site went down for no reason on pythonanywhere

2015-01-28 Thread LoveWeb2py
receiving this error when I try to restart.. any thoughts? Type "help", "copyright", "credits" or "license" for more information.>>> from gluon import dalTraceback (most recent call last): File "", line 1, in File "gluon/__init__.py", line 21, in from compileapp import LOAD File "gluon/compile

[web2py] Re: site went down for no reason on pythonanywhere

2015-01-29 Thread LoveWeb2py
he service. Going to revert back to 2.9.11 On Thursday, January 29, 2015 at 6:23:21 AM UTC-5, Niphlod wrote: > > yep. you recently updated web2py and something "garbagy" has been left > there. Use a new clean 2.9.12 > > On Thursday, January 29, 2015 at 3:24:07 AM UTC+1, Lov

[web2py] web2py-menu-active li_active='active' help

2015-01-31 Thread LoveWeb2py
Hello, I tried following this example: http://web2py.com/books/default/chapter/29/05/the-views#MENU This thread: https://groups.google.com/forum/#!msg/web2py/Jc2qOVJ-Zws/yLzKdWb-y3cJ Is there a way in my menu to dynamically change the False to True based on request? I've tried following the ex

[web2py] Re: web2py-menu-active li_active='active' help

2015-01-31 Thread LoveWeb2py
That is perfect, Leonel! Very simple... Can't believe I didn't think of that on my own lol. Thanks again! On Saturday, January 31, 2015 at 9:44:29 PM UTC-5, Leonel Câmara wrote: > > Here's a real life working example in one of my apps > > response.menu = [ > (T('Home'), request.controller ==

[web2py] Search for fields with multiple values (list:string) in SQLFORM?

2015-02-23 Thread LoveWeb2py
Hello everyone, I really enjoy using the SQLFORM, however I've noticed when I convert fields to list:string I can no longer search by those specific fields. Is this something I could fix in SQLFORM? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/

[web2py] change edit button link in SQLFORM?

2015-02-26 Thread LoveWeb2py
I think this should be pretty easy, but I couldn't find how to edit the SQLFORM buttons in the documentation: http://web2py.com/book/default/chapter/07#SQLFORM-grid-and-SQLFORM-smartgrid Essentially I have a function I want the edit button to use instead of editing the record called in the SQL

[web2py] Re: change edit button link in SQLFORM?

2015-02-26 Thread LoveWeb2py
ry 26, 2015 at 3:30:07 PM UTC+1, LoveWeb2py wrote: >> >> >> I think this should be pretty easy, but I couldn't find how to edit the >> SQLFORM buttons in the documentation: >> http://web2py.com/book/default/chapter/07#SQLFORM-grid-and-SQLFORM-smartgrid >> &

[web2py] Resizable SQLFORM grid columns?

2015-03-04 Thread LoveWeb2py
Has anyone tried to tackle this before? I'd like to be able to resize the SQLFORM.grid columns so the user could expand or contract the column similar to excel. I'm guessing I'll have to use jquery for this? If anyone could point me in the right direction to get started I'd really appreciate

[web2py] Re: Resizable SQLFORM grid columns?

2015-03-04 Thread LoveWeb2py
iewing-and-updating-data > > > On Wednesday, March 4, 2015 at 8:29:45 AM UTC-5, LoveWeb2py wrote: >> >> Has anyone tried to tackle this before? >> >> I'd like to be able to resize the SQLFORM.grid columns so the user could >> expand or contract the column

[web2py] Re: Resizable SQLFORM grid columns?

2015-03-04 Thread LoveWeb2py
Although I do like the layout of jqgrid I'm also using custom buttons in the sqlform.grid and have links going back to database versioning. I will give jqgrid a shot, but I'd love to hear other thoughts/ideas. On Wednesday, March 4, 2015 at 9:00:52 AM UTC-5, LoveWeb2py wrote: >

[web2py] PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-10 Thread LoveWeb2py
Hello, I'm wondering how to get the users details when they visit my site over SSL. I'm guessing I'll have to parse out the information through the WSGI handler? If anyone has insight or could provide direction I'd really appreciate it. -- Resources: - http://web2py.com - http://web2py.com/bo

[web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-10 Thread LoveWeb2py
ough uwsgi properly? Do I need to put something in the wsgi-handler, change my httpd.conf, or something else? On Tuesday, March 10, 2015 at 2:53:58 PM UTC-4, LoveWeb2py wrote: > > Hello, > > I'm wondering how to get the users details when they visit my site over > SSL. I'm

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-10 Thread LoveWeb2py
Is M2Crypto in my wsgi handler? I have the module installed if that's what you mean. On Tuesday, March 10, 2015 at 3:35:17 PM UTC-4, Richard wrote: > > Is M2Crypto there?? > > Basic, but you know... > > On Tue, Mar 10, 2015 at 3:18 PM, LoveWeb2py > wrote: > >&

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-10 Thread LoveWeb2py
ere?? >> >> Basic, but you know... >> >> On Tue, Mar 10, 2015 at 3:18 PM, LoveWeb2py > > wrote: >> >>> Just the basic stuff like first name and last name. But when I try to >>> login using the x509 tutorial in the book I am getting Login not allowed.

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-10 Thread LoveWeb2py
browser, mod_wsgi, wsgi_handler.py or my httpd.conf On Tuesday, March 10, 2015 at 3:57:12 PM UTC-4, LoveWeb2py wrote: > > *httpd* - Apache Hypertext Transfer Protocol Server > > my httpd.conf has the certificates and is serving https out properly, I > just can't seem to read t

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-10 Thread LoveWeb2py
_SERIAL > etc etc etc > > Apache docs mention that those should be enabled setting the directive > > SSLOptions +stdEnvVars > > > > > On Tuesday, March 10, 2015 at 9:57:01 PM UTC+1, LoveWeb2py wrote: >> >> The main problem is that when I set auth.settings.l

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-10 Thread LoveWeb2py
so I did {{=request.env}} and I can see the SSL DATA certificate in another app, but for some reason the app that requires the data isn't being passed. Going to keep troubleshooting that app because I really want to use the x509 authentication with web2py!! for some reason the x509 auth isn't w

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-11 Thread LoveWeb2py
there! :) I'll post the fix when I find it On Tuesday, March 10, 2015 at 7:56:45 PM UTC-4, Niphlod wrote: > > debug it, debug it, debug it. > > AFAICS, x509_auth.py requires: > > ssl_client_raw_cert > optional ssl_client_serial > > On Wednesday, March 11, 2015 a

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-11 Thread LoveWeb2py
; #SSLVerifyClient require > #SSLVerifyDepth 10 > > > 2015-03-11 12:27 GMT+01:00 LoveWeb2py >: > >> Those are exactly the two I don't have so far from the list I saw in >> another post I have: >> >> SSL_CIPHER, SSL_

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-11 Thread LoveWeb2py
Also make sure to have these settings in your virtualhost SSLEngine On SSLOptions +stdEnvVars To verify the variables are being passed properly look at {{=request.env}} in a view and look for SSL variables. On Wednesday, March 11, 2015 at 8:22:15 AM UTC-4, LoveWeb2py wrote: > > Thank

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-11 Thread LoveWeb2py
none, > optional, > # require and optional_no_ca. Depth is a number which specifies > how deeply > # to verify the certificate issuer chain before deciding the > certificate is > # not valid. > #SSLVerifyClient require > #SSLVerifyDe

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-12 Thread LoveWeb2py
; You can read any of the fields a certificate contains eventually. >>> see here for some ideas: https://code.google.com/p/simpatica/ >>> >>> It's a working PKI that allows to generate csr and sign them with a >>> valid signin certificate >>> >

Re: [web2py] Re: PKI Authentication? How to grab users certificates httpd > wsgi

2015-03-12 Thread LoveWeb2py
() if that equals none then enter their data with the account pending, else just pass, but pending doesn't work either. On Thursday, March 12, 2015 at 10:10:33 AM UTC-4, LoveWeb2py wrote: > > @dps - I agree comments should be added. I'll put together a detailed > descript

[web2py] max size table that DAL can handle?

2015-03-16 Thread LoveWeb2py
I'm trying to select a SQL Table that has 1 million + records. my_table = db(db.my_large_table.id>0).select() My python thread hangs and eventually I have to kill it (otherwise it takes forever). Is there a more efficient way to make the query or is this a limitation for web2py? -- Resources:

[web2py] Re: max size table that DAL can handle?

2015-03-16 Thread LoveWeb2py
Thank you for the feedback everyone. The main reason I fetch them all first is to make sure I'm not inserting duplicate records. We have a lot of files that have thousands of records and sometimes they're duplicates. I hash a few columns from each record and if the value is the same then I don'

[web2py] Re: max size table that DAL can handle?

2015-03-17 Thread LoveWeb2py
te table). Instead of > fetching n rows * number of columns values, and then hash it, you fetch the > hashed value already. > > On Tuesday, March 17, 2015 at 12:14:20 AM UTC+1, LoveWeb2py wrote: >> >> Thank you for the feedback everyone. >> >> The main reason

[web2py] Re: max size table that DAL can handle?

2015-03-17 Thread LoveWeb2py
icates from the json, recreate the dictionary record, append it to a list, and then bulk_insert from there. I'm using MySQL is there a preferred way to handle bulk_inserts over web2py? On Monday, March 16, 2015 at 7:58:15 PM UTC-4, Dave S wrote: > > > > On Monday, March 16, 2015

[web2py] Re: max size table that DAL can handle?

2015-03-17 Thread LoveWeb2py
Please forgive me if I'm interpreting your message incorrectly, but are you saying MySQL is not a "serious" database? What DB do you recommend? On Tuesday, March 17, 2015 at 3:58:29 PM UTC-4, Niphlod wrote: > > an ON INSERT trigger usually happens at the moment you're about to insert > a new re

[web2py] Re: "internal error: [Errno 1] Operation not permitted" when attempting Pack All

2015-03-17 Thread LoveWeb2py
Check your file permissions. Are you using windows or linux? On Tuesday, March 17, 2015 at 8:17:46 PM UTC-4, Tom Campbell wrote: > > Attempting to do a Manage > Pack All on a project but I get this message: > > messageinternal error: [Errno 1] Operation not permitted: > > I am attempting to

[web2py] Best way to rearrange sqlgrid columns?

2015-03-20 Thread LoveWeb2py
Is there an easier way to change the column order without re-arranging the model defined in db.py? Here is what I'd like to do: Col A, Col B, Col C How could I have Col C, Col A, Col B or whatever order I want. I have the same table I'd like to present in different ways. Thanks! -- Resour

[web2py] Re: Best way to rearrange sqlgrid columns?

2015-03-20 Thread LoveWeb2py
t 11:44:15 AM UTC-4, Massimo Di Pierro wrote: > > You can pass a list of fields to the grid. > > On Friday, 20 March 2015 10:25:03 UTC-5, LoveWeb2py wrote: >> >> Is there an easier way to change the column order without re-arranging >> the model defined in db.py? >&g

[web2py] Re: Menu helper and controller

2015-03-20 Thread LoveWeb2py
Try this: routers = dict( BASE = dict( default_application = 'application', default_controller = 'default', default_function = 'index', ), ) On Friday, March 20, 2015 at 2:54:01 PM UTC-4, Gael Princivalle wrote: > > Hello all. > > With an app my URL is my_do

[web2py] Re: Install in hostgator

2015-03-22 Thread LoveWeb2py
Did anyone ever find a complete solution to this? I'm using web2py on hostgator and after following this tutorial I can only get my app to work if I name it init. Also, if I try to access another controller for example: www.mysite.com/controller/ I get a 404 error. Does this have something to d

[web2py] Re: returning data to web page div (Partly Solved)

2015-03-23 Thread LoveWeb2py
Wouldn't a LOAD/Ajax combo work better in this case and then just include it in your page? On Monday, March 23, 2015 at 8:41:18 AM UTC-4, Garry Smith wrote: > > Hi thanks for the reply. > > What I was trying to do in the original code was return the data to a div > not to a specified page, so wh

[web2py] Re: returning data to web page div (Partly Solved)

2015-03-23 Thread LoveWeb2py
http://web2py.com/books/default/chapter/29/12/components-and-plugins#Components--LOAD-and-Ajax On Monday, March 23, 2015 at 12:19:34 PM UTC-4, LoveWeb2py wrote: > > Wouldn't a LOAD/Ajax combo work better in this case and then just include > it in your page? > > On Monday, Ma

[web2py] Re: Limit view of posts online

2015-03-23 Thread LoveWeb2py
Hi Maurice, You could do something like this: user_posts = db(db.user_posts.posted_by==db.auth_user.id).select(db.user_posts.ALL) then show that data to just the user. Kind of hard to structure without seeing your database model. On Monday, March 23, 2015 at 12:10:22 PM UTC-4, Maurice Waka

[web2py] Example of how to use slickgrid with Web2py?

2015-03-23 Thread LoveWeb2py
Hello, I'm looking for any example of how to use the slick grid with web2py which includes posting the data back to the database. I'm trying to use it to replace smartgrid for one of my projects where we have a large database. Thanks! -- Resources: -

[web2py] Can't access .pem file from web2py controller?

2015-03-24 Thread LoveWeb2py
Hello, I'm trying to run a quick check on user access with our company server. If I run the script normally I can make the query fine, but when I use web2py I get an Errno 336265218 _ssl.c: 341 SSL routines:SSL_CTX_use_PrivateKey_file:system lib mypemfile = '/etc/mypath/to/key.pem' In other

[web2py] Re: Can't access .pem file from web2py controller?

2015-03-24 Thread LoveWeb2py
Please disregard. I was opening the file instead of directing it to the path. Complete user error here *embarrassed face* On Tuesday, March 24, 2015 at 7:18:34 AM UTC-4, LoveWeb2py wrote: > > Hello, > > I'm trying to run a quick check on user access with our company server

[web2py] Re: Example of how to use slickgrid with Web2py?

2015-03-25 Thread LoveWeb2py
More specifically this is what I'm trying to do: http://mleibman.github.io/SlickGrid/examples/example4-model.html On Monday, March 23, 2015 at 2:24:55 PM UTC-4, LoveWeb2py wrote: > > Hello, > > I'm looking for any example of how to use the slick grid > <https://g

[web2py] Allow user to create custom view of SQLFORM grid?

2015-03-26 Thread LoveWeb2py
Lets say I have a grid with 10 columns. I want the user to be able to define which columns they want to see. I'm thinking of having check boxes at the top of the sqlform grid. Their preferences could be stored in a table and retrieve the fields based on their selection. Question: Is this the

[web2py] Re: Allow user to create custom view of SQLFORM grid?

2015-03-26 Thread LoveWeb2py
Thanks, Jim! Sometimes it helps just to get a sanity check. On Thursday, March 26, 2015 at 12:14:14 PM UTC-4, Jim S wrote: > > That's probably how I'd approach it... > > -Jim > > On Thursday, March 26, 2015 at 6:13:24 AM UTC-5, LoveWeb2py wrote: >> >>

[web2py] sqlform based on userid? How to let each user have their own SQLFORM?

2015-03-27 Thread LoveWeb2py
Hello, I have a database with a few hundred users. How could I allow them to each have their own SQLFORM without modifying auth.user here is what I have so far: #model db.define_table('unique_view_peruser',' Field('auth_user_id',' db.auth_user, default=auth.user_id, writable=False),

Re: [web2py] sqlform based on userid? How to let each user have their own SQLFORM?

2015-03-27 Thread LoveWeb2py
; On Fri, Mar 27, 2015 at 9:59 AM, Richard Vézina > wrote: > >> You mean a profile page with user only allow to update their profile ?? >> >> SQLFORM(db.auth_user, record=*auth.user_id*) >> >> It is not clear to understand your goal... >> >> Richard >

Re: [web2py] sqlform based on userid? How to let each user have their own SQLFORM?

2015-03-27 Thread LoveWeb2py
gt; SQLFORM(db.unique_view_peruser, record=prefs_id) > > You should be ok to update the right record instead of create a new one... > > Richard > > On Fri, Mar 27, 2015 at 10:12 AM, LoveWeb2py > wrote: > >> Hi Richard, >> >> Thank you for responding. >&

Re: [web2py] sqlform based on userid? How to let each user have their own SQLFORM?

2015-03-27 Thread LoveWeb2py
Ahhh that makes great sense. Learn something new all the time. Thank you, Richard! right now here is my code: def unique_view(): prefs_id = db(db.unique_view_peruser.auth_user_id == auth.user_id). select(db.unique_view_peruser.id) if len(prefs_id) == 1: prefs_id = prefs_id.id

Re: [web2py] sqlform based on userid? How to let each user have their own SQLFORM?

2015-03-27 Thread LoveWeb2py
response.flash = 'please fill the form' > > > Also, instead of calling your form "grid" why use missleading variable > name... Call it "form" > > If you keep grid, change the variable name accordingly in the aboce code > extract from the bo

[web2py] fields strings to variable for fields=fields

2015-03-27 Thread LoveWeb2py
having trouble with the SQLFORM.smartgrid fields section Fields only takes fields = [db.mytable.field1, db.mytable.field2] I have a function that returns all the fields to be returned, but they're in strings format. fields = ['db.mytable.field1', 'db.mytable.field2'] #this returns an error w

[web2py] Re: fields strings to variable for fields=fields

2015-03-27 Thread LoveWeb2py
ields=fields Thanks everyone!1 On Friday, March 27, 2015 at 3:35:57 PM UTC-4, JorgeH wrote: > > > have you tried eval ?? > > fields = [eval ('db.mytable.field1') , eval ('db.mytable.field2') ] > > > > > > (just a suggestion. I didn't tr

[web2py] validators don't work on list

2015-03-30 Thread LoveWeb2py
Hello, When using a list:string my validators don't work like they used to on a regular string. For example if I had requires=IS_ALPHANUMERIC() when I input 1234568--/ I would receive an error but when I switched my field type from string to list:string I can now put anything in the field such

[web2py] Re: validators don't work on list

2015-03-30 Thread LoveWeb2py
nthony > > On Monday, March 30, 2015 at 9:23:01 AM UTC-4, LoveWeb2py wrote: >> >> Hello, >> >> When using a list:string my validators don't work like they used to on a >> regular string. For example if I had requires=IS_ALPHANUMERIC() >> >> when

[web2py] Re: validators don't work on list

2015-03-30 Thread LoveWeb2py
at 12:12:15 PM UTC-4, Anthony wrote: > > Can you clarify the problem? Are you talking about the advanced search > form in the grid? What exactly is the issue? > > On Monday, March 30, 2015 at 11:29:54 AM UTC-4, LoveWeb2py wrote: >> >> Thank you, Anthony! This solved

[web2py] Re: validators don't work on list

2015-03-30 Thread LoveWeb2py
h 30, 2015 at 12:17:09 PM UTC-4, LoveWeb2py wrote: >> >> Hi Anthony, >> >> Yes I'm talking about the advanced search form in the grid. >> >> When you set a field type to list:string you no longer have the ability >> to select the field from the dr

[web2py] PyCon Canada 2015

2015-04-06 Thread LoveWeb2py
Anyone going? https://us.pycon.org/2015/ -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Goog

[web2py] Two SQLFORMs side by side?

2015-04-16 Thread LoveWeb2py
Hello, I'd like to have two SQLFORMs right next to each other. The second SQLFORM is just going to be linked to the field in table 1, but will be used so the student can make additional comments about a field. Model will look like this: db.define_table('main_table', Field('field1','st

Re: [web2py] Two SQLFORMs side by side?

2015-04-16 Thread LoveWeb2py
not finish yet) in order to move from jquery ui dialog to bootstrap > modal... I will publish a web2py slice when done. > > Just ask if it interest you I can publish preview here... > > Richard > > On Thu, Apr 16, 2015 at 2:08 PM, LoveWeb2py > wrote: > >> Hello,

[web2py] Visiting One SQLFORM.grid triggers another SQLFORM.grid -- bug?

2015-04-22 Thread LoveWeb2py
Hello, I have somewhat of a weird error and I'm not sure how to fix it. Let's say I have two controllers: def controller1(): grid1 = SQLFORM.grid(db.table1) return locals() def controller2(): grid2 = SQLFORM.grid(db.table2) return locals() The user visits controller1 and cl

[web2py] Re: Visiting One SQLFORM.grid triggers another SQLFORM.grid -- bug?

2015-04-22 Thread LoveWeb2py
22, 2015 at 3:15:25 PM UTC+2, LoveWeb2py wrote: >> >> Hello, >> >> I have somewhat of a weird error and I'm not sure how to fix it. >> >> Let's say I have two controllers: >> >> def controller1(): >> grid1 = SQLFORM.grid(db.tabl

[web2py] Re: Visiting One SQLFORM.grid triggers another SQLFORM.grid -- bug?

2015-04-22 Thread LoveWeb2py
Setting formname in SQLFORM.grid(db.table1, formname='table1') did the trick! Thanks again, Niphlod! On Wednesday, April 22, 2015 at 10:04:12 AM UTC-4, LoveWeb2py wrote: > > Thanks, Niphlod! Should I define that like this? > > In SQLFORM.grid(db.table1, formname="

[web2py] create another comment field?

2015-04-22 Thread LoveWeb2py
I really enjoy using the comment="this is my comment". I have been using it to create info boxes. Is there a way I could create another variable field for example comment2="this is my additional comment?" -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github

Re: [web2py] create another comment field?

2015-04-22 Thread LoveWeb2py
I guess that could work. I'll give that a shot. Thanks, Richard! On Wednesday, April 22, 2015 at 4:30:25 PM UTC-4, Richard wrote: > > what about comment='[comment1, comment2]' > > And you process accordingly... > > Richard > > On Wed, Apr 22, 2015 at 4:17

[web2py] How to process SQLFORM.grid edit forms?

2015-04-22 Thread LoveWeb2py
I have a widget I'm using in my comment field creates a Modal pop up. However, I quickly realized I have no way to process the modal without the use of web2py forms I've looked through the book and multiple post, but didn't see anything similar. Is there a way I could process the modal form fro

Re: [web2py] Two SQLFORMs side by side?

2015-04-28 Thread LoveWeb2py
n Friday, April 17, 2015 at 9:50:15 AM UTC-4, Richard wrote: > > 'reference tablename' = 1 to many > 'list:reference tablename' = "many to many" it denormalised that why I put > it between double quotes > > Richard > > On Thu, Apr 16, 2015

Re: [web2py] Two SQLFORMs side by side?

2015-04-28 Thread LoveWeb2py
dy instead... > > This is basically what jQuery Dialog is doing out of the box which > boostrap modal don't that make the usage of modal with component in web2py > so difficult... > > :) > > Richard > > > On Tue, Apr 28, 2015 at 12:40 PM, LoveWeb2py > wrote: &g

Re: [web2py] Two SQLFORMs side by side?

2015-04-28 Thread LoveWeb2py
because the form can't process properly. I'm struggling to solve that last piece of the puzzle. When I On Tuesday, April 28, 2015 at 4:50:34 PM UTC-4, LoveWeb2py wrote: > > Thank you, Richard. Where do I put $("#{modal_id}").appendTo(" > body"); > >

Re: [web2py] Two SQLFORMs side by side?

2015-04-28 Thread LoveWeb2py
oad form has to be put outside the > main form... > > I try the ressource you are using and give up because it was not full fill > all my requirement... > > Richard > > On Tue, Apr 28, 2015 at 4:54 PM, LoveWeb2py > wrote: > >> This is what I'm using in my layou

Re: [web2py] Two SQLFORMs side by side?

2015-04-28 Thread LoveWeb2py
I can share the code here... > > Richard > > On Tue, Apr 28, 2015 at 5:06 PM, LoveWeb2py > wrote: > >> What do you use as a replacement? >> >> On Tuesday, April 28, 2015 at 4:59:32 PM UTC-4, Richard wrote: >>> >>> in view in script tag is a good plac

Re: [web2py] Two SQLFORMs side by side?

2015-05-05 Thread LoveWeb2py
t; > # In a model (a model file which is already call before you set your > widget...) > from a_widget import AutocompleteWidgetSelectOrAddOption > > *# In your controller * > > def add_function(): > """ > Modal form for adding element > "&qu

Re: [web2py] Two SQLFORMs side by side?

2015-05-06 Thread LoveWeb2py
ake it works... > > In the module I have these imports : > > from gluon.html import * > from gluon.sqlhtml import * > from gluon import current > from gluon.compileapp import LOAD > > > Which may not be related to the widget class... > > Richard > > &

Re: [web2py] Two SQLFORMs side by side?

2015-05-07 Thread LoveWeb2py
function="your add > function name", > button_text=T('Add new'), > placeholder=T('Start > typing...')) > > Richard > > On Wed, May 6, 2

Re: [web2py] Two SQLFORMs side by side?

2015-05-07 Thread LoveWeb2py
add_trigger" ).css("margin-left", > "+=5"); ' \ > '});' % (my_select_id) > js += > '$("#{modal_id}").appendTo("body");'.format(modal_id=my_select_id > + "_modal-form") > >> >&

Re: [web2py] Two SQLFORMs side by side?

2015-05-07 Thread LoveWeb2py
web2py 2.9.5 which is what I use actually and it works... > > Richard > > On Thu, May 7, 2015 at 9:20 AM, LoveWeb2py > wrote: > >> Another observation: >> >> All of this code: >> >> >> >>> js += '$(function() {' \

Re: [web2py] Two SQLFORMs side by side?

2015-05-11 Thread LoveWeb2py
would suggest you try with > web2py 2.9.5 which is what I use actually and it works... > > Richard > > On Thu, May 7, 2015 at 9:20 AM, LoveWeb2py > wrote: > >> Another observation: >> >> All of this code: >> >> >> >>> js += '

Re: [web2py] Two SQLFORMs side by side?

2015-05-11 Thread LoveWeb2py
new_exp_num=form.vars.exp_num) elif form.errors: response.flash = '' else: response.flash = '' return dict(form=form) Do I need to actually specify the db.table? From the looks of the class I thought it woul

Re: [web2py] Two SQLFORMs side by side?

2015-05-11 Thread LoveWeb2py
No rush, Richard. Thank you for your help I really appreciate it. On Monday, May 11, 2015 at 4:34:14 PM UTC-4, Richard wrote: > > I will try to review it ASAP... > > On Mon, May 11, 2015 at 4:30 PM, LoveWeb2py > wrote: > > Here is my dummy app, Richard. > > > On M

Re: [web2py] Two SQLFORMs side by side?

2015-05-12 Thread LoveWeb2py
ing thing > the wrong way basically... add_function is for the main_table which > contains the city name... > > I will send you back the corrected app when I found the issue with the > repeating load... > > Richard > > On Mon, May 11, 2015 at 4:39 PM, LoveWeb2py >

Re: [web2py] Two SQLFORMs side by side?

2015-05-14 Thread LoveWeb2py
second issue), 2) When you access the > http://hostname/appname/second_table_form/second_table there is a weird > issue with LOAD... > > I may have more time next week, but for now, I can't help you further... > > Richard > > > On Tue, May 12, 2015 at 11:11 AM, LoveWeb2

Re: [web2py] Two SQLFORMs side by side?

2015-05-18 Thread LoveWeb2py
;> author = models.CharField(verbose_name="Name", max_length=255) >> >> >> By the way, this app thats call "web2py.app.dummy.w2p", please be aware >> that it has some nasty nested stuff in it. Once I installed it was crawling >> all ove

[web2py] Re: xml view

2015-05-18 Thread LoveWeb2py
This should work: controller: data = db(db.table.id>0).select() return dict(data=data) view: {{=data.xml()}} On Monday, May 18, 2015 at 1:52:31 PM UTC-4, Mirek Zvolský wrote: > > I don't know how to write xml views. > > Basic content: {{from gluon.serializers import > xml}}{{=XML(xml(response.

[web2py] Select all fields with length > 0?

2015-05-29 Thread LoveWeb2py
db((db.table.field1.id>0)&(db.table.field2.length>0)).select() This still returns the whole field. I'm thinking the length takes the length of the entire field. How can I bring back all records that aren't empty for a field For example db.table.field2 row1: has information row2: row3: has in

[web2py] Re: Select all fields with length > 0?

2015-05-29 Thread LoveWeb2py
Sigh should have thought a little more before posting. Sorry about this This works: db((db.table.field1.id>0)&(db.table.field2!='')).select() On Friday, May 29, 2015 at 6:19:44 PM UTC-4, LoveWeb2py wrote: > > db((db.table.field1.id>0)&(db.table.field2.leng

[web2py] changing grid formname -- response.flash ?

2015-06-01 Thread LoveWeb2py
Hello, Lets say I have grid=SQLFORM.smartgrid(db.table, formname="mytablename") return dict(grid=grid) When I change the form name do I lose the ability to set response.flash? I changed the formname to one of my grid's and when users add a record now they don't get the response that a record w

[web2py] Re: My son made a new web2py logo

2015-06-01 Thread LoveWeb2py
It's a nice logo, Massimo. Maybe it could be re-worked a little? I think the current logo looks more polished. On Monday, June 1, 2015 at 2:06:16 PM UTC-4, Massimo Di Pierro wrote: > > Time to revamp the web site? > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: changing grid formname -- response.flash ?

2015-06-01 Thread LoveWeb2py
case. they logic is unrelated. Something else is > going on. > > On Monday, 1 June 2015 14:21:50 UTC-5, LoveWeb2py wrote: >> >> Hello, >> >> Lets say I have >> >> grid=SQLFORM.smartgrid(db.table, formname="mytablename") >> return d

[web2py] web2py menu dies?

2015-06-09 Thread LoveWeb2py
Sometimes my menu just stops working and users can't click the links. It's specific to one page that uses a modal and bootstrap. Is there any known reasons of why this might be happening and what could I check to troubleshoot? -- Resources: - http://web2py.com - http://web2py.com/book (Documen

Re: [web2py] web2py menu dies?

2015-06-09 Thread LoveWeb2py
in chrome dev tool? > > You must have an error somewhere, a missing lib or something... > > On Tue, Jun 9, 2015 at 1:02 PM, LoveWeb2py > wrote: > >> Sometimes my menu just stops working and users can't click the links. >> >> It's specific to one page t

[web2py] Show button in SQLFORM only if a value is present?

2015-06-10 Thread LoveWeb2py
I'd like to create a SQLFORM button, but only show the button if a value is present in the cell. Is this possible? I'm thinking of creating a function that will check to see if each record has a value present in the field for example: define_table('my_sqldata', Field('name', Fie

<    1   2   3   4   >