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 receiv
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
man_id
>
> and expecting it to return something 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
de the group by column(s) 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
>
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
e the same functionality
> just creating a DIV with the proper data- attributes (this is what LOAD()
> does)...
>
> DIV(_id="mydiv", data=dict(w2p_remote=URL('default', 'thisgrid.load'),
> w2p_times='Infinity', w2p_timeout=3000
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
y 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:
>>
>
;s probably something you don't 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)?
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:
(, AssertionError('Result length not
requested length:\nExpected=21071312. Actual=16777025. Position: 190.
Data Length: 16777215',))
The error is raised from the pee
(db,
> 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 wrote:
>
> > Hi All,
>
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),
13 matches
Mail list logo