Re: [web2py] new feature - need help

2011-10-06 Thread Richard Vézina
A la Access?! Great...

I will try to give a ride to the new smartgrid to see that... Do you have a
test app or do the code you publish earlier to try the new smartgrid enable
automatically the searhcable function?...

I try anyway.

Richard

On Thu, Oct 6, 2011 at 12:01 AM, Massimo Di Pierro 
massimo.dipie...@gmail.com wrote:

 There is a new feature in trunk. When you make a searchable grid, it will
 now show a button before the search input field. It says Query. Hover over
 it and it will create a popup menu so that you can build the query with the
 mouse.

 It works but the css is horrible and I could use some help fixing it.
 The code is generated by a single function in sqlhtml.py build_search()

 Massimo


Re: [web2py] new feature - need help

2011-10-06 Thread Richard Vézina
Ok, not exactly a la access... Pretty good I notice this :


= create : name = 'something' should be name == 'something'

I don't think about to much about the background complexity of what you try
to achieve, but I don't understand why menu is an appropriate way to display
this query building thing.

Richard

On Thu, Oct 6, 2011 at 2:30 PM, Richard Vézina
ml.richard.vez...@gmail.comwrote:

 A la Access?! Great...

 I will try to give a ride to the new smartgrid to see that... Do you have a
 test app or do the code you publish earlier to try the new smartgrid enable
 automatically the searhcable function?...

 I try anyway.

 Richard


 On Thu, Oct 6, 2011 at 12:01 AM, Massimo Di Pierro 
 massimo.dipie...@gmail.com wrote:

 There is a new feature in trunk. When you make a searchable grid, it will
 now show a button before the search input field. It says Query. Hover over
 it and it will create a popup menu so that you can build the query with the
 mouse.

 It works but the css is horrible and I could use some help fixing it.
 The code is generated by a single function in sqlhtml.py build_search()

 Massimo





Re: [web2py] new feature - need help

2011-10-06 Thread Richard Vézina
I just think for 2 min about it... A popup grid seems to me the appropriate
display for this query builder...

Grid :

Field to search  Wich type of constrainer   Searched value  Add createria
button
Drop box  =, , , etc. User input +
button
New row

Maybe a 'AND' or 'OR' is needed for createria (between line)

Maybe the table should just add a column at the begining when more then one
creteria is entered user has to specify the AND or OR...

So...

AND/ORField to search  Wich type of constrainer   Searched value  Add
createria button
Drop box  =, , , etc. User
input + button
DropboxNew row

Query completed (button)

What about that?!

jQuery UI dialog

Richard


On Thu, Oct 6, 2011 at 3:17 PM, Richard Vézina
ml.richard.vez...@gmail.comwrote:

 Ok, not exactly a la access... Pretty good I notice this :


 = create : name = 'something' should be name == 'something'

 I don't think about to much about the background complexity of what you try
 to achieve, but I don't understand why menu is an appropriate way to display
 this query building thing.

 Richard


 On Thu, Oct 6, 2011 at 2:30 PM, Richard Vézina 
 ml.richard.vez...@gmail.com wrote:

 A la Access?! Great...

 I will try to give a ride to the new smartgrid to see that... Do you have
 a test app or do the code you publish earlier to try the new smartgrid
 enable automatically the searhcable function?...

 I try anyway.

 Richard


 On Thu, Oct 6, 2011 at 12:01 AM, Massimo Di Pierro 
 massimo.dipie...@gmail.com wrote:

 There is a new feature in trunk. When you make a searchable grid, it will
 now show a button before the search input field. It says Query. Hover over
 it and it will create a popup menu so that you can build the query with the
 mouse.

 It works but the css is horrible and I could use some help fixing it.
 The code is generated by a single function in sqlhtml.py build_search()

 Massimo






[web2py] new feature - need help

2011-10-05 Thread Massimo Di Pierro
There is a new feature in trunk. When you make a searchable grid, it will now 
show a button before the search input field. It says Query. Hover over it and 
it will create a popup menu so that you can build the query with the mouse.

It works but the css is horrible and I could use some help fixing it. 
The code is generated by a single function in sqlhtml.py build_search()

Massimo