On Tuesday, 3 September 2013 16:52:34 UTC+10, Niphlod wrote:
>
> totally unrelated note: did you try simply loading a grid via ajax ? if
> your db isn't slow, from the user perspective it's pretty fast.
>
> On Tuesday, September 3, 2013 2:10:59 AM UTC+2, Tim Richardson wrote:
>>
>> Can anyone pr
but I want to orderby one field and not all the fields. I want to orderby
Table1.id only.
On Tue, Sep 3, 2013 at 7:53 AM, Niphlod wrote:
>
>
> On Tuesday, September 3, 2013 1:57:15 AM UTC+2, web2py_tn wrote:
>>
>> but that defeats the purpose if I order by all the fields.
>> I've been trying fo
you have a problem with what you want and what you get
Assuming a table
id name surname
1 tywin lannister
2 tyrion lannister
3 eddard stark
4 sansa stark
and a query where you want to know how many members of the Game Of Thrones
families y
it's one of my long-end goals to provide an inline-editing-capable sqlform
grid right in web2py source. As of right now, you're forced to choose a
grid and reinvent the wheelother project made for web2py I think need a
tiddle bit of refactoring, but are a good and solid starting point.
On
I am sorry. I am trying to groupby and not orderby.
I want to select from 2 tables and groupby the id of one table. This works
fine in sqllight but throws an error on postgresql.
Massimo suggested that I add the id of the second table using "|". However,
then I can't get the result I need, which is
Can you recreate a simple test to reproduce that behaviour and open a
ticket about it? It can be a bug of web2py or not.
mic
2013/9/3 André Kablu
> Hi all,
>
> I'd created one application that loads 15 lines of a mysql database.
> Then I put all 150k lines in a list(), doing many math cal
please post your model, a simple data set and what you want as a
resultset
On Tuesday, September 3, 2013 11:42:38 AM UTC+2, web2py_tn wrote:
>
> I am sorry. I am trying to groupby and not orderby.
> I want to select from 2 tables and groupby the id of one table. This works
> fine in sqlligh
This is trivial. You just need a DNS entry for example.com and not for the
specific domains (this is the default anyway). Than in web2py you read the
entry from request.env.http_host
If you use apache (you do not have to use apache) make sure you have a
catch all virtual host
On Monday,
Do
cd web2py
sudo -u www-data python -c "from gluon.main import save_password;
save_password(raw_input('admin password: '),443)"
This will create a password file for you valid when admin is accessed via
https (port 443).
On Monday, 2 September 2013 16:52:10 UTC-5, mark warburton wrote:
>
>
>
after strugeling to get find a way on how to access the console I used this
method:
since I'm working on ubuntu web2py is located at /usr/share/web2py, however
if you start web2py with the desktop shortcut and you create an app it is
located in the ~/web2py/applications folder. so copied it over
Have just unzipped web2py_win.zip, there is a duplicate file name, and the
files are different sizes so I presume have different content. Do we need
either or both of these files?
web2py\applications\examples\static\epydoc\gluon.html.__TAG__-class.html
web2py\applications\examples\static\epydoc\
No. This file should not be there:
gluon.html.__tag__-class.html
I will do some cleanup. We are about to release 2.6.1.
Massimo
On Monday, 2 September 2013 23:13:34 UTC-5, Les Ferguson wrote:
>
> Have just unzipped web2py_win.zip, there is a duplicate file name, and the
> files are different s
On 3 September 2013 11:42, Bassem Bouguerra wrote:
> I am sorry. I am trying to groupby and not orderby.
> I want to select from 2 tables and groupby the id of one table. This works
> fine in sqllight but throws an error on postgresql.
>
> You cannot do that in Postgresql. If you want to group b
Hi,
I have recently start to use the scheduler module which looks great,
but when i try to use a simple example simply doesn't works, any
additional works requires?
created a scheduler.py inside models which contains
---
from gluon.scheduler im
+1
Richard
On Fri, Aug 23, 2013 at 4:22 AM, Michele Comitini <
michele.comit...@gmail.com> wrote:
> IMHO I would be careful in adding support to presentation frameworks
> inside main web2py distribution.
> The scaffolding applications should be a projects on their own.
> This way there could be
I agree that this should be moved to contrib, as suggested. Perhaps even
before 2.6.x is released.
Like I said earlier, I'd move the existing "bootstrap" too.
Regards
On Tuesday, September 3, 2013 3:24:39 PM UTC+2, Richard wrote:
>
> +1
>
> Richard
>
>
> On Fri, Aug 23, 2013 at 4:22 AM, Michele
first things first, if you use queue_task in a model, every request a task
will get queued.
Second thing: enable the debug log to see what a task prints out with -D 0
Third: the scheduler is supposed to be a quasi-daemonic process: you
usually want to read the results from the scheduler_run tabl
I Agree.
On Tue, Sep 3, 2013 at 10:24 AM, Richard Vézina
wrote:
> +1
>
> Richard
>
>
> On Fri, Aug 23, 2013 at 4:22 AM, Michele Comitini
> wrote:
>>
>> IMHO I would be careful in adding support to presentation frameworks
>> inside main web2py distribution.
>> The scaffolding applications should
+1.
Only for put more gas in the fire, more CSS frameworks to develop your own
formstyles:
http://usablica.github.io/front-end-frameworks/compare.html
Regards,
2013/9/3 Vinicius Assef
> I Agree.
>
> On Tue, Sep 3, 2013 at 10:24 AM, Richard Vézina
> wrote:
> > +1
> >
> > Richard
> >
> >
> >
Thanks Niphlod,
Now i really understand how to works the scheduler.
Saludos,
Alfonso de la Guarda
Twitter: @alfonsodg
Redes sociales: alfonsodg
Telef. 991935157
1024D/B23B24A4
5469 ED92 75A3 BBDB FD6B 58A5 54A1 851D B23B 24A4
On Tue, Sep 3, 2013 at 8:32 AM,
According to:
http://web2py.com/books/default/chapter/29/10/services#Restful-Web-Services,
for the given controller api() the following example should be working:
$ curl -d "name=Tim" http://127.0.0.1:8000/myapp/default/api/friend.json
{"errors": {}, "id": 1}
1. The first line I think it
this part of the code works;
{{if auth.is_logged_in():}}{{for settings in
records:}}{{=db.settings[auth.user_id].fontsize}}{{pass}}{{else:}}{{=12}}px:}
but the preferences a logged in user makes seem to affect other users
setting.
On Sunday, September 1, 2013 4:43:27 AM UTC+1, viniciusban wrote
Dear Massimo Di Pierro
Please i need your help , i have this problem which is about my sites admin
.
i installed web2py at centos and made configuration with zpanel anyhow
after time i figured out away to run web2py sites by making web2py folder
copy for each site and i replaced the site into w
hello my code
if not auth.has_membership('admin'):
* db.trabalhador.val_formacao.writable=False*
form=SQLFORM(db.trabalhador,row.id,
showid=False,
submit_button="Gravar",
fields=['nome','bi','ncart','ncartval','rfid','apt_medica','apt_medicaval',*
'val_formac
Cut and paste from the book :
When a field is marked with writable=False, the field is not shown in
create forms, and it is shown readonly in update forms. If a field is
marked aswritable=False and readable=False, then the field is not shown at
all, not even in update forms.
Forms created with
f
Andrew, clear your IE cache and try downloading the file again, or rename
the file and then try downloading it. IE < 9.0 will use the cache control
headers, so the file will be cached if you don't use the attachment
keyword. Look at line ~300 in the globals.py
On Tuesday, August 27, 2013 3:38:4
What i want to say and dont know why is that coding
*db.trabalhador.val_formacao.writable=False*
*db.trabalhador.val_formacao.readable=False*
*
*
*before my sqlform*
*
*
Results int the field beeing displayed and editable
That is not what i want
I want to hide the field in the form
2013/9/3 V
maybe this way:
select min(id), count(*), surname from table group by surname
?
On Tuesday, September 3, 2013 5:43:42 AM UTC-7, Johann Spies wrote:
>
> On 3 September 2013 11:42, Bassem Bouguerra
> > wrote:
>
>> I am sorry. I am trying to groupby and not orderby.
>> I want to select from 2 tabl
On Tue, Sep 3, 2013 at 12:47 PM, António Ramos wrote:
>
> shows the val_formação label only, no input text
Because Web2py shows readable fields as text, not as a readonly field.
You see nothing probably because the field has no contents in this record.
--
---
You received this message becau
2013/9/3 Richard Vézina
> Not sure I understand what you want to say here : "shows the val_formação
> label only, no input text"
>
*Not sure I understand what you want to say here : "shows the val_formação
label only, no input text"*
*
*
i meant no editable input "field" in the webpage.
--
--
On Tue, Sep 3, 2013 at 1:55 PM, António Ramos wrote:
>
> I want to hide the field in the form
So, don't include its name in fields list.
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving e
That it's you need both in case you want to se the field input but prevent
your user to alter the value, you can set readonly=True in your SQLFORM()
call...
:)
Richard
On Tue, Sep 3, 2013 at 12:55 PM, António Ramos wrote:
> What i want to say and dont know why is that coding
>
> *db.trabalhad
ahHA!
I never use fields in SQLFORM didn't thought about this one...
Richard
On Tue, Sep 3, 2013 at 1:09 PM, Vinicius Assef wrote:
> On Tue, Sep 3, 2013 at 1:55 PM, António Ramos
> wrote:
> >
> > I want to hide the field in the form
>
> So, don't include its name in fields list.
>
> --
>
> -
auth !!
2013/9/3 António Ramos
> I have to include them in the field list because i have another line of
> code to detect it
> if aut.has_membership('admin')
>
> show the field and allow it to be edited
>
> else
> Dont show the field( this is where i have the problem.
>
>
>
>
> 2013/9/3 Viniciu
You could create a kind of user_table_access_profile mechanism for each
table. You start by setting every fields to readable and writable false
then base on a user authentified you can switch field to true base on a
user_table_access_profile.
There is plenty of data structure you can use to store
I have to include them in the field list because i have another line of
code to detect it
if aut.has_membership('admin')
show the field and allow it to be edited
else
Dont show the field( this is where i have the problem.
2013/9/3 Vinicius Assef
> On Tue, Sep 3, 2013 at 1:55 PM, António Ram
uhm. apart from the technicalities of global_settings, shouldn't be better
to just import current and use current.request.folder as the base folder ?
On Tuesday, September 3, 2013 7:36:58 PM UTC+2, Jonathan Lundell wrote:
>
> I have a module in my app's modules/ directory that needs a path to a f
this doesn't return any other meaningful info about the id of the group, it
just uses an aggregate on it. In that case, you'd still need to orderby by
min(id).
tl;dr : any groupby query can be ordered either by a field included in a
group by or by an aggregate of any other column.
On Tuesday, S
I have a module in my app's modules/ directory that needs a path to a file in
private/ at import time (so I can't pass the path in).
Using fileutils.abspath, I have to write:
> abspath('applications', 'watchup', 'private', filename)
presumably because in abspath:
> return os.path.join(glo
On 3 Sep 2013, at 10:36 AM, Jonathan Lundell wrote:
>
> I have a module in my app's modules/ directory that needs a path to a file in
> private/ at import time (so I can't pass the path in).
>
> Using fileutils.abspath, I have to write:
>
>> abspath('applications', 'watchup', 'private', filena
On 3 Sep 2013, at 11:10 AM, Niphlod wrote:
> uhm. apart from the technicalities of global_settings, shouldn't be better to
> just import current and use current.request.folder as the base folder ?
Yeah, that ought to work.
I wasn't thinking along those lines, I guess. Originally, I was doing m
I try to create a new simple application on my local GAE instance (I
clicked 'run' in GAE since that's the only one that has admin). I get this
traceback:
Traceback (most recent call last):
File "C:\Temp\web2py_src\web2py\gluon\admin.py", line 179, in app_create
os.mkdir(path)
File "C:\P
BTW, AFAICT (As Far As I Can Tell :P), the abspath was only meant to have
easier code in admin. Docstring says
"convert relative path to absolute path based (by default) on
applications_parent"
application*s*_parent is the folder where the *applications/* folder is
(where web2py.py usually is),
On 3 Sep 2013, at 12:13 PM, Niphlod wrote:
> BTW, AFAICT (As Far As I Can Tell :P), the abspath was only meant to have
> easier code in admin. Docstring says
> "convert relative path to absolute path based (by default) on
> applications_parent"
>
> applications_parent is the folder where the ap
This issue is now fixed in trunk
2013-09-01
https://github.com/web2py/web2py/commit/085b4a0d15b173d84d92e2ed2b6db30923d2f643
Thanks Massimo
On Wednesday, August 7, 2013 12:57:14 PM UTC+2, step wrote:
>
> Thank yOU for looking into this. Will you post a follow-up to this thread
> or should I mon
On Tue, Sep 3, 2013 at 2:17 PM, António Ramos wrote:
> I have to include them in the field list because i have another line of code
> to detect it
> if aut.has_membership('admin')
>
> show the field and allow it to be edited
So, just insert your field in this situation.
Make the fields list varia
to flush the memory, import gc then call gc.collect()
On Monday, September 2, 2013 10:03:07 PM UTC-7, André Kablu wrote:
>
> Hi all,
>
> I'd created one application that loads 15 lines of a mysql database.
> Then I put all 150k lines in a list(), doing many math calculations.
> The results are
Given:
SELECT t1.t1_f1, max(t2.t2_f1) FROM t1 JOIN t2 on t1.id = t2.t1_id GROUP BY
t1.t1_f1 ORDER BY max(t2.t2_f1), t1.t1_f1;
If I recall correctly in PostgreSQL you can do:
SELECT t1.t1_f1, max(t2.t2_f1) FROM t1 JOIN t2 on t1.id = t2.t1_id GROUP BY
1 ORDER BY 2,1;
i.e. you can use the positi
It's not fixed for me. I've updated the issue.
On Thursday, August 29, 2013 8:14:56 PM UTC-5, Massimo Di Pierro wrote:
>
> Should be fixed. Can you check?
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group
jeditable is reasonably easy to work with for a cell at a time editing, and
works with SQLFORM.grids. Have played around with kendoui grids and their
editing is some of the nicest. Could put together some crude examples.
--
---
You received this message because you are subscribed to the Goog
Hadn't heard of jeditable ... 'works with SQLFORM.grids' sounds good ...
crude examples or pointers would be good, particularly around communicating
updates (this is the big unknown for me).
On Wednesday, 4 September 2013 11:06:33 UTC+10, Simon Ashley wrote:
>
>
> jeditable is reasonably easy t
I'm a newbie to web2py, but the book examples have gotten me a long ways,
and the forum (GG) has helped, also.
I have set up a pretty simple SOAP service, and have turned on Basic AUTH.
I get the correct results when the client provides the correct header, so
all that's good. But I'd like t
I agree. I work with different designs and systems and the frameworks vary
greatly.
It would be nice to just let me select what I want.
Bootstrap 2.x
Bootstrap 3.x
Bare
Sass Based
etc...
On Tue, Sep 3, 2013 at 5:03 PM, José Ricardo Borba wrote:
> +1.
>
> Only for put more gas in the fire, more
On Monday, July 1, 2013 10:47:16 PM UTC+8, Ray (a.k.a. Iceberg) wrote:
>
> On Monday, July 1, 2013 7:30:51 PM UTC+8, Ray (a.k.a. Iceberg) wrote:
>>
>> Hi folks,
>>
>> I just noticed that, the auto patterns generated by dal.py's
>> parse_as_rest() are using hyphen to replace underline. This way if
54 matches
Mail list logo