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!!
Qt 6.11 is out! See what's new in the release blog

Count QSqlquery results!!

Scheduled Pinned Locked Moved General and Desktop
20 Posts 10 Posters 42.2k 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.
  • A Offline
    A Offline
    absfrm
    wrote on last edited by
    #10

    hi
    thanks Hostel.i tried it.

    so thanks Andre. Excellent answer.

    ;) be happy

    If You Want You Can!

    1 Reply Last reply
    0
    • 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
          • ? Offline
            ? Offline
            A Former User
            wrote on last edited by
            #14

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

            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
                • ? Offline
                  ? Offline
                  A Former User
                  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
                  • ? Offline
                    ? Offline
                    A Former User
                    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