Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Count QSqlquery results!!
Forum Updated to NodeBB v4.3 + New Features

Count QSqlquery results!!

Scheduled Pinned Locked Moved General and Desktop
20 Posts 10 Posters 38.7k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • T Offline
    T Offline
    tucnak
    wrote on last edited by
    #11

    You should write something:
    @
    I will read documentation.
    I will read documentation.
    I will read documentation.
    I will read documentation.
    I will read documentation.
    I will read documentation.
    I will read documentation.
    I will read documentation.
    @

    P.S. Use <code>int numRowsAffected()</code>

    1 Reply Last reply
    0
    • A Offline
      A Offline
      andre
      wrote on last edited by
      #12

      [quote author="abbas farahmand" date="1326023459"]I'm using mysqli . support it?
      if no , how can i get the size or number of row in results?

      i used
      @

      query.numRowsAffected()

      @

      too
      but its not worked![/quote]

      [quote author="tucnak" date="1326032692"]You should write something:
      @
      I will read documentation.
      I will read documentation.
      I will read documentation.
      I will read documentation.
      I will read documentation.
      I will read documentation.
      I will read documentation.
      I will read documentation.
      @

      P.S. Use <code>int numRowsAffected()</code>[/quote]

      Conclusion:
      [quote]
      I will read previous posts before replying.
      ...
      [/quote]

      1 Reply Last reply
      0
      • D Offline
        D Offline
        dangelog
        wrote on last edited by
        #13

        [quote author="tucnak" date="1326032692"]You should write something:
        @
        I will read documentation.
        I will read documentation.
        I will read documentation.
        I will read documentation.
        I will read documentation.
        I will read documentation.
        I will read documentation.
        I will read documentation.
        @

        P.S. Use <code>int numRowsAffected()</code>[/quote]

        Let me now think about your proposal and read the numRowsAffected documentation:
        [quote]
        Returns the number of rows affected by the result's SQL statement, or -1 if it cannot be determined. Note that for SELECT statements, the value is undefined; use size() instead.
        [/quote]

        Software Engineer
        KDAB (UK) Ltd., a KDAB Group company

        1 Reply Last reply
        0
        • G Offline
          G Offline
          goetz
          wrote on last edited by
          #14

          Yeah, there's still a little difference between reading documentation and understanding documentation...

          http://www.catb.org/~esr/faqs/smart-questions.html

          1 Reply Last reply
          0
          • A Offline
            A Offline
            absfrm
            wrote on last edited by
            #15

            hi again
            Andre answer me excellent ,that's OK.
            why did you reply again?

            be happy.
            thanks all.

            If You Want You Can!

            1 Reply Last reply
            0
            • Z Offline
              Z Offline
              Zarkon
              wrote on last edited by
              #16

              Thanks for this post. I was just wrestling with this problem.

              1 Reply Last reply
              0
              • A Offline
                A Offline
                Atron
                wrote on last edited by
                #17

                For anyone with the same problem, I used to get the rows length with:

                @query->record().count()@

                I hope may help someone.

                1 Reply Last reply
                0
                • A Offline
                  A Offline
                  Atron
                  wrote on last edited by
                  #18

                  For anyone with the same problem, I used to get the rows length with:

                  @query->record().count()@

                  I hope may help someone.

                  1 Reply Last reply
                  0
                  • SGaistS Offline
                    SGaistS Offline
                    SGaist
                    Lifetime Qt Champion
                    wrote on last edited by
                    #19

                    Hi and welcome to devnet,

                    Row length and row count are not the same thing. The row length is the number of field in the row, while the row count is the number of row returned by your query.

                    Interested in AI ? www.idiap.ch
                    Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                    1 Reply Last reply
                    0
                    • SGaistS Offline
                      SGaistS Offline
                      SGaist
                      Lifetime Qt Champion
                      wrote on last edited by
                      #20

                      Hi and welcome to devnet,

                      Row length and row count are not the same thing. The row length is the number of field in the row, while the row count is the number of row returned by your query.

                      Interested in AI ? www.idiap.ch
                      Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                      1 Reply Last reply
                      0

                      • Login

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • Users
                      • Groups
                      • Search
                      • Get Qt Extensions
                      • Unsolved