Re: [Modeling-users] Double Result

[Sebastien B. <sbi...@us...>]

>  As a quick workaround, try typing the same at mysql prompt, but with
> SELECT DISTINCT: does it help?
>=20
> If it does, you can add the following method to
> DatabaseAdaptors.MySQLAdaptorLayer.MySQLSQLExpression:
>=20
> ------------------------------------------------------------------------
>   def assembleSelectStatementWithAttributes(self, attributes, lock, quali=
fier,
>                                             fetchOrder, selectString,
>                                             columnList, tableList, whereC=
lause,
>                                             joinClause, orderByClause,
>                                             lockClause):
>     """
>     """
>     selectString=3DselectString or 'SELECT DISTINCT'
>     super=3DSQLExpression.assembleSelectStatementWithAttributes
>     return super(self, attributes, lock, qualifier, fetchOrder, selectStr=
ing,
>                  columnList, tableList, whereClause, joinClause,=20
>                  orderByClause, lockClause)
> ------------------------------------------------------------------------

Sorry, I meant:

    selectString=3DselectString or 'SELECT DISTINCT '
                                                 ^

with a trailing whitespace after DISTINCT.

-- S=E9bastien.