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 10 years ago

Closed 10 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 10 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 10 years ago by laurentj

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

comment:3 Changed 10 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 10 years ago by laurentj

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