error message to mention possible
missing "pass" statement.
Thank you and BR
Loreia
On Thursday, March 3, 2011 6:27:00 AM UTC+1, Lennon wrote:
>
> PROBLEM SOLVED
>
> Stupid Mistake.
>
> Please close/delete thread if possible or let me know how I can
> accomplish t
Don't worry this table is modest in size.
Any solution is good enough for me, as long as it gets the job done :-))
Thanks and BR
Loreia
On Fri, Aug 17, 2012 at 9:06 PM, Niphlod wrote:
> np.
> BTW: no simple ways to do that. Just mind that if there are millions rows
> (especially
Thanks a lot.
BR
Loreia
On Thursday, August 16, 2012 1:23:39 PM UTC+2, Niphlod wrote:
>
> group by your unique columns, count the rows, find the ones with count > 1.
>
> db.define_table(
> 'finddup',
> Field('f1_name'),
> Field(&#x
-entries-in-postgresql
But I would like to be able to do it with web2p DAL (which would make it
database independent).
Is there a way to do it with web2py DAL?
I just want to be able to find those duplicates, I don't need to delete
them.
Thank you and best regards,
Loreia
--
f issues in my definition of DB
tables. Still, that MACRO will be useful.
Thank you and BR
Loreia
On Friday, April 27, 2012 10:08:05 PM UTC+2, Cliff wrote:
>
> Field('block_names_id', db.block_names, requires=IS_EMPTY_OR(
> IS_IN_DB(db, 'block_names.id', '%(bloc
Hi Bruce,
G-mail failed to warn me about your answer, so I noticed it only today.
Thanks a lot, it worked like a charm.
The same code worked in sqlite, but I guess Postgres is more restrictive.
Thank you and BR
Loreia
On Friday, April 27, 2012 4:13:33 PM UTC+2, Bruce Wade wrote
xist: integer = character varying at
character 309
HINT: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
I am using latest 1.99.7 Web2py, latest 9.1.2 Postgres, and latest 2.4.4
psycopg2 driver.
Any help is welcomed :-)
BR
Loreia
7 matches
Mail list logo
