='Infinity', w2p_timeout=3))
On Saturday, August 3, 2013 4:10:49 AM UTC+2, Matt Grham wrote:
Thanks a lot Niphlod. Actually that was the case. I started to use
web2py 2.4.6 but my app was built using web2py 1.99.7. I updated web2py.js,
web2py_ajax.html and layout.html. It works now. But if I
I have a table like:
3 records found
Man_IDMan_Type
8BC
8BC
8BC
When I try to group by Man_ID, it does the grouping but it prints
Unsupported Query on top of the table
*Unsupported query
Man_IDMan_Type
8BC
) and all the other fields
need to be an aggregate of the basic field (such as count, min, max, etc)
?
On Saturday, August 3, 2013 8:09:39 PM UTC+2, Matt Grham wrote:
I have a table like:
3 records found
Man_IDMan_Type
8BC
8BC
8BC
meaningful.
man_type needs to be either included in your groupby (in which case, it
equals a distinct type of query) or used as an aggregate (first, last,
count, etc etc etc)
On Saturday, August 3, 2013 8:52:21 PM UTC+2, Matt Grham wrote:
Fields to be shown:
fields = ( db[str_tableName].Man_ID
BC
Thanks,
Matt
On Saturday, August 3, 2013 12:40:31 PM UTC-7, Niphlod wrote:
it may work on some backends (namely, SQLite), but that query doesn't
rally make sense. What do you need as a result precisely ?
On Saturday, August 3, 2013 9:25:44 PM UTC+2, Matt Grham wrote
Could be but I am trying to do it in SQLFORM.grid statement. How can I do
that?
On Saturday, August 3, 2013 4:04:40 PM UTC-7, villas wrote:
For the example you provide, probably better with: distinct=True
That is the usual SQL method of suppressing duplicate rows.
--
---
You received
want
On Friday, August 2, 2013 7:06:22 AM UTC+2, Matt Grham wrote:
Hi All,
I have a grid in a LOAD component. How can I remove the .load extensions
from the grid links (next page and export csv links)?
Thanks,
Matt
--
---
You received this message because you are subscribed
with web2py.js). Any
LOADed grid has links that are trapped by default, and all links lead to
change only the fragment where the grid has been loadeddid you fiddle
with web2py.js or layout.html ?
On Friday, August 2, 2013 10:43:47 AM UTC+2, Matt Grham wrote:
with .load, page 2 of table opens
Thanks a lot Niphlod. Actually that was the case. I started to use web2py
2.4.6 but my app was built using web2py 1.99.7. I updated web2py.js,
web2py_ajax.html and layout.html. It works now. But if I want to refresh
the component in every 30 seconds, I am having a problem. Sometimes
pagination
Hi All,
I have a grid in a LOAD component. How can I remove the .load extensions
from the grid links (next page and export csv links)?
Thanks,
Matt
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop
Hi All,
When I try to upload a file that is greater than 15 MB to a blob data
field, I get the following error from pymysql:
(type 'exceptions.AssertionError', AssertionError('Result length not
requested length:\nExpected=21071312. Actual=16777025. Position: 190.
Data Length: 16777215',))
Hi All,
The following table definition does not work all the time. Sometimes
it gives the following error: IntegrityError: column name is not
unique. I want to receive the error at the form level.
db.define_table('testtable',
Field('name', 'text', unique=True, notnull=True),
,
db.testtable.name))
otherwise the second requires overrides the previous ones, web2py
checks only for IS_ALPHANUMERIC, not uniqueness and the database
checks for uniqueness raising an exception.
On Jun 16, 12:27 am, matt grham matt.gr...@gmail.com wrote:
Hi All,
The following table
13 matches
Mail list logo