• Replies 14 replies
  • Subscribers 337 subscribers
  • Views 9 views
  • Users 0 members are here
Related

Order By Command Not Working

Triland McConico
$organization

Hi,

I have a report where I'm trying to sort by last name then first name.  I cannot get the Order By command to work.  Can someone share with me what I might be doing wrong?  Syntax Below:

ORDER BY d.lname, d.fname DESC

Parents
  • $organization

    I tried and it still does not work.  Anything else I might try.  Where you able to get it to work on your side.

     

    Triland L. McConico

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jason Kaiser
    Sent: Friday, October 26, 2012 12:52 PM
    To: Triland McConico
    Subject: Re: [Tessitura Technical Forum] Order By Command Not Working

     

    Try:   ORDER BY d.lname, d.fname

    From: Triland McConico <bounce-trilandmcconico7946@tessituranetwork.com>
    Sent: 10/25/2012 6:54:00 PM

    Hi,

    I have a report where I'm trying to sort by last name then first name.  I cannot get the Order By command to work.  Can someone share with me what I might be doing wrong?  Syntax Below:

    ORDER BY d.lname, d.fname DESC




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    I tried and it still does not work.  Anything else I might try.  Where you able to get it to work on your side.

     

    Triland L. McConico

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jason Kaiser
    Sent: Friday, October 26, 2012 12:52 PM
    To: Triland McConico
    Subject: Re: [Tessitura Technical Forum] Order By Command Not Working

     

    Try:   ORDER BY d.lname, d.fname

    From: Triland McConico <bounce-trilandmcconico7946@tessituranetwork.com>
    Sent: 10/25/2012 6:54:00 PM

    Hi,

    I have a report where I'm trying to sort by last name then first name.  I cannot get the Order By command to work.  Can someone share with me what I might be doing wrong?  Syntax Below:

    ORDER BY d.lname, d.fname DESC




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data