Re: [web2py] Re: how to iterate through sqlite data and display on web2py

2014-09-17 Thread Maurice Waka
Hi 1. I note that the code: match_row = db(db.keywords.x.contains('|%s|' % keyword)).select().first(). This picks the first item in he list. How about a random search through the list without using select().first()? 2. In my code: def types: db = DAL('sqlite.storage.db') db.define_table('

[web2py] log on file

2014-09-17 Thread Manuele Pesenti
I tryed to set up a logger in my app following the manual but I cannot see any file created under the logs directory. Here they are modifications I made to files... can you see anything wrong? * logging.conf (located under web2py/applications/myapp/) [loggers] - keys=root,rocket,markdown,web2py,r

[web2py] Re: Web2Py Book inconsistency and Reference to auth_user table has no recursive attributes

2014-09-17 Thread Yi Liu
Great. This is a really *thorough* answer. I appreciate it, Anthony. Let web2py stay focused, and let others (pandas etc.) do what they are good at :) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.goog

[web2py] Re: bootstrap 3 - if you care help test trunk now

2014-09-17 Thread Jim S
Is there a way I can default all of my forms to bootstrap3_inline? -Jim On Saturday, August 9, 2014 2:13:38 AM UTC-5, Massimo Di Pierro wrote: > > Bootstrap 3 is in trunk now. Please help us test it. > Also help us test that existing apps are not broken. > > Massimo > -- Resources: - http://web

[web2py] Re: Minimize CSS ( custom.widget) statements for custom styled forms

2014-09-17 Thread Leonel Câmara
That code is a huge WTF. None of this should be in the controller, it should be in the view. There should be no need to use _style. Why aren't you using the 'bootstrap3_stacked' (or inline) formstyle to start with or just using your own custom made formstyle? Furthermore, placeholders can be p

Re: [web2py] Re: how to iterate through sqlite data and display on web2py

2014-09-17 Thread Anthony
On Wednesday, September 17, 2014 9:12:11 AM UTC-4, Maurice Waka wrote: > > Hi > 1. I note that the code: > match_row = db(db.keywords.x.contains('|%s|' % keyword)).select().first(). > This picks the first item in he list. How about a random search through the > list without using select().first(

[web2py] Re: bootstrap 3 - if you care help test trunk now

2014-09-17 Thread Leonel Câmara
Officially not yet Jim. You can set response.formstyle but this may change so I wouldn't use it for now. See discussion here: https://groups.google.com/forum/#!topic/web2py-developers/43xNoDmB0rU -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2

[web2py] Re: How to return a more specific error message from auth.login(), rather than a generic "invalid login"

2014-09-17 Thread Mark Li
Thanks for the help guys! I've implemented something similar to Leonel's suggestion for now. I've also posted a Google Code issue about this: https://code.google.com/p/web2py/issues/detail?id=1984 On Monday, September 15, 2014 5:43:56 PM UTC-7, Anthony wrote: > > On Monday, September 15, 2014

[web2py] Re: Deploying Web2py with nginx on FreeBSD

2014-09-17 Thread Jose
El miércoles, 10 de septiembre de 2014 13:03:13 UTC-3, myappeng...@gmail.com escribió: > > Hi, everyone. > I'm in the process of deploying Web2py with nginx on FreeBSD. > Does anyone have a deployment script for this configuration. All the > recipes I have seen are for Linux and I'm having

[web2py] Re: bootstrap 3 - if you care help test trunk now

2014-09-17 Thread Jim S
Ok, for now I'll just hardcode it on my SQLFORM.grid calls. Another issue I'm having is that some of my buttons look like they have overlayed images on them. I've attached a sample. The code that is getting generated looks like this: Edit Delete Any ideas why those double im

[web2py] Re: bootstrap 3 - if you care help test trunk now

2014-09-17 Thread Jim S
Also, if I remove the "icon trash icon-trash" from the class on the image span (on the delete button) the proper delete image shows up. -Jim On Wednesday, September 17, 2014 1:15:58 PM UTC-5, Jim S wrote: > > Ok, for now I'll just hardcode it on my SQLFORM.grid calls. > > Another issue I'm havin

[web2py] Re: bootstrap 3 - if you care help test trunk now

2014-09-17 Thread Leonel Câmara
Yes that's not right jim, bootstrap3 should only have the version glyphicon and bootstrap2 shouldn't. What you should do is send your own ui dict to grid, something like this on your grid call ui = dict(widget='', header='', content='',

[web2py] Re: log on file

2014-09-17 Thread Niphlod
logging.conf should be in the root dir, not in the app dir. On Wednesday, September 17, 2014 3:26:18 PM UTC+2, Manuele wrote: > > I tryed to set up a logger in my app following the manual but I cannot > see any file created under the logs directory. > Here they are modifications I made to files.

[web2py] Re: Deploying Web2py with nginx on FreeBSD

2014-09-17 Thread Jose
0.1 Web2py # cd /home # fetch http://www.web2py.com/examples/static/web2py_src.zip # unzip web2py_src.zip # cp /home/web2py/handlers/wsgihandler.py /home/web2py/ # chown -Rh www:www web2py 0.2 uWSGI # cd /usr/ports/www/uwsgi # make install clean Create the file /usr/local/etc/uwsgi.ini *[uw

[web2py] Accesing table from external database

2014-09-17 Thread José Eloy
Hello! I need to populate a combobox in a FORM (or SQL FORM) with the content of a field of a table which is in an external SQL Server database. I know that is not possible to reference an external database using DAL, but how can I to load the content of the external field in a SQLFORM field (c

Re: [web2py] Re: bootstrap 3 - if you care help test trunk now

2014-09-17 Thread Jim Steil
Thanks, that worked great. NOTE: This line is incorrect: buttonedit='glyphicon glyphicon-arrow-pencil', Should be: buttonedit='glyphicon glyphicon-pencil', -Jim On Wed, Sep 17, 2014 at 1:27 PM, Leonel Câmara wrote: > Yes that's not right jim, bootstrap3 should only have the version > glyp

[web2py] Re: Accesing table from external database

2014-09-17 Thread Brian M
What do you mean by "external database"? Are you actually meaning a legacy database that the DAL didn't create itself? You can certainly connect web2py to such a database through the DAL or even just using db.executesql(). If you need to get a list of valid options for your combobox you can do

[web2py] Re: Comments/notes and api documentation

2014-09-17 Thread Derek
I'd like to see a wiki... it could be run on web2py even... On Tuesday, September 16, 2014 3:12:52 PM UTC-7, Anthony wrote: > > Maybe submit a Github issue in the book repo requesting this feature. > > Anthony > > On Tuesday, September 16, 2014 6:12:06 PM UTC-4, Anthony wrote: >> >> Agreed, but fo

[web2py] Re: auth.login() does not return input value (username) on error, if auth.define_tables(username=True).

2014-09-17 Thread Mark Li
My previous post was somewhat off. Actually, what happens is that if the form passes validation, but has incorrect login credentials, auth.login() will trigger a redirect with the following code: redirect(self.url(args=request.args, vars=request.get_vars), client_sid

[web2py] Re: auth.login() does not return input value (username) on error, if auth.define_tables(username=True).

2014-09-17 Thread Mark Li
Is there a reason for this behavior? Or is it a bug? On Wednesday, September 17, 2014 4:34:44 PM UTC-7, Mark Li wrote: > > My previous post was somewhat off. > > Actually, what happens is that if the form passes validation, but has > incorrect login credentials, auth.login() will trigger a redire

[web2py] Current logged in users

2014-09-17 Thread Tito Garrido
Hi Folks, Is there a way to list the current logged in users? Regards, Tito -- Linux User #387870 . _/_õ|__| ..º[ .-.___.-._| . . . . .__( o)__( o).:___ -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: Current logged in users

2014-09-17 Thread Anthony
See http://stackoverflow.com/questions/12218989/get-all-logged-in-users-web2py/12224157#12224157. Anthony On Wednesday, September 17, 2014 8:48:22 PM UTC-4, Tito Garrido wrote: > > Hi Folks, > > Is there a way to list the current logged in users? > > Regards, > > Tito > > -- > > Linux User #387

[web2py] Re: Comments/notes and api documentation

2014-09-17 Thread Limedrop
Have you seen the medium.com in-context notes? That would be a great way to bring it all together: https://medium.com/about/why-medium-notes-are-different-and-how-to-use-them-well-5972c72b18f2 There's even a jQuery clone that could be used: https://github.com/aroc/side-comments On Thursday, Se

[web2py] LOAD problem with ajax=True

2014-09-17 Thread Ide
I have a strange problem which I can't figure out. I have the following code in my main index.html view: {{left_sidebar_enabled=True,right_sidebar_enabled=False,('message' in globals())}} {{extend 'layout.html'}} {{=LOAD('default','action.load',args=request.args,vars=request.vars, ajax= True, a

[web2py] Correction/patch for web2py.js trap_form function.

2014-09-17 Thread Ide
I have spotted a scenario where the web2py.js trap_form function does not work correctly. https://github.com/web2py/web2py/blob/master/applications/welcome/static/js/web2py.js#L265 Currently looks like this: var url = form.attr('action'); if ((url === "") || (url === "#")) { /* fo

[web2py] Re: web2py 2.9.10 is OUT

2014-09-17 Thread Antonio Salazar
On its days I read the changelog on release 2.9.7 and completely missed this bug. -- better cache.dick (thanks Leonel) +- better cache.disk (thanks Leonel) Nice catch. On Monday, September 15, 2014 8:15:43 AM UTC-5, Massimo Di Pierro wrote: > > web2py 2.9.10 is out. It fixes some important bugs

[web2py] Re: web2py meetup Bay Area

2014-09-17 Thread ghufran syed
I am new to web2py, but would be interested in attending, thank you for taking the initiative to set something up! On Thursday, September 11, 2014 9:24:53 AM UTC-7, weheh wrote: > > Thanks for the replies. I went to a meetup last night for the Bay Area > python group (not the Bay Area Piggies gr

[web2py] Re: Reload a component form another component without submit form

2014-09-17 Thread Michel Krav
ooops, sorry niphlod, I've only read on w3schools.com site about the on() function. And furthermore I test the code above without changing the ajax parameter of the 2nd LOAD to True... aargh, not serious. But now, it finally works this way : {{extend 'layout.html'}} {{ =LOAD('default','army_h

[web2py] How can we organize the automatic posting to social networks Twitter and faсebook, vkontakt, google+

2014-09-17 Thread Капылов Данил
How can we organize the automatic posting to social networks Twitter and faсebook, vkontakt, google+ Prompt as materials and lessons how to work with veb2py and social networks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: web2py 2.9.10 is OUT

2014-09-17 Thread Fredy Gonzales
Bien... A probar ...gracias..graciass. well ... to test Thank you Thank you El lunes, 15 de septiembre de 2014 08:15:43 UTC-5, Massimo Di Pierro escribió: > > web2py 2.9.10 is out. It fixes some important bugs and upgrades some > contrib. packages. > > > -- Resources: - http://web2py.com

[web2py] Re: Can't edit default.py after upgrade to 2.8.2

2014-09-17 Thread Trevor Strauss
I'm having this same problem since upgrading from 2.8.2 to 2.9.9 Error in console when loading a newly created file is... Uncaught TypeError: Cannot read property 'length' of undefined comment-fold.js:24(anonymous function) comment-fold.js:24(anonymous function) foldcode.js:113getRange foldcode

[web2py] How can I create a virtualenv and follow this instruction in web2py?

2014-09-17 Thread Gideon George
Please somebody help me on how to go about following this instruction below. On a mission to create something http://feeds.uni.me/ (RSS Feed reader) I don't know exactly where to start. where can I find the web2py commandline to help create the virtualenv? Or is it not all going to be done within

[web2py] Re: web2py 2.9.10 is OUT

2014-09-17 Thread eric cuver
cool thank you. you can tell us the new upgrades please Le lundi 15 septembre 2014 15:15:43 UTC+2, Massimo Di Pierro a écrit : > > web2py 2.9.10 is out. It fixes some important bugs and upgrades some > contrib. packages. > > > -- Resources: - http://web2py.com - http://web2py.com/book (Document

[web2py] Re: Reload a component form another component without submit form

2014-09-17 Thread Michel Krav
For now I'm using the walkaround below to solve the second problem, consisting of two separate ajax call : jQuery(document).ready(function() { jQuery('tr.w2p_even.even.with_id,tr.w2p_odd.odd.with_id ').on( "dblclick",function() {

[web2py] share tip to calculate hours from database

2014-09-17 Thread eric cuver
I share with you a solution that gives leonel camara to a problem that I encounter my question : users must score the hours or minutes of work performed on the project. it's for Timesheet software. obligation: the data must be store in database , so virtual field impossible. the solution was g

[web2py] Re: Ansible Front-End

2014-09-17 Thread Kiril Bugajev
Hi Arnon and Chris, Have you managed to make any progress with web2py? I am about to embark on a similar project. On Tuesday, July 9, 2013 11:49:16 PM UTC+1, Christopher Steel wrote: > > We may be interested in this or something like it. I will run it by my > partner. > > Chris > > On Tuesday,

[web2py] Format dropdown list generated from a database table with OPTION helper

2014-09-17 Thread Fei Zhao
I would like to generate a dropdown list dynamically according to the records of a table, which refers to other tables. But it seems that lambda doesn't work with OPTION helper. For instance, I defined four tables, t_country, t_state, t_city, and t_birthplace. Table t_birthplace refers to those

[web2py] url rewriting and url mapping

2014-09-17 Thread olivier hubert
My application is a clone of Reddit clone app from Massimo. This is the url I use to show all the posts in a category. http://127.0.0.1:8000/list_posts_by_votes/16 16 = category id I would like this url in place of. http://127.0.0.1:8000/my_category_name It's the same to show a post http://127.0.

Re: [web2py] Accesing table from external database

2014-09-17 Thread Carlos Costa
I don't get it. You can make DAL connection to SQL Server, what is the problem you can not? 2014-09-17 16:39 GMT-03:00 José Eloy : > Hello! > > I need to populate a combobox in a FORM (or SQL FORM) with the content of > a field of a table which is in an external SQL Server database. I know that >

[web2py] Re: show multiple buttons in SQLFORM

2014-09-17 Thread olivier hubert
I finish to add my second button via jQuery jQuery( document ).ready(function() { jQuery("#submit_record__row .w2p_fw").append('{{=A("Markmin syntax",_class='btn btn-info',_href="http://www.web2py.com/init/static/markmin.html";, _target="_blank")}}') } Le dimanche 14 septembre 2014 14:18:1

[web2py] stdout and scheduler_run.run_output

2014-09-17 Thread Pedro
Anyone have special knowledge of scheduler_run.run_output and best practice to capture stdout? My schedule process runs fine but I do not get all the output stored in scheduler_run.run_output. Its very intermittent. Sometimes I get partial stdout, sometimes nothing, sometimes it work fine. Stra

[web2py] Re: Beginner issues

2014-09-17 Thread Pedro Henrique Correa Ferreira
Thanks, I made it work with a custom validator. Cheers. Em quinta-feira, 11 de setembro de 2014 09h22min04s UTC-3, Pedro Henrique Correa Ferreira escreveu: > > Hey, lads! > > How you're doing? > > I've got a issue with data validation. I gotta use a validator that > depends on a previous fiel

[web2py] Changing The Default Start Application

2014-09-17 Thread Chukwudi Nwachukwu
How do I change the default start application from *welcome* to something like *library*. I am running a free www.pythonanywhere.com account for now, thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code

[web2py] Re: set onblur event in controller

2014-09-17 Thread T.R.Rajkumar
I generate the html table in controller. It has lots of rows and I assign name and id of each cell there. Also I bind each cell textbox _onblur event to a javascript function. When I have the function in the view itself it is working fine. But when I put the function in a .js file and append tha

[web2py] Re: Web2py ajax call and Angularjs

2014-09-17 Thread olivier hubert
Hi, I don't know angular to, but I found this documentation with a ajax sample at the end. http://slides.com/amberdoctor/angularjs_and_web2py Le mardi 16 septembre 2014 20:39:02 UTC+2, piero crisci a écrit : > > I am testing angularjs with web2py. > In my web2py i have some ajax call that store t

[web2py] Suggestion to update trapped A links in components

2014-09-17 Thread Ide
I am trying to make an application that has the left hand menu created using one web2py component and the main view within the web page created using another component. I make the links in the menu on the left hand side using code like this: {{=A('linked page',_href='http://example.com/app/con

[web2py] Changes to web2py.js - a bug(?) and request

2014-09-17 Thread Ide
Hi, My posts from 15th Sept didn't seem to get approval to appear in the forum, so I'm assuming this was an oversight and posting 2 of them again in a single post this time. I think there may be a bug in the web2py.js code (https://github.com/web2py/web2py/blob/master/applications/welcome/stat

Re: [web2py] Re: Web Editor Blank Screen

2014-09-17 Thread Trevor Strauss
I'm having the as James upgraded from 2.8.2 to 2.9.9(11) now ...editor works fine on local dev box but on remote server running nginx the editor only allows viewing of new files. Seems I can edit old files, but not new. Any ideas??? On Tuesday, 8 April 2014 15:38:39 UTC-4, Derek wrote: > >

[web2py] compute and calculate database

2014-09-17 Thread eric cuver
I'm on the home stretch of my application. I want to know I sought but I can not find. from the database. I have this problem. db.define_table ('spot' Field ('analyse_des_besoins', 'double') analyse_des_besoins== 50 % Field ('patent', 'double') 'patent===10% Field ('marketing',

[web2py] Re: Deploying Web2py with nginx on FreeBSD

2014-09-17 Thread myappengineering
Thanks, Greg. I'm making progress. Now I'm getting an error from uwsgi 'Internal Server Error' on the web page. In the uwsgi.log '--- no python application found, check your startup logs for errors ---' On Sunday, September 14, 2014 5:29:17 PM UTC+1, GregD wrote: > > Have you tried changing t

[web2py] DAL error connecting to MySql

2014-09-17 Thread José Manuel Bordallo
Hi all, yesterday just actualized my Ubuntu 14.04 and i get this connection errors on my web2py apps. Failure to connect, tried 5 times: Traceback (most recent call last): File "/home/jose/web2py/gluon/dal.py", line 8038, in __init__ self._adapter = ADAPTERS[self._dbname](**kwargs) File "/hom

[web2py] Re: ssl certificate?

2014-09-17 Thread Massimo Di Pierro
This is not for web2py but for a non-profit that I help. Anyway, this is good to know. On Tuesday, 16 September 2014 13:37:04 UTC-5, Derek wrote: > > Free SSL Cert for Open Source projects... > > https://www.globalsign.com/ssl/ssl-open-source/ > > > On Sunday, September 14, 2014 6:30:45 PM UTC-7

[web2py] Re: Making a DevBar to develop faster in web2py.

2014-09-17 Thread Massimo Di Pierro
You would have to pass that information but mind that they may contain data that is sensitive and private. globals() contains all the global variables. db._timings is a list of (SQL, time) for all the queries. For the loading time look into window performance client-side: http://stackoverflow

[web2py] How to get the host name in a scheduled function?

2014-09-17 Thread Martin Weissenboeck
I have web2py running behind an apache server. If I ask for request.env.http_host I get "my.domain.com" - that is ok. But if I use request.env.http_host in a scheduled function I get " 127.0.0.1:8000" Regards, Martin -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - h

[web2py] Re: Changes to web2py.js - a bug(?) and request

2014-09-17 Thread Paolo Valleri
Hi, I'd suggest to set url='' to fix your problem. While for second problem you should set ajax_trap=True for the LOAD helper. See http://web2py.com/books/default/chapter/29/12/components-and-plugins#LOAD-signature Paolo On Wednesday, September 17, 2014 9:09:47 PM UTC+2, Ide wrote: > > Hi, >