[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 ac

[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
nt grid selection... 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 colum

[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" c

[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'*, Fiel

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

2014-06-12 Thread Vincent Chevrier
h box (and equivalently directly by URL) Thanks Vincent On Thu, Jun 12, 2014 at 5:38 PM, Derek 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 testin

[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 = "Wil

[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 simples

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 next

[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

[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
and LEFT JOIN. I don't know if it's possible with my query 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 recei

[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 "quanti

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

2013-04-23 Thread Vincent
, and > since 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

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

2013-04-21 Thread Vincent
? 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

[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 but

[web2py] Re: sqlform.grid exporting with_hidden_cols

2013-01-18 Thread Vincent
11:21:14 UTC-6, Vincent wrote: >> >> I am trying to export a grid with a custom exporter that has a name >> ending "with_hidden_cols" in order to export a complete table (and more). >> >> However, my exported file does not contain the hidden cols. >> >

[web2py] sqlform.grid exporting with_hidden_cols

2013-01-16 Thread Vincent
dy been limited to the visible columns. My change simply 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 > > wrote: > > yes. I do not know how to do it with one query. > > > > On Mar 30, 3:18 pm, Joaquin Orbe wr

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

2012-09-11 Thread Vincent
am unclear as to how this default propagates in other controllers or views. Do I run the risk of having "db.dog.owner.default" defined in a context where I do not want it defined? Any input as to what would be the recommended approach is welcome. Thanks 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 > >

[web2py] Re: default foreign key

2012-06-07 Thread Vincent
#x27;owner',db.owner,default=db(db.owner.isdefault=True).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 examp

[web2py] default foreign key

2012-06-07 Thread Vincent
ave owner==2 ("unknown" in the owner table). Trying to put a function as the default argument does not work. I realize I could set the owner to always be the first row in the table but I would like something more robust and flexible. Thanks Vincent

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

2012-05-05 Thread Vincent Davis
s the file and show the original. I browsed into the application (web2py>show contents>>applications>myapp>...>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 w

[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

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

2012-05-04 Thread Vincent Davis
T('Room')), Field('f_start', type='time', label=T('Start')), Field('f_end', type='time', label=T('End')), Field('f_day', type='date', label=T('Day')), Field(&#x

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

2012-05-04 Thread Vincent Davis
oable 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: 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 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 wrote: > web2py wraps each request in a single transaction by default, so if you > make multiple inserts during a r

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

2011-07-20 Thread Vincent
the namespace in the page.html view in the fresh default app and not in my app? thanks Vincent On Jul 20, 9:09 am, Anthony 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. > >

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

2011-07-20 Thread Vincent
my app may cause 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 wrote: > Hi, > > I have an existing web2py app called "dispersion" to which I am trying > to

[web2py] adding plugin_wiki to existing application - prettydate

2011-07-19 Thread Vincent
7;m running on Windows, from source, with the built-in server. Anybody have any ideas how to address/debug this? thanks Vincent

[web2py] Re: sqlite + web2py to GAE

2011-05-19 Thread Ray Vincent Gomez
ide the module. > > On May 19, 12:31 am, Ray Vincent Gomez > 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. (

[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: Display image from db

2011-03-23 Thread Vincent Davis
and can I ge the image by doing 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 pic

[web2py] Display image from db

2011-03-23 Thread Vincent Davis
nd 'layout.html'}} Read student {{=A(T('edit student'),_href=URL('student_update',args=request.args(0)))}} {{=form}} {{for t,f in db.t_student._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: Web2Py Foundation?

2010-12-27 Thread Vincent
upcoming project 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
the system. (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-16 Thread Vincent Borghi
On Tue, Mar 16, 2010 at 4:11 PM, mdipierro 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 and the

[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 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 subject is "email

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

2010-03-16 Thread Vincent Borghi
e user, to let him manage/share 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...@googleg

[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 t

[web2py:35805] Dynamic data refresh

2009-11-22 Thread Vincent
2py I 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.

[web2py:34638] Re: Join web2py wave

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

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

2009-10-25 Thread Vincent
gluon.main import * Traceback (most recent call last): File "", line 1, in ImportError: No module named web2py.gluon.main On Oct 25, 10:13 am, mdipierro wrote: > same as exampled before > > On Oct 25, 10:40 am, Vincent wrote: > > > Actually I am on a Mac 10.6, I

[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 wrote: > I assume you are running the python windows binary.

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

2009-10-25 Thread Vincent
hanks 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...@g

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

2009-10-24 Thread Vincent Borghi
e appropriate. A kind of time picker where the user 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. Thanks & Regards On Oct 24, 1

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

2009-10-24 Thread Vincent Borghi
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 Borghi wrote: >> > Hello >> > >> > I am looking for a simple and light system that would

[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 application

[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 wrote: > Thanks. > > On Oct 15, 4:00 pm, weheh wrote: > > > Massimo, I've reviewed your slide presentation and have the

[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 he

[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 wrote: > Had the same problem, this worked for me: > >  Search for: http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---

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

2009-05-27 Thread Vincent Borghi
t;), without passing parameters... Other idea? > > On May 27, 4:03 am, Vincent Borghi wrote: >> 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

[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'}} Type something and press the button. === test1/controllers/def