Results 1 to 5 of 5

Thread: Sorting records in MappingSqlQuery

  1. Dec 4th, 2007, 02:11 PM #1
    imchi
    imchi is offline Junior Member
    Join Date
    Apr 2007
    Posts
    21

    Default Sorting records in MappingSqlQuery

    Hi,
    I have a MappingSqlQuery that reads a data set sorted with an ORDER BY statement in SQL. Yet in the returned linked list, I see that the last element is not the last record that would be returned by the SQL. How do I ensure that the ordering is correct?
    Thanks.
    Reply With Quote Reply With Quote
  2. Dec 4th, 2007, 02:20 PM #2
    Arthur Loder
    Arthur Loder is offline Senior Member
    Join Date
    Jul 2006
    Location
    Philadelphia, PA, USA
    Posts
    341

    Default

    This should not be the case. Can you provide the SQL and how you know the final element does not correspond to the last row if issuing the SQL directly to the database?
    Arthur Loder
    Software Engineer
    Fancast
    Comcast Interactive Media
    Reply With Quote Reply With Quote
  3. Dec 4th, 2007, 02:27 PM #3
    imchi
    imchi is offline Junior Member
    Join Date
    Apr 2007
    Posts
    21

    Default

    Never mind, the problem has been resolved. Thanks for the help.
    Last edited by imchi; Dec 4th, 2007 at 03:23 PM.
    Reply With Quote Reply With Quote
  4. Dec 9th, 2007, 01:27 AM #4
    Jörg Heinicke
    Jörg Heinicke is offline Senior Member
    Join Date
    Nov 2005
    Location
    Reutlingen, Germany
    Posts
    2,098

    Default

    It's always nice to give the next one an idea what the issue was and how it was resolved ...

    Joerg
    This post can contain insufficient information.
    Reply With Quote Reply With Quote
  5. Dec 9th, 2007, 09:07 AM #5
    imchi
    imchi is offline Junior Member
    Join Date
    Apr 2007
    Posts
    21

    Default

    Quote Originally Posted by Jörg Heinicke View Post
    It's always nice to give the next one an idea what the issue was and how it was resolved ...

    Joerg
    It was an error in my SQL statement. Not related to the Spring framework.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules