[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 achieve a 
case insensitive sort?

Thanks

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/6e4fd29b-78b5-4481-97e0-9b37545c462cn%40googlegroups.com.


[web2py] How to escape double curly brackets in views

2021-12-16 Thread Vincent Borghi
Hello,

I have a view which contains "normal" placeholders like {{=myvariable}}.

My problem is that the view must sometimes includes double curly brackets,  
{{ and }}, that are to be ignored by the web2py view renderer. So how to 
escape them? What is the mean to have both "normal" and escaped double 
curly brackets in my view?

PS: The "{{ }}"" are used by some expressions in the "simile exhibit 
" framework, that I used with 
web2py, hence my need.

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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/7687305c-6281-4d14-a208-66062882db92n%40googlegroups.com.


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

2017-11-14 Thread Vincent Borghi
To answer to Dave's questions:
- Yes they can select more than one line. Wat I call the "selected lines" 
are the lines fetched by the current query.
- I only need that on the server side. When you write "If on the server,  
doesn't the db query for the row selected give that value?" I do not really 
understand. In fact I think I need (on the server the side) to know what is 
the current query and based on it, to build an appropriate query with the 
appropriate "DISTINCT" clause. But I do not even know how to get the query 
that generated the current 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 column named 
>> "country"), thru which the users can query the db to select the lines they 
>> are interested in. 
>>
>
> Can they select more than 1 line at a time?
>   
>
>> Once the users have performed their selection, I need to be able to 
>> determine the distinct values of (e.g.) the "country" column for the 
>> current selection.
>> This will allow different things, like showing the users the list of the 
>> current distinct values, or triggering a specific action on those distinct 
>> values, etc.
>>  
>>
> Is there  some code around, ready to use,  or at least hicn can be a basis 
>> or just as an example ?
>>
>> Thanks
>>
>
>
> Do you need to know this on the client-side before requesting action from 
> the server?  Or only on the server in the controller/function that matches 
> the link?
>
> If on the server,  doesn't the db query for the row selected give that 
> value?
>
> If on the client, you would be looking at picking up the proper td entry.  
> I don't have a grid example going at the moment.  I have an SQLTABLE 
> example that doesn't seem to name anything in the table (unlike an SQLFORM 
> where everything is named).  But for a grid, aren't you intercepting a 
> click on the link inside a td, and the other td would just be one of its 
> siblings?
>
> /dps
>
>

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[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" column for the 
current selection.
This will allow different things, like showing the users the list of the 
current distinct values, or triggering a specific action on those distinct 
values, etc.

Is there  some code around, ready to use,  or at least hicn can be a basis 
or just as an example ?

Thanks

-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: problem with ldap authentication

2017-03-20 Thread Vincent Borghi

Hi,

I do not know if this is your case, but in my case I was apparently obliged 
to implement this setting:
ldap.set_option(ldap.OPT_X_TLS_NEWCTX, 0)
in order to work around the problem discussed here:

http://stackoverflow.com/questions/27669285/global-options-in-python-ldap/27713355#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 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


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

- A simple implementation would prepare a basic form with a fixed number of 
lines, say 5, and the user would fill only the lines that he would need. 
But it would be nicer to have an "add part/line to order" button that would 
add a line to the form. And also a "remove part/line from order" button for 
each individual  part/line.

- The user could be assisted in entering the  "part_reference" value by an 
autocomplete/suggest functionality that would query my "parts" database, 
but it would be possible to enter a reference not in the db. When a 
reference entered is found in the db, the "part_description" field would be 
automatically populated with the associated information coming from the db. 
(The description could be shown during the autocompletion/suggest process, 
also). The description could be made editable, as this is useful in the 
case the part is not found in the DB.
The autocomplete/suggest feature can either be a special dedicated utility 
e.g. above the form, or this could be integrated in each individual 
"part_reference" input field.

- The "quantity" field could be enhanced with a clickable +/- quantity 
incrementer/decrementer

- Once the user clicks the button "submit", the form contents would be 
processed by a web2py controller that would loop on each part specified in 
the form (ignoring lines that do not have a part number or whose quantity 
is 1). Only the part_reference and the quantity are used (part_description 
is of no use here). Is there some web2py example of such form processing 
with looping on multiple similar input line?

Well, I'm interested if you have examples and advice (or even ready to use 
code!), snippets of code (jquery/javascript and web2py as well)...

Thanks



-- 
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-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


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 would be a nice and quick excel-to-web2py conversion tool!!

On Thu, Oct 21, 2010 at 7:55 AM, mdipierro  wrote:

> http://vimeo.com/16048970
>
> Now I am going to sleep a few ours


[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 then writes the model for you.

yes Massimo

> Perhaps something that can
> deal with the case when the table is the result of a join. Then
> importing is a trivial step. We have that already

In addition to data importation and code generation for the model,
a key feature is to generate a user interface to the data.

The default appadmin.py is OK for an administrator, but
not so OK for an end-user who just wants to manage and share
some data.
Such end-users are most data owners than "administartors".

Ideally, the utility I am looking for will generate a nice user
(viewers and data owners)
interface, that the administrator (who is supposed to know python and
more or less SQL)
can customize/enhance.

The end-users/data owners are not knowlegeable in SQL (they are
used to excel tables, after all).
Moreover they expect to have simple functionality
to do base CRUD operations : Create, Read (browse, filter, sort, dump as csv,
paged or full datalist view in sortable table with choosable columns, possibly
customizing who has which acces rights, so on...), Update and Delete.


Regards







> On Mar 16, 9:27 am, Dragonfyre13  wrote:
>> Well, my suggestion would be forget the XLS format for the first
>> iteration. Use CSV. If you're not concerned with formulas, that's the
>> cleanest route, and included in the default python install. (csv
>> module). I use it all the time for my load test frameworks I build.
>>
>> It's not only very easy to use, but since it's VERY easy to export
>> from excel, it shouldn't be much of a burden on the users. In a second
>> iteration, if the license matches, you could do an import from xls
>> format.
>>
>> On Mar 16, 8:03 am, mdipierro  wrote:
>>
>> > This can be done. I need to check the licence of the xls readers.
>>
>> > On Mar 16, 3:45 am, Vincent Borghi  wrote:
>>
>> > > Hello
>>
>> > > I have used web2py to (quickly) implement a simple phone directory of
>> > > customer contacts,
>> > > for a small phone call center.
>> > > Before that, people tried to maintain their contact information in an
>> > > Excel spreadsheet
>> > > that was exchanged thru mail and/or a windows sharedc folder...
>>
>> > > ( Also note that I deal with two zope/plone sites, but I cannot (/don't 
>> > > want) to
>> > > fully understand all the stuff that has been added/changed with the
>> > > Plone 3 release
>> > > and soon the Plone 4 one -- too complicated for me.
>> > > However, as a CMS, Plone has advantages, and afaik there is nothing 
>> > > really
>> > > production-ready in the web2py world )
>>
>> > > By the way:
>> > > Feature request: xlstoweb2py
>> > > ===
>> > > For me, web2py could be the killer framework everywhere there are
>> > > simple xls Excel files
>> > > circulating among people who try to share and maintain information as
>> > > they can (and
>> > > they are numerous in many companies...).
>>
>> > > In fact, in many cases, Excel sheets made by people involve no formula, 
>> > > but are
>> > > just tables of static data. To deal with this frequent use case, I am
>> > > looking for an
>> > > "xlstoweb2py" utility that would take an xls file as input, and would
>> > > automatically
>> > > convert the data to an sqlite database, would build a base web2py 
>> > > application
>> > > implementing CRUD features and perhaps some form of access control 
>> > > policy.
>> > > The base app would be possibly ready to use, but as the resulting code 
>> > > would be
>> > >  web2py- and python-based, it would be easy for a
>> > > developer/administrator (as me) to customize/enhance the generated app.
>>
>> > > For me, such a "xlstoweb2py" would be a killer app.
>> > > We could even imagine a web service oriented towards the end-user (not to
>> > > developers), which would allow the user to upload an xls file, and in
>> > > turn, would
>> > > generate and host a (possibly customizable) web app for the user, to let 
>> > > him
>> > > manage/share his data thru the we

[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 verification"
( in:spam subject:"email verification" )

-- 
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, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.



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

2010-03-16 Thread Vincent Borghi
Hello

I have used web2py to (quickly) implement a simple phone directory of
customer contacts,
for a small phone call center.
Before that, people tried to maintain their contact information in an
Excel spreadsheet
that was exchanged thru mail and/or a windows sharedc folder...

( Also note that I deal with two zope/plone sites, but I cannot (/don't want) to
fully understand all the stuff that has been added/changed with the
Plone 3 release
and soon the Plone 4 one -- too complicated for me.
However, as a CMS, Plone has advantages, and afaik there is nothing really
production-ready in the web2py world )

By the way:
Feature request: xlstoweb2py
===
For me, web2py could be the killer framework everywhere there are
simple xls Excel files
circulating among people who try to share and maintain information as
they can (and
they are numerous in many companies...).

In fact, in many cases, Excel sheets made by people involve no formula, but are
just tables of static data. To deal with this frequent use case, I am
looking for an
"xlstoweb2py" utility that would take an xls file as input, and would
automatically
convert the data to an sqlite database, would build a base web2py application
implementing CRUD features and perhaps some form of access control policy.
The base app would be possibly ready to use, but as the resulting code would be
 web2py- and python-based, it would be easy for a
developer/administrator (as me) to customize/enhance the generated app.

For me, such a "xlstoweb2py" would be a killer app.
We could even imagine a web service oriented towards the end-user (not to
developers), which would allow the user to upload an xls file, and in
turn, would
generate and host a (possibly customizable) web app for the 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...@googlegroups.com.
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.



[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 that differ only by their
id.

What simple method do you recommend to eliminate the duplicate lines
perhaps from within the web2py framework and without stopping the
application...?

thanks

--

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, send email to 
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.




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

2009-10-24 Thread Vincent Borghi
On Sat, Oct 24, 2009 at 8:46 PM, mdipierro  wrote:

>
> How many resources should be available for booking? How would one
> search for them, by keyword? Should the time-slots be fixed?
>

And n Sat, Oct 24, 2009 at 9:30 PM, Thadeus Burgess
wrote:
> Should time slots be declared before hand? So that a user could only
select from a fixed time > slot?

A- Regarding resources:
How many? for my own use there would be just a few  resources: no more than
10 meeting rooms, 10 machine accesses, 10 devices. But for a general use in
other contexts, I imagine
that this could be many more..
 I imagine the user would select the resource by some form of "resource
picker",
perhaps a simple menu, or perhaps a cascading menu where you first choose
the resource
 category (e.g. room), then the exact resource e.g. (room 43). Instead of a
cascading menu,
this could also be some kind of Ajax autocompletion/suggestion gadget, I
have
no definitive preference. Perhaps the simplest to customize would be the
better
When mdipierro says "search for them by keyword", indeed it's almost the
same thing
("keyword", "category", or even "tag", whatever word you use, it's some form
of
classification).

+ Another (optional) requirement, forgotten in my previous mail:
13) Each resource could be associated with a piece of html (that e.g. would
be callable to provide the users with an explanation about this
resource)

B- Regarding time slots:
No definitive idea, but as you suggest it, the time slots could be fixed. I
imagine
that the time granularity could be customizable in the Python code. For my
own
use 30mn would be OK, but for others, smaller slots (e.g. 5mn) would be
needed.
I do not know what kind of interaction would be 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:40 pm, Vincent Borghi  wrote:
> Hello,
>
> On Sat, Oct 24, 2009 at 4:45 PM, Yarko Tymciurak <
>

> > resultsinsoftw...@gmail.com> wrote:
> > > On Sat, Oct 24, 2009 at 9:26 AM, mdipierro  >wrote:
> >
> > >> We could write one. Can you send more specs?
> >
> > In fact, in my mind, I was looking for an already existant application,
> > but if you are ready to develop a new one from scratch, why not?!
> > Thanks for your responsiveness, and see my requirements below...
> >
> > that is, can you state clearly what you want (and don't want), what
> problems
> >
> > > you anticipate (e.g. expected scheduling conflicts, exceptions - e.g. a
> > > director level person is allowed to override a reservation, and how
> that
> > > should be handled),  the kinds of resources (and pertinent information
> about
> > > them), and the population that will be served by this system (and what
> you
> > > want for them, and their experience).
> >
> > > From there, we can start a conversation to develop specifications.
> The
> > > implementation (e.g. python, web2py, or whatever) then should be chosen
> by
> > > what can best accomplish what you want (for example - you may want a
> level
> > > of interaction that suggests Flash on the client end, or not...).
> >
> > Not really specs, but some requirements follow:
> >
> > 1) I want to be able to easily customize/modify the application myself,
> > and for my personal taste and experience, this simply means that Python
> is a
> > must.
> > This also means that for the rendering, I want no Flash but just
> > html+css+javascript
> > (preferably simple javascript, as I am not a JS guru: that means that the
> > code itself
> > is simple and/or based on a good javascript library that has a simple and
> > clean api).
> >
> > 2) I want something that is simple and light for the
> developer/administrator
> > (i.e. for me).
> > This simplicity is desired when installing the program, as well as when
> > modifying the
> > program, and in my mind this means the app operates either as standalone
> > cgi/wsgi
> > scripts or as a web2py app (ideally, just copy/edit Python scripts, no
> need
> > to run
> > complicated procedures (compile, make, hack the makefile, or setup,
> > buildout, paster,
> > etc)
> >
> > 3) Just a simple, basic, code, without too many or too complex features,
> > would
> > be useful. From such an essential base, a Python developper/app
> > administrator can
> > elaborate as desired additional ad hoc functions.
> >  (I cou

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

2009-10-24 Thread Vincent Borghi
Hello,

On Sat, Oct 24, 2009 at 4:45 PM, Yarko Tymciurak <
resultsinsoftw...@gmail.com> wrote:

> On Sat, Oct 24, 2009 at 9:26 AM, mdipierro wrote:
>
>>
>> We could write one. Can you send more specs?
>>
>
In fact, in my mind, I was looking for an already existant application,
but if you are ready to develop a new one from scratch, why not?!
Thanks for your responsiveness, and see my requirements below...

that is, can you state clearly what you want (and don't want), what problems
> you anticipate (e.g. expected scheduling conflicts, exceptions - e.g. a
> director level person is allowed to override a reservation, and how that
> should be handled),  the kinds of resources (and pertinent information about
> them), and the population that will be served by this system (and what you
> want for them, and their experience).
>
> From there, we can start a conversation to develop specifications.   The
> implementation (e.g. python, web2py, or whatever) then should be chosen by
> what can best accomplish what you want (for example - you may want a level
> of interaction that suggests Flash on the client end, or not...).
>

Not really specs, but some requirements follow:

1) I want to be able to easily customize/modify the application myself,
and for my personal taste and experience, this simply means that Python is a
must.
This also means that for the rendering, I want no Flash but just
html+css+javascript
(preferably simple javascript, as I am not a JS guru: that means that the
code itself
is simple and/or based on a good javascript library that has a simple and
clean api).

2) I want something that is simple and light for the developer/administrator
(i.e. for me).
This simplicity is desired when installing the program, as well as when
modifying the
program, and in my mind this means the app operates either as standalone
cgi/wsgi
scripts or as a web2py app (ideally, just copy/edit Python scripts, no need
to run
complicated procedures (compile, make, hack the makefile, or setup,
buildout, paster,
etc)

3) Just a simple, basic, code, without too many or too complex features,
would
be useful. From such an essential base, a Python developper/app
administrator can
elaborate as desired additional ad hoc functions.
 (I could find php- or perl-based freeware with many (not necessarily
useful) features;
but I prefer something small but easily customizable/augmentable)

4) Usage scenario:
The app would be used by some users (between 50 and 200) to book resources.
Typical "resource" examples are: meeting rooms; time slots to remotely
access to a given computer; laptop or other device offered in a self service
pool of equipment.
In my case, I plan to manage just some "resources" (5 or 6, perhaps more
in the future).
A resource booking involves mainly 3 things: a resource, a time slot, a user
(who has booked
the resource). Perhaps a comment from the user would be a useful 4th
characteristic.

5) Users can consult the reservations already registered for a given
resource.
As in Google calendar, the user has the choice between several views:
perhaps "month",
"week", and "agenda" (the linear list of occupied time slots). The user can
scroll /browse
thru the reservation calendar (forward/backward).

6) Users can book a resource: they specify the concerned resource and the
desired time slot,
and possibly a comment. If the time slot is free, the booking is recorded.
If the requested
time slot is totally or partially unavailable, the booking is not performed.
The user must chose an available slot.

7) A user can himself cancel (remove) a resource booking he has previously
performed.

8) As a bonus, a kind of "approver" role can be introduced: the approver can
tag
a resource reservation as "approved" (validated", "acted"...)

9) As a developer, I can customize the code to introduce some form
of access control (lists of users authorized...). Authentification is out
the
scope of the application itself. I'll provide my own checks in the code
(perhaps based on the prseence of some cookies previously set by an
external SSO system...).

10) A log of operatoons (booking, cancelation) is available for the
administrator.

11) Base actions have perhaps hooks associated 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 Borghi  wrote:
>> > 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

[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 must be open source, written in Python,
and possibly a web2py application (or else, Python scripts
usable thru cgi or wsgi).

Thanks for your suggestoons

--~--~-~--~~~---~--~~
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
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[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

On Wed, May 27, 2009 at 1:19 PM, mdipierro  wrote:
>
> Try
>
> 
> 
> 
> 

Thanks for the prompt suggestion, but it does not work.
With this code, 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  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 submit button.
>>
>> === test1/views/default/searchform.html ===
>> {{extend 'layout.html'}}
>> Type something and press the button.
>> 
>> 
>> > onclick="ajax('{{=URL(r=request,f='search')}}',['q'],'target');"/>
>> 
>> 
>> 
>>
>> === test1/controllers/default.py ===
>> #[...]
>> def searchform():
>>     return dict()
>> #
>> def search():
>>     chars = ""
>>     if request.vars.q:
>>         chars = request.vars.q     # (to do: sanitize chars)
>>     rows = 
>> db(db.contact.site_code.like('%'+chars+'%')|db.contact.customer_rsa.like('%'+chars+'%')).select()
>>     return SQLTABLE(rows, truncate=48)
>>
>> ==
>>
>> In myhttp://127.0.0.1:8000/test1/default/searchformpage,
>> once the input field is filled with something, then:
>> - if I press enter, my browser (Firefox 3) apparently does
>>   a GET of the same current URL ("searchform"), without passing parameters.
>>   This is not what i expect.
>> - if I click on the submit button, i obtain the expected behavior,
>>   i.e. the browser does a "POST /test1/default/search" passing
>>  appropriately the "q=xxx" param.
>>
>> How to obtain the same behavior whether the user hits Enter or he
>> clicks Submit?
>>
>> Thanks
> >
>

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---



[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/default.py ===
#[...]
def searchform():
return dict()
#
def search():
chars = ""
if request.vars.q:
chars = request.vars.q # (to do: sanitize chars)
rows = 
db(db.contact.site_code.like('%'+chars+'%')|db.contact.customer_rsa.like('%'+chars+'%')).select()
return SQLTABLE(rows, truncate=48)

==

In my http://127.0.0.1:8000/test1/default/searchform page,
once the input field is filled with something, then:
- if I press enter, my browser (Firefox 3) apparently does
  a GET of the same current URL ("searchform"), without passing parameters.
  This is not what i expect.
- if I click on the submit button, i obtain the expected behavior,
  i.e. the browser does a "POST /test1/default/search" passing
 appropriately the "q=xxx" param.

How to obtain the same behavior whether the user hits Enter or he
clicks Submit?

Thanks

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~--~~~~--~~--~--~---