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!!
QtWS25 Last Chance

Count QSqlquery results!!

Scheduled Pinned Locked Moved General and Desktop
20 Posts 10 Posters 38.3k Views
  • 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 8 Jan 2012, 14:14 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 8 Jan 2012, 14:24 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 8 Jan 2012, 14:40 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 8 Jan 2012, 14:50 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 8 Jan 2012, 14:56 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 9 Jan 2012, 05:47 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 17 Jul 2014, 10:43 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 4 Dec 2014, 09:32 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 4 Dec 2014, 09:32 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 5 Dec 2014, 00:24 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 5 Dec 2014, 00:24 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