[web2py] Grid: case insensitive sort

2022-11-03 Thread Vincent Borghi
Hello, I have a simple SQLFORM.grid that shows the rows of my simple SQLite database. In the grid, when I click on, say, the "vendorname" column header, this performs a kind of alphabetical sort, but the sort is case sensitive, so for example "AXE" comes before "Abc". How can I make the grid

[web2py] How to escape double curly brackets in views

2021-12-16 Thread Vincent Borghi
al" and escaped double curly brackets in my view? PS: The "{{ }}"" are used by some expressions in the "simile exhibit <http://www.simile-widgets.org/exhibit3/>" framework, that I used with web2py, hence my need. Thanks Vincent -- Resources: - http://web2py.

[web2py] Re: How to determine the distinct values of a given grid column for the current selection

2017-11-14 Thread Vincent Borghi
lection... Thanks On Tuesday, November 14, 2017 at 8:42:53 AM UTC+1, Dave S wrote: > > > > On Monday, November 13, 2017 at 9:57:25 PM UTC-8, Vincent Borghi wrote: >> >> Hello, >> >> I have a "normal' web2py grid with columns (including a column named &

[web2py] How to determine the distinct values of a given grid column for the current selection

2017-11-13 Thread Vincent Borghi
Hello, I have a "normal' web2py grid with columns (including a column named "country"), thru which the users can query the db to select the lines they are interested in. Once the users have performed their selection, I need to be able to determine the distinct values of (e.g.) the "country"

[web2py] Re: problem with ldap authentication

2017-03-20 Thread Vincent Borghi
#27713355 Vincent Borghi -- 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 "w

[web2py] SQLFORM - Filter referenced data based off another value.

2015-09-08 Thread Vincent Zaffiro
I am trying to utilize the SQLFORM magic as much as possible and ran into the below scenario and hopeful that the SQLFORM can handle it. Scenario - I have an account that can have multiple projects which is defined here: db.define_table(*'Account'*,

[web2py] modal form - is this a good approach?

2014-06-12 Thread Vincent
Hi, wanted to ask the community if the approach I am taking is sound. If so this may be of use to others. If not, please tell me the way to do this correctly. My objective is to have form submission in a modal way (using bootstrap modal). Here is the approach I am taking, reduced to the

[web2py] SQLFORM.grid search - boolean precedence? - nested queries?

2014-06-12 Thread Vincent
How would one go about doing the equivalent of A and (B or C) in the grid or smartgrid search? Tried reading the source but got lost. Given db.person.firstname db.person.lastname this fails as an invalid query: person.firstname = John and (person.lastname = Smith or person.lastname =

Re: [web2py] Re: SQLFORM.grid search - boolean precedence? - nested queries?

2014-06-12 Thread Vincent Chevrier
(and equivalently directly by URL) Thanks Vincent On Thu, Jun 12, 2014 at 5:38 PM, Derek sp1d...@gmail.com wrote: You have your queries all wrong. Can you share your code? You should use the python bitwise operators not the words. Also, why are you using assignment when you should be testing

Re: [web2py] Re: Fail to recognize json payload in a content-type: application/json POST request

2013-12-12 Thread Vincent Audebert
@Niphlod yes it's exactly this. @Jonathan I am on 2.5.1 too and it works fine on my MAC OS X machine but once I go on a web2py running under apache, the header content_type is sent and web2py catches only http_content_type I will post my findings if it's not fixed in 2.8.2. I plan to migrate

[web2py] Re: Fail to recognize json payload in a content-type: application/json POST request

2013-12-11 Thread Vincent Audebert
Oh it has been fixed with 2.8.2? (that was the purpose of my first question. Sorry if I was not clear) On Thursday, August 1, 2013 6:53:09 PM UTC+12, Ray (a.k.a. Iceberg) wrote: To whom it may concern: I tried posting vars in json format, with content-type: application/json header, to my

[web2py] Re: Fail to recognize json payload in a content-type: application/json POST request

2013-12-10 Thread Vincent Audebert
Trying to catch up on this issue. Has it been fixed on trunk? Also when is forecasted the next released? At the moment, I just hacked main.py by replacing http_content_type with content_type. Does it sound ok ? Cheers. Vincent. On Thursday, August 1, 2013 6:53:09 PM UTC+12, Ray (a.k.a

[web2py] Web2Py DAL, left join and operator precedence

2013-12-03 Thread Vincent Audebert
though. Thanks, Vincent. -- 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

[web2py] Looking for advice for implementing a form to order multiple items

2013-11-13 Thread Vincent Borghi
Hello, I'm thinking about implementing a form for ordering parts, and before starting this work I'd like to have some advice. Here is the base functionality wanted: - The form would include multiple similar lines made of 3 fields, to hold a part_reference, a part_description and a quantity.

Re: [web2py] Returning gzipped content, generic.json.gz ?

2013-04-23 Thread Vincent
this is an internal site and Vincent may not be a webserver guy, that may fit the bill more. On Monday, April 22, 2013 11:35:23 AM UTC-7, Michele Comitini wrote: a. Use a full blown webserver like apache or nginx and configure it to gzip content on client request b. Use a simple wsgi gzipping

[web2py] Returning gzipped content, generic.json.gz ?

2013-04-21 Thread Vincent
Hi, I want to return gzipped json content (although the json part is not really important). I did some googling and found this post which is somewhat related, https://groups.google.com/d/msg/web2py/cgSrsC73vzg/ZNYN3u7ChVwJ as far as I could tell the minify part of the question was answered

Re: [web2py] Returning gzipped content, generic.json.gz ?

2013-04-21 Thread Vincent
-in? Thanks Vincent On Sunday, April 21, 2013 4:16:17 PM UTC-5, Ricardo Pedroso wrote: You can not blindly gzip your data unless you control the clients. It's the client that tells if it can accept gzip content or not, and the web server will choose to gzip it or not. I will advice you

[web2py] Re: sqlform.grid exporting with_hidden_cols

2013-01-18 Thread Vincent
ok, ticket submitted: http://code.google.com/p/web2py/issues/detail?id=1294 On Wednesday, January 16, 2013 9:46:20 PM UTC-6, Massimo Di Pierro wrote: Please open a googlecode thicket pointing here. We will review and probably accept it. On Wednesday, 16 January 2013 11:21:14 UTC-6, Vincent

[web2py] sqlform.grid exporting with_hidden_cols

2013-01-16 Thread Vincent
defines a new variable expfields using the original way fields is defined when it is not specified on grid creation. I believe this now has the expected behavior. I am using web2py from trunk. Thanks Vincent --

Re: [web2py] Re: in-line select for counting purpose

2013-01-14 Thread vincent
to the first post) Thank you. Vincent. On Friday, April 1, 2011 3:49:33 PM UTC+13, Joaquin Orbe wrote: On Wed, Mar 30, 2011 at 6:56 PM, Massimo Di Pierro massimo@gmail.com javascript: wrote: yes. I do not know how to do it with one query. On Mar 30, 3:18 pm, Joaquin Orbe joaquino

[web2py] SQLFORM.grid with args: customizing the Add form

2012-09-11 Thread Vincent
Vincent (using web2py 2.0.8 from trunk) --

[web2py] Re: default foreign key

2012-06-08 Thread Vincent
for the record, default=db(db.owner.isdefault==True).select().first().id appears to work, note the addition of ìd. Thanks Vincent On Thursday, June 7, 2012 9:49:30 PM UTC-5, Massimo Di Pierro wrote: db(db.owner.isdefault=True).select() should be db(db.owner.isdefault==True).select

[web2py] default foreign key

2012-06-07 Thread Vincent
something more robust and flexible. Thanks Vincent

[web2py] Re: default foreign key

2012-06-07 Thread Vincent
).select().first())) On Thursday, June 7, 2012 2:20:30 PM UTC-7, Vincent wrote: Hi, I'm looking for a way to define a default foreign key dynamically. For example if I have the following schema: db.define_table('owner',Field('name', 'string'), Field('isdefault','boolean',default=False

[web2py] Re: time picker not working, how to show 15min increments

2012-05-05 Thread Vincent Davis
jquery timeentry is the behavior I am getting, I was expecting the behavior show in the book :-) Suggestion on listing 15min time increments? Thanks Vincent On Friday, May 4, 2012 10:56:48 PM UTC-6, Massimo Di Pierro wrote: I am also using 1.99.7 with chrome on mac and it works for me

[web2py] Re: time picker not working, how to show 15min increments

2012-05-05 Thread Vincent Davis
browsed into the application (web2pyshow contentsapplicationsmyapp...web2py.js and it shows the changes I have made. Where is the other coming from? Thanks Vincent On Saturday, May 5, 2012 7:31:35 AM UTC-6, Massimo Di Pierro wrote: I guess the book need updating. You need to install

[web2py] time picker not working, how to show 15min increments

2012-05-04 Thread Vincent Davis
and I think I have found examples to do this except for the 15min increments. Thanks for any suggestions and help I am very new to web2py any examples or pointers to examples would be great. Vincent

[web2py] Re: time picker not working, how to show 15min increments

2012-05-04 Thread Vincent Davis
',db.t_reservation,Field('current_record','reference t_reservation',readable=False,writable=False)) On Friday, May 4, 2012 10:02:03 PM UTC-6, Massimo Di Pierro wrote: which web2py version are you using? Which browser? On Friday, 4 May 2012 22:24:50 UTC-5, Vincent Davis wrote: 1. The web2py

[web2py] Re: new appliances - Happy Holidays

2011-12-29 Thread Vincent
looks great, thanks btw the title Web2py Example Appliances is a dead link On Dec 28, 4:41 pm, Khalil KHAMLICHI khamlichi.kha...@gmail.com wrote: Good work.

[web2py] Re: Many-to-many admin form

2011-12-23 Thread Vincent
This something I would definitely be interested in seeing, as well as input forms for many-to-many in general (not just admin). Thanks Vincent On Dec 23, 12:50 pm, Anthony abasta...@gmail.com wrote: web2py wraps each request in a single transaction by default, so if you make multiple inserts

[web2py] Re: adding plugin_wiki to existing application - prettydate

2011-07-20 Thread Vincent
this behavior? Since it does not seem to be the default behavior (at least not on a fresh app, as described in previous post) Thanks Vincent On Jul 18, 4:01 pm, Vincent vincentchevr...@gmail.com wrote: Hi, I have an existing web2py app called dispersion to which I am trying to add

[web2py] Re: adding plugin_wiki to existing application - prettydate

2011-07-20 Thread Vincent
view in the fresh default app and not in my app? thanks Vincent On Jul 20, 9:09 am, Anthony abasta...@gmail.com wrote: On Wednesday, July 20, 2011 8:11:56 AM UTC-4, Vincent wrote: after some digging around I found the prettydate function in gluon.tools. If I from gluon.tools import

[web2py] adding plugin_wiki to existing application - prettydate

2011-07-19 Thread Vincent
, with the built-in server. Anybody have any ideas how to address/debug this? thanks Vincent

[web2py] sqlite + web2py to GAE

2011-05-19 Thread Ray Vincent Gomez
Hi, I'm a web2py newbie. I setup a web2py app with sqlite in a server using wsgi. I decided to deploy it in GAE. I was successful in uploading the app. (thanks for making this very easy). But I notice that the contents of my sqlite database was not included. I don't have this problem when I setup

[web2py] Re: sqlite + web2py to GAE

2011-05-19 Thread Ray Vincent Gomez
on GAE. They do not provide the module. On May 19, 12:31 am, Ray Vincent Gomez rayvincent.go...@gmail.com wrote: Hi, I'm a web2py newbie. I setup a web2py app with sqlite in a server using wsgi. I decided to deploy it in GAE. I was successful in uploading the app. (thanks for making

[web2py] Display image from db

2011-03-23 Thread Vincent Davis
._referenced_by:}}{{if not t[-8:]=='_archive':}} [{{=A(t[2:],_href=URL('%s_select'%t[2:],args=(f,form.record.id)))}}] {{pass}}{{pass}} Thanks Vincent

[web2py] Re: Display image from db

2011-03-23 Thread Vincent Davis
something like image = record['f_image'] Thanks Vincent In View: {{=TAG.img(_width=90, _src=URL(r=request, c='default', f='download', args=[record.f_image]))}} What I do when users are uploading pictures is to create a thumbnail of that picture and usually only show that thumbnail. Kenneth

[web2py] Re: Web2Py Foundation?

2010-12-27 Thread Vincent
as allowed to django which I like less but I am more confidant in it's continued development. This is my perception of this right or wrong. Vincent kind regards Pepe

[web2py] Multiple user types and auth

2010-12-25 Thread Vincent
. (Case_workers, Parents, Staff) and as you would expect the db table for each contains different information. How should I design the db and integrate authorization. I have read through the Access Control docs but it was not very helpful to me with regard to my question. Thanks Vincent

[web2py] Re: Apache wsgi virtualhost configuration for multiple web2py sites

2010-12-13 Thread Vincent
I am interested in a little different setup, I would like *.example.com to go to the web2py app/folder but be able to specify other.example.com be served from /var/www/other/ I am having trouble figuring out how to configure Apache virtual host to do this. Thanks Vincent On Oct 18, 7:07 pm, VP

Re: [web2py] web2py wizard (alpha) is here

2010-10-21 Thread Vincent Borghi
This looks great! May I suggest a feature request: You could offer to the user a variant that would automatically create appropriate tables, field definitions and populate the tables, just by loading /analysing the contents of a .user-chosen csv file (typically generated from an excel file). This

[web2py] Troubleticketing application?

2010-10-06 Thread Vincent Borghi
Hello, Is there a web2py application available somewhere that could be used as a trouble ticketing (issue tracking) system, or could serve as a basis to build on for implementing such a system? Thanks

Re: [web2py] Re: Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-17 Thread Vincent Borghi
On Tue, Mar 16, 2010 at 4:11 PM, mdipierro mdipie...@cs.depaul.edu wrote: I think what Vincent is asking is not so much importing capability but an interface that can read an excel file (or a csv file) asks you the names (guessing from the header) and types (guessing from data) of columns

[web2py] Feature request: xlstoweb2py [was: Where do you use web2py?]

2010-03-16 Thread Vincent Borghi
his data thru the web. Regards Vincent Borghi PS: thanks to web2py developers for theit great work! -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group

[web2py] Re: Relase of the first HL7 based on web2py framework

2010-03-16 Thread Vincent Borghi
On Mon, Mar 8, 2010 at 3:52 AM, Thadeus Burgess thade...@thadeusb.com wrote: Says registration requires verification and I never received an email. I have found the verification email in my Spam mailbox of my gmail account... If the same happens to you, search for a spam-classified mail whose

[web2py:36674] How to simply remove duplicate data from sqlite table

2009-12-07 Thread Vincent Borghi
Hi, just simple advice needed: I have a web2py application whose data is made of an sqlite table (that I have obtained by importing in web2py an excel-generated CSV file). Now I see that in fact the original CSV data included many duplicate lines, so my sqlite table has the same duplicate lines

[web2py:35805] Dynamic data refresh

2009-11-22 Thread Vincent
assume I could refresh the screen but I would like a better solution. Are there any templates/examples using web2py? Thanks Vincent --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group

[web2py:34638] Re: Join web2py wave

2009-11-04 Thread Vincent
I am interested. Vincent On Nov 4, 6:15 pm, Richard richar...@gmail.com wrote: I would invite you but it seems Google has temporarily disabled inviting:http://www.google.com/support/wave/bin/answer.py?hl=enanswer=162237 On Nov 5, 4:38 am, Thadeus Burgess thade...@thadeusb.com wrote: I

[web2py:33641] import/install matplotlib or other modules from other python on system?

2009-10-25 Thread Vincent
Vincent --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com

[web2py:33648] Re: import/install matplotlib or other modules from other python on system?

2009-10-25 Thread Vincent
Actually I am on a Mac 10.6, I was planning on hosting it on my Vista machine but that not a big deal, I would prefer to get it going on my Mac. How do I try to start web2py from Enthought? Vincent On Oct 25, 9:10 am, mdipierro mdipie...@cs.depaul.edu wrote: I assume you are running the python

[web2py:33653] Re: import/install matplotlib or other modules from other python on system?

2009-10-25 Thread Vincent
last): File stdin, line 1, in module ImportError: No module named web2py.gluon.main On Oct 25, 10:13 am, mdipierro mdipie...@cs.depaul.edu wrote: same as exampled before On Oct 25, 10:40 am, Vincent vinc...@vincentdavis.com wrote: Actually I am on a Mac 10.6, I was planning on hosting

[web2py:33566] Looking for a simple reservation system

2009-10-24 Thread Vincent Borghi
Hello I am looking for a simple and light system that would allow to manage the reservation by users of various shared resources, such as rooms or misc. equipments. Simple and basic features are sufficient, just manage/check time slots to reserve, some resources and some users... The

[web2py:33617] Re: Looking for a simple reservation system

2009-10-24 Thread Vincent Borghi
with them: the developer/administrator can provide his own functions that will betriggered when such or such action occur 12) To be continued. The above is just for your reflexion Keywords are suimplicity, ligntness, code customisability... Yanks and regards On Oct 24, 3:49 am, Vincent

[web2py:33634] Re: Looking for a simple reservation system

2009-10-24 Thread Vincent Borghi
selects the start time and the end time? Or the start time and duration? We can begin with something simple to implement, and in subsequent releases propose something more attractive with ajax feeback etc. ThanksRegards On Oct 24, 1:40 pm, Vincent Borghi vincent.borgh...@gmail.com wrote

[web2py:32995] Re: web2py + matplotlib, is there a how-to posted

2009-10-16 Thread Vincent
Thanks this will help me get started. I have a simulation and plots that I would like to turn into a web app. Vincent On Oct 15, 3:08 pm, mdipierro mdipie...@cs.depaul.edu wrote: Thanks. On Oct 15, 4:00 pm, weheh richard_gor...@verizon.net wrote: Massimo, I've reviewed your slide

[web2py:32933] web2py + matplotlib, is there a how-to posted

2009-10-14 Thread Vincent
I have been reading a bit about matplotlib plots into a web page. Mostly lots of googling and reading treads. My question is, Is there a nice how-to posted somewhere for using web2py + matplotlib. Same question for PlotKitWrapper Is there documentation? Thanks for your help Vincent

[web2py:22719] Behavior of Enter key in an ajaxified input field

2009-05-27 Thread Vincent Borghi
Hello, In the following form (essentially taken from web2py examples), the Enter key does not work as expected, I am obliged to click on the submit button. === test1/views/default/searchform.html === {{extend 'layout.html'}} pType something and press the button./p form INPUT type=text id='q'

[web2py:22724] Re: Behavior of Enter key in an ajaxified input field

2009-05-27 Thread Vincent Borghi
, both Enter key and submit button have the same bad behavior: they just run a GET of the same current URL (searchform), without passing parameters... Other idea? On May 27, 4:03 am, Vincent Borghi vincent.borgh...@gmail.com wrote: Hello, In the following form (essentially taken from

[web2py:22734] Re: Behavior of Enter key in an ajaxified input field

2009-05-27 Thread Vincent Borghi
Thanks, the workaround you suggest works! On Wed, May 27, 2009 at 2:19 PM, Horst Herb my.list.subscripti...@gmail.com wrote: Had the same problem, this worked for me: form id=testform onsubmit=return false  Search for: INPUT type=text id='searchfor' value= onchange=ajax('. That way, the