developer.jelix.org is not used any more and exists only for history. Post new tickets on the Github account.
developer.jelix.org n'est plus utilisée, et existe uniquement pour son historique. Postez les nouveaux tickets sur le compte github.

Opened 9 years ago

Closed 9 years ago

#1435 closed bug (fixed)

Limit queries are not completely shown in the debugbar

Reported by: nesswaw Owned by:
Priority: normal Milestone: Jelix 1.3.1
Component: jelix:db Version: 1.3.0
Severity: normal Keywords:
Cc: Blocked By:
Blocking: Documentation needed: no
Hosting Provider: Php version:

Description

Bonjour,

Apparemment la balise <limit> n'est pas pris en compte ou alors j'ai fait une faute...voici le code XML de ma méthode:

        <method name="published" type="select">
            <parameter name="offset" />
            <parameter name="count" />
            <conditions>
                <eq property="published" value="1" />
            </conditions>
            <order>
                <orderitem property="date" way="asc" />
            </order>
            <limit offset="$offset" count="$count"/>
        </method>

La requête généré devient:

SELECT ... FROM table... WHERE published = 1 ORDER BY date asc

Testé sous Jelix 1.3

Change History (4)

comment:1 Changed 9 years ago by nesswaw

Après quelque test et fouille dans les fichiers, il semble que le LIMIT soit quand même appliqué, mais que la debugbar n'affiche pas ce LIMIT dans la requête...

comment:2 Changed 9 years ago by laurentj

  • Component changed from jelix to jelix:db
  • Milestone set to Jelix 1.3.1

comment:3 Changed 9 years ago by laurentj

  • Summary changed from jDao, méthode XML et balise <limit> to Limit queries are not completely shown in the debugbar

comment:4 Changed 9 years ago by laurentj

  • Resolution set to fixed
  • Status changed from new to closed
Note: See TracTickets for help on using tickets.