Thanks a lot, Bruno! I didn't read carefully enough, sorry for that.
The slides model is working in general now, but I am getting the same
render bug like some posts before regarding the links. Will reply to
the corresponding post.
Jan
On 12 Okt., 00:01, Bruno Rocha wrote:
> you are putting it i
Your example code seems to trigger a bug in MARKMIN, when using the
link and the image tag in a list:
## snip ##
>>> content = """... # My slides title... ## Slide One... this allows you to
>>> create slides using markmin... ## Slide Two... - you can use lists... - you
>>> can use [[links http:/
Have updated issue 454 which was previously closed.
This works with ajax=True (seems to work with multiple tables too
though I have not fully tested) if you have a separate controller for
each table. However:
1) It does not work with ajax=False and ajax_trap=True. In this case
clicking a paginate
I used your example Massimo. The only difference is I tried
emboldening the word 'lists'. (the problem is the same without the
emboldening)
Here is the html file, if you look at it in your browser you will see
the problem on slide two
My slides
how i am developing a system in which i require a validation on name
field...validation shoould be : the field should not accept
numbers ...it should only accept alphabets...i know this is possible
using IS_MATCH in web2py...i tried using
db.organisations.name.requires=[IS_MATCH('^[a-z]', error_m
hi i am developing a system in which i require a validation on name
field...validation shoould be : the field should not accept
numbers ...it should only accept alphabets...i know this is possible
using IS_MATCH in web2py...i tried using
db.organisations.name.requires=[IS_MATCH('^[a-z]',
error_mess
Is this a bug then?
I have tried string and text fields; specifying length and using
IS_LENGTH. In every case it seems to generate strings longer than
specified.
On Oct 11, 4:30 pm, Anthony wrote:
> On Tuesday, October 11, 2011 10:49:59 AM UTC-4, apple wrote:
>
> > Have just started using "popul
we use the DAL for MySQL and pymongo for MongoDB
We are changing everything to MongoDS, so we have some interest in
being able to write MongoDB queries trough the DAL so we woulnd't have
to change lots of code
On Oct 3, 9:57 am, ~redShadow~ wrote:
> On Sun, 2011-10-02 at 14:52 -0700, Francisco C
Hi Francisco, how do you manage the connection to MongoDB server? Do you
establish and close connection on every request or do you use some
connection pooling ?
On Oct 12, 11:00 am, David Marko wrote:
> Hi Francisco, how do you manage the connection to MongoDB server? Do you
> establish and close connection on every request or do you use some
> connection pooling ?
Hi Marko,
for now we are using pymongo like this:
from pymongo import Connection
server =
I am using the iframe widget. It works just fine most of the time,
displaying a website within a frame on the page.
My html is
{{=plugin_wiki.widget('iframe', festival.web_site, width=900,
height=600)}}
However when festival.web_site equals 'http://
www.oxfordjazzfestival.com', then instead of d
I am running a script to update data and on some records I get the error:
*** InternalError: current transaction is aborted, commands ignored until
end of transaction block
Turning on pdb.set_trace() enabled me to find the actual problem line:
skr = db.akb_authors[i]
where i = 176530 in this c
Assume this code is in some db.py file ... so its executed on every request
...?
hello one and all,
i have tried to run the web2py install script on a centos 5.7 server.
it seems to install ok with the addition of adding python 2.6 from
source and compiling it as well. after the install script runs,
apache doesn't restart properly giving the warning "NameVirtualHost *:
80 has
we use it in db.py, not sure where should be the optimal way for it
On Oct 12, 11:52 am, David Marko wrote:
> Assume this code is in some db.py file ... so its executed on every request
> ...?
Massimo adviced me to use something like this previsously:
def make_connection():
from pymongo import Connection
connection = Connection('localhost', 27017)
return connection
connection = cache.ram('mongodb',make_connection,None)
It seemed to work but I had no opportunity to
I don't think it's the widget, I think that site is using a
framekiller: http://en.wikipedia.org/wiki/Framekiller.
You could try implementing a framekiller
killer: http://en.wikipedia.org/wiki/Framekiller
Anthony
On Wednesday, October 12, 2011 6:49:03 AM UTC-4, peter wrote:
>
> I am using the
Sorry, here's the correct framekiller killer
link: http://en.wikipedia.org/wiki/Framekiller#Framekiller_Killers
On Wednesday, October 12, 2011 7:12:25 AM UTC-4, Anthony wrote:
>
> I don't think it's the widget, I think that site is using a framekiller:
> http://en.wikipedia.org/wiki/Framekiller.
On 12 October 2011 10:41, Saurabh S wrote:
> db.organisations.name.requires=[IS_MATCH('^[a-z]',
>
>
This means that you will only names with one character and that character
must be in the range a-z.
The following form will accept names with any character except 0-9.
See the
form = SQLFORM.f
Seems like a bug. You can report it
here: http://code.google.com/p/web2py/issues/list
On Wednesday, October 12, 2011 4:55:44 AM UTC-4, apple wrote:
>
> Is this a bug then?
>
> I have tried string and text fields; specifying length and using
> IS_LENGTH. In every case it seems to generate string
Have you read the chapter on access
control: http://web2py.com/book/default/chapter/08? The Auth system should
be able to handle this kind of thing for you. You can use @auth decorators
on your actions to require login, group membership, or other arbitrary
conditions. If the user is not logged
I think your regular expression is only matching a single character.
Instead, try:
^[a-z]+ # the + says to match one or more characters.
You might want ^[a-zA-Z]+ to match upper or lower case.
Anthony
On Wednesday, October 12, 2011 4:41:00 AM UTC-4, Saurabh S wrote:
>
> hi i am developing a
Also, I don't think you need the initial ^.
On Wednesday, October 12, 2011 7:25:11 AM UTC-4, Anthony wrote:
>
> I think your regular expression is only matching a single character.
> Instead, try:
>
> ^[a-z]+ # the + says to match one or more characters.
>
> You might want ^[a-zA-Z]+ to match up
On Oct 12, 12:07 pm, David Marko wrote:
> Massimo adviced me to use something like this previsously:
>
> def make_connection():
> from pymongo import Connection
> connection = Connection('localhost', 27017)
> return connection
>
> connection = cache.ram('mongodb',make_connection,Non
On Wednesday, October 12, 2011 7:13:53 AM UTC-4, spyker wrote:
>
>
> Field('your_name', requires=IS_MATCH('\D+')
>
Note, \D will match any non-digit character, not just letters.
I use this
@auth.requires_login()
in my controller before DEF
but with that option I get login, form but my menu is visible, it not
redirect my page to my login page, just put login form in place of my
conteten.
after that I tray tu put if statement in layout.html and in if that is
checked logi
Both can be in db.py file and so available for entire application = to other
db_xx.py files and controlers ... the same thing as standard 'db' sql
connection variable defined in db.py by default.
Here is what I use (in a file models/0.py):
import pymongo
from pymongo import ASCENDING, DESCENDING
def make_mongo_connection():
mdb = pymongo.Connection()
return mdb
mdb = cache.ram('mongodb', make_mongo_connection, 0)
# in the code I use mdb as needed.
# On a busy site, it may make s
Em 12/10/2011 03:57, "dlypka" escreveu:
>
> Thanks - your reply helped me see how it works.
> I did not realize that web2py just puts the name of *only* the
> selected radio button
> in request.vars.
That is not up to web2py. this is how html forms work in general.
when a form is submited *only*
Thanks both. I ended up adding an id field to the tables.
On 11 October 2011 16:20, Massimo Di Pierro wrote:
> The new grid/smartgrid have a much better search feature. A new button
> query shows a popup panel that allows you to build the query string.
> Can you please check on your existing tables and see if you encounter
> any problems?
>
> You will ne
By default, @auth.requires_login() should be redirecting to the 'user'
action in the 'default' controller, which will then look for the
/views/default/user.html view file for rendering. Do you have the standard
user.html file? If so, it extends layout.html. If you don't want it to
extend layout
Shouldnt the cache.ram('mongodb', make_mongo_connection, 0) has the None
instead of 0? Having 0 it doesnt work as a cache as it refreshes connection
on each request ...
On 12 October 2011 13:33, Anthony wrote:
> On Wednesday, October 12, 2011 7:13:53 AM UTC-4, spyker wrote:
>>
>>
>> Field('your_name', requires=IS_MATCH('\D+')
>>
>
> Note, \D will match any non-digit character, not just letters.
>
>
That is what I said: anything except 0-9.
It allows for
> I have replaced my all my similar .js and .css files with that of the
> welcome app but I see no popup panel.
It may be that the old .css is cached in your browser and needs to be
reloaded
- try to refresh the browser page once. That was the case for me.
A new button "query" should appear left
Yeah, that's probably better for names. Names can include hyphens as well.
On Wednesday, October 12, 2011 8:56:35 AM UTC-4, spyker wrote:
>
> On 12 October 2011 13:33, Anthony wrote:
>
>> On Wednesday, October 12, 2011 7:13:53 AM UTC-4, spyker wrote:
>>>
>>>
>>> Field('your_name', require
I'm using SQLTABLE in a view and I'm specifying 'orderby' to add
sortable column headers, eg,
orderby=db.products.name
I have the linkable column headers, but when I click on them, NOTHING
changes. The order of the rows remain the same.
So, what am I missing here? Shouldn't this "just work"?
Th
I just got a beta account with pythonanywhere, and want to test it out. I'm
new to web2py. Can you provide any info on how you went about setting it up?
On Sat, Oct 8, 2011 at 3:42 AM, GoldenTiger wrote:
> I beta tester of a future specific python hosting http:/
> www.pythonanywhere.com
>
> WE
We should move to python27 for gae
On Oct 11, 10:47 pm, pbreit wrote:
> http://code.google.com/appengine/docs/python/python27/newin27.html
So basically the events are associated to the table and only apply to
single record event. This reduces the scope and makes things simple.
But is this what other people are asking?
On Oct 12, 12:18 am, guruyaya wrote:
> On Oct 12, 4:18 am, Massimo Di Pierro
> wrote:
>
> > As I said, the problem
Please show us the code (the man and two controllers).
On Oct 12, 3:09 am, apple wrote:
> Have updated issue 454 which was previously closed.
>
> This works with ajax=True (seems to work with multiple tables too
> though I have not fully tested) if you have a separate controller for
> each table.
How long is the list of sids? Slite? This is not a web2py error but
most likely a driver error. Try commit after every every update.
On Oct 12, 5:49 am, Johann Spies wrote:
> I am running a script to update data and on some records I get the error:
>
> *** InternalError: current transaction is ab
Can you try the latest markmin (from trunk)?
On Oct 12, 2:37 am, jotbe wrote:
> Your example code seems to trigger a bug in MARKMIN, when using the
> link and the image tag in a list:
>
> ## snip ##
>
> >>> content = """... # My slides title... ## Slide One... this allows you to
> >>> create sli
David,
This kind of explains why pyodbc cannot run on apache under wsgi.
The below link solution may also work with you because I assume
Uniform server is built with correct compiler.
https://groups.google.com/group/web2py/browse_thread/thread/1cc544f52d9aeac4/eb79347e29582367#eb79347e29582367
+1
Martin
2011/10/12 Massimo Di Pierro
> We should move to python27 for gae
>
> On Oct 11, 10:47 pm, pbreit wrote:
> > http://code.google.com/appengine/docs/python/python27/newin27.html
Hope nobody gets offended by this email and I have no option but bring
it up because I have received few emails on the topic.
This is a multinational, multicultural community and this is a very
good thing. We want to keep it this way. Each of us has different
believes. Some people have expressed t
Still not working:
### HG rev:
$ LC_ALL=C; hg summary
parent: 2503:0f3a2bc13026 tip
fixed problem with missing identity in auth
branch: default
commit: 2 modified, 1 deleted, 5 unknown
update: (current)
### Py-CLI:
$ python web2py.py -P -M -S slides
web2py Web Framework
Created by Massimo Di P
I cannot reproduce it. I get:
Python 2.7.2 (v2.7.2:8527427914a2, Jun 11 2011, 15:22:34)
[GCC 4.2.1 (Apple Inc. build 5666) (dot 3)] on darwin
>>> print MARKMIN(content)
... # My slides title
... ## Slide One
... this allows you to create slides using markmin
... ## Slide Two
... - you can use lis
I don't think that's how it works. I get 404 error when trying to
manually download a model. I'm not sure how but I believe web2py
handles this internally and prevents simple attacks like you're
thinking of. It may be worth asking the experts though.
On Oct 11, 6:01 pm, Alex wrote:
> the files
I don't know how everyone else feels about this, but I am not easily
offended. I'm generally very laid back and take a "to each their own"
approach to something I don't agree with. Having said that, I have to deal
with extremists on both sides of a wide variety of different topics in
regular li
On Oct 12, 2011, at 6:22 AM, Massimo Di Pierro wrote:
> We should move to python27 for gae
>
> On Oct 11, 10:47 pm, pbreit wrote:
>> http://code.google.com/appengine/docs/python/python27/newin27.html
Yes, but...
> Python 2.7 is now available as an experimental runtime for all applications
> u
But not '*', '%' and so on. hehehe
On Wed, Oct 12, 2011 at 10:00 AM, Anthony wrote:
> Yeah, that's probably better for names. Names can include hyphens as well.
>
> On Wednesday, October 12, 2011 8:56:35 AM UTC-4, spyker wrote:
>>
>> On 12 October 2011 13:33, Anthony wrote:
>>>
>>> On Wednesday
Massimo, you got the point: event dispatched to each affected line. :-)
I see it working as conventional RDBMS triggers work as well. Not
more, not less.
--
Vinicius Assef.
On Wed, Oct 12, 2011 at 10:24 AM, Massimo Di Pierro
wrote:
> So basically the events are associated to the table and on
The url is validated. .. is not allowed in the URL.
On Oct 11, 5:01 pm, Alex wrote:
> the files in the uploads folder should be save since they are all
> renamed. But what happens if the user passes e.g. '../models/db.py' as
> parameter? (the slashes would have to be encoded though, is this
> pos
A View calles/requests/redirects to some controller.
It takes some time to serve the request.
In the meantime, how do I display animated "Loading" image?
It will disappear after the request is served.
Vineet
Help! I'm running into a serious and puzzling problem running multiple
web2py shell processes against a common database. I'm using web2py
1.97 and sqlite3 under Linux Mint 10 with an ext4 file system. In a
nutshell, the problem is that I'm getting various DatabaseErrors when
one process attempts
Hi,
The company I work for places environmental measuring devices at
different locations. I've designed a simple database to keep track of
where we have devices. One thing that's important to us is how long a
device has been on site.
It's probably easiest to understand if I just paste some code.
I'm with Ross.
I'm part of Brazilians' web2py community and here we face different
religious and health beliefs among us.
Some of us are activists on twitter about our beliefs. There is our
personal channel to spread our word.
Here, I'm not supposed to read messages different from web2py issues,
A View requests or redirects to some controller.
It takes some time to serve the request.
In the meantime, how do I display animated "Loading" image?
It will disappear after the request is served.
Vineet
On Oct 12, 2011, at 7:48 AM, Michael Ellis wrote:
> Help! I'm running into a serious and puzzling problem running multiple
> web2py shell processes against a common database. I'm using web2py
> 1.97 and sqlite3 under Linux Mint 10 with an ext4 file system. In a
> nutshell, the problem is that I
Reminder of issue 354: http://code.google.com/p/web2py/issues/detail?id=354
I have never used a select trigger, so I only have vague ideas about how it
would be useful.
For inserts, a single line is sufficient. For deletes/update, that is not
true.
You can look at (todor's fixes to) my implem
I am not using Jython. Please see the version information in my prev.
reply. Strange issue.
Should I send you my markmin2html.py for comparison?
On 12 Okt., 16:16, Massimo Di Pierro
wrote:
> I cannot reproduce it. I get:
>
> Python 2.7.2 (v2.7.2:8527427914a2, Jun 11 2011, 15:22:34)
> [GCC 4.2.1
On 11/10/2011 22:23, Massimo Di Pierro wrote:
form=SQLFORM(...).process(onsuccess=lambda form:...)
not exactly what I was asking for... I thought about a method of the
table object run in specific situation, example just before or just
after a new record is inserted and so on... remind that a r
Yes, the markimin and the sample code.
On Oct 12, 10:03 am, jotbe wrote:
> I am not using Jython. Please see the version information in my prev.
> reply. Strange issue.
>
> Should I send you my markmin2html.py for comparison?
>
> On 12 Okt., 16:16, Massimo Di Pierro
> wrote:
>
>
>
>
>
>
>
> > I
You can use compute type field (search for compute in the book) you just
have to put your delta in a lambda function... That if you want to store the
computed value...
Or you can use virtual field that can compute also (not sure about that)
your delta will be execute each time to call you select v
I am trying to define a custom type on a MySQL db and I get the error
below. My motivation is to store data in Bigint rather than Integer.
bigint = SQLCustomType(
type = 'integer',
native = 'bigint',
)
db.define_table('s1',
Field('target_id', bigint)
)
db.s1.inser
Hi Vinnet:
The easiest way to achive this, is showing a image (http://www.ajaxload.info/
El Wed, 12 Oct 2011 06:59:32 -0700 (PDT)
Massimo Di Pierro escribió:
> Hope nobody gets offended by this email and I have no option but bring
> it up because I have received few emails on the topic.
>
> This is a multinational, multicultural community and this is a very
> good thing. We want to
markmin2html attached.
Sample code/CLI-snippet (same as below):
https://gist.github.com/90231ab4713fb2e6588b
On Wed, Oct 12, 2011 at 5:14 PM, Massimo Di Pierro <
massimo.dipie...@gmail.com> wrote:
> Yes, the markimin and the sample code.
>
> On Oct 12, 10:03 am, jotbe wrote:
> > I am not using
Compute field doesn't quite work for calculating days on place
(because it changes every day), but it will make geocoding in my app
much more elegant.
A virtual field was exactly what I needed.
Thank you very much! I guess I skimmed that section of the book too
quickly.
Best regards,
Nate
On O
Code below works fine but:
1) change ajax=False => paginate buttons open the correct page on a
new tab in the browser.
2) change ajax=True again and change first line of test2 to
tablename=request.args(0) and paginate buttons fail as there is no
tablename in the request. It is a useful feature in S
On Wed, 2011-10-12 at 04:07 -0700, David Marko wrote:
> Massimo adviced me to use something like this previsously:
>
> def make_connection():
> from pymongo import Connection
> connection = Connection('localhost', 27017)
> return connection
>
> connection = cache.ram('mongodb'
> I'd turn on the ext4 barrier option just for the heck of it; see what happens.
>
> http://lwn.net/Articles/283161/
Thank you, Jonathan! That seems promising. I'm now testing it on two
systems. So far so good. Let's see if it holds up for a few hours.
I can't believe the Linux maintainers dec
Why do we move to Python 2.7 Massimo ?
I just wonder what made you think so? Is it due to the Multithreading
and Concurrent Request?
On Oct 12, 10:22 pm, Massimo Di Pierro
wrote:
> We should move to python27 for gae
>
> On Oct 11, 10:47 pm, pbreit wrote:
>
>
>
>
>
>
>
> >http://code.google.com/a
Hmmm, still not completely out of the woods. I've seen one instance
of the error so far on one of the new systems. I ran "PRAGMA
integrity_check" from a sqlite3 command line and saw a bunch of "page
never used" reports. Then I ran VACUUM and re-ran the integrity check
which came back ok.
On Oct
FYI, since we use it.
Begin forwarded message:
From: Anthony Tuininga
Date: October 11, 2011 9:43:45 PM CDT
To: , , >
Subject: cx_Oracle 5.1.1
Reply-To:
What is cx_Oracle?
cx_Oracle is a Python extension module that allows access to Oracle
and
conforms to the Python database API 2.0 spe
On Oct 12, 2011, at 9:16 AM, Michael Ellis wrote:
> Hmmm, still not completely out of the woods. I've seen one instance
> of the error so far on one of the new systems. I ran "PRAGMA
> integrity_check" from a sqlite3 command line and saw a bunch of "page
> never used" reports. Then I ran VACUUM
> Does the error ordinarily happen often enough that you can be confident that
> the barrier option makes any difference at all? It could easily be something
> else, though the fact that you don't see the problem on OS X suggests a file
> system issue.
>
> The other thing you might experiment wi
Please open a ticket. Looks like a bug but it can be fixed in 12hrs.
On Oct 12, 10:31 am, chris_g wrote:
> I am trying to define a custom type on a MySQL db and I get the error
> below. My motivation is to store data in Bigint rather than Integer.
>
> bigint = SQLCustomType(
> type = 'int
i know we went back and forth a few months back and i helped with the patch
for it, but it was lightly tested and i never used it myself in a production
environment. i suspect it's a simple fix and i'll take a look at the DAL as
well.
cfh
Hi
Wondering if I can turn off (not display) the new query button in my
SQLFORM.grid and SQLFORM.smartgrid. If not available today, are there
plans to make it optional?
-Jim
I think I found the bug. Please open a ticket so I do not forget. I
can fix this tonight.
On Oct 12, 10:46 am, "jot.be" wrote:
> markmin2html attached.
>
> Sample code/CLI-snippet (same as
> below):https://gist.github.com/90231ab4713fb2e6588b
>
> On Wed, Oct 12, 2011 at 5:14 PM, Massimo Di Pierr
I do not think web2py should move to 2.7. I think web2py on GAE should
deploy using 2.7. I do not see any negative side on running on a more
modern interpreter which is guaranteed to be there. Everywhere I run
I try to get the lastest Python version (2.x of course).
On Oct 12, 11:13 am, Changju
Paolo,
I just finished summarized this setting and post on my blog.
http://ochiba77.blogspot.com/2011/10/how-to-setup-web2py-apache-wsgi-uniform.html
On Oct 10, 5:41 pm, Paolo Caruccio wrote:
> I am very glad I helped
>
> Ciao.
>
> Paolo
rows = db(db.products).select(orderby=db.products.name)
table = SQLTABLE(rows)
You can sort the rows, not the table. The links in the header are just
passed back to the action and can use to make the select dependent on
them.
You can also use
table = SQFORM.grid(db.products)
and you get
SQLFORM.gird(,search_widget=None)
On Oct 12, 12:02 pm, Jim Steil wrote:
> Hi
>
> Wondering if I can turn off (not display) the new query button in my
> SQLFORM.grid and SQLFORM.smartgrid. If not available today, are there
> plans to make it optional?
>
> -Jim
;-)
On Wed, Oct 12, 2011 at 11:48 AM, Nate Atkinson wrote:
> Compute field doesn't quite work for calculating days on place
> (because it changes every day), but it will make geocoding in my app
> much more elegant.
>
> A virtual field was exactly what I needed.
>
> Thank you very much! I guess I
Hello list my doubt is how I can create a list SQLForm.grid from this
consultation that I make to the database
dt1=datetime.datetime(*time.strptime(request.vars.desde,'%Y-%m-%d %H:
%M:%S')[0:6])
dt2=datetime.datetime(*time.strptime(request.vars.hasta, '%Y-%m-%d %H:
%M:%S')[0:6])
query =(a.dialst
Hi Lucas,
I found deploying on Centos 5 very hard work. I tried all the methods
in the book, and none worked for me. I tried Cherokee and would not
recommend that route.
nginx with uwsgi was relatively straightforward and is very fast. Here
are some useful links
https://library.linode.com/web-se
I don't want to start a discussion on politics, religion or philosophy
but I think it is important to realize that politics and religion can
disturb people's live or at least strongly influence their course of
life negatively. In that case it may be disturbing to read a signature
quoting a politica
Thanks for the reply Anthony, useful as always. I tried implementing
the frame killer killer, but it keeps my page in view no matter what,
closing the window being the only way out!
Useful to know that it is not a problem with the widget.
Peter
On Oct 12, 12:13 pm, Anthony wrote:
> Sorry, here'
I know this has been discussed earlier, but I am not sure how to use
JSONP for cross domain communication correctly. This is how I make the
request:
var jqxhr = $.getJSON('get_devices.jsonp', function(data) {
displayList(data);
})
.error(function() { alert("
Hi Vineet,
as juanduke has suggested, I use the following jquery function (I put it in
web2py_ayax.js) instead of standard w2p ajax function to show a loading
image:
function web2py_polling(u,s,t){
$('#'+t).html('');
ajax(u,s,t);
}
Of course you can set some css rules to custom div#loading_gif
Do not forget the *before render* and *after render* and workflow events.
this is very useful triggers and are not related to database.
maybe it is more easy to implement in template engine.
http://zerp.ly/rochacbruno
Em 12/10/2011 10:24, "Massimo Di Pierro"
escreveu:
> So basically the event
Well done!
Paolo
http://code.google.com/p/web2py/issues/detail?id=469
Just ask when I should test it.
Regards,
Jan
On 12 Okt., 19:06, Massimo Di Pierro
wrote:
> I think I found the bug. Please open a ticket so I do not forget. I
> can fix this tonight.
>
> On Oct 12, 10:46 am, "jot.be" wrote:
>
>
>
>
>
>
>
> >
SQLFORM.grid does not take rows. It take the query itself. It needs
the query to optimize the select for orderby and pagination. You can
in fact do:
query =(a.dialstatus=='ANSWER')& (a.inicio>=dt1)&(a.inicio<=dt2)
left =
(b.on(a.id_accountcode==b.id),rp.on(a.id_rutaproveedor==rp.id),r.on(rp.id_r
u
Thank you
2011/10/12 Massimo Di Pierro
> SQLFORM.grid does not take rows. It take the query itself. It needs
> the query to optimize the select for orderby and pagination. You can
> in fact do:
>
> query =(a.dialstatus=='ANSWER')& (a.inicio>=dt1)&(a.inicio<=dt2)
> left =
> (b.on(a.id_accountcode
Note: tested on 1.97.1; I believe problem (or my misunderstanding) is still
on trunk. I tried to check with trunk, but I have some compatibility
problems to solve first - I will post an update when I have solved them.
I have an included table defined like this:
included = db.Table('included',
Do we need a policy about this?
"live and let live" ?
1 - 100 of 126 matches
Mail list logo
