Locked Seats SQL query

Hello all,  I want to execute tp_cleanup_connection query.  The Database No. is pkg_no = 0, perf_no = 3239, seat_no = 360738, locked_by = 240    Which number do I add to the query?

 

 

Parents
  • Thank you Kevin.

     

    DARRELL JONES | Assistant Box Office Coordinator | Tasmanian Symphony Orchestra Pty Ltd

    1 Davey Street, Hobart, Tasmania | GPO Box 1450 Hobart, Tasmania                                        

    Tel 03 6232 4404 | Email jonesd@tso.com.au | Website www.tso.com.au

                             

    Description: cid:image002.jpg@01CF009A.9C07BC70

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kevin Madeira
    Sent: Wednesday, 12 March 2014 3:18 PM
    To: Darrell Jones
    Subject: Re: [Tessitura Technical Forum] Locked Seats SQL query

     

    hi Darrell,

    You want  to use the "locked by" number.

    Cheers,

    Kevin

    From: Darrell Jones <bounce-darrelljones8445@tessituranetwork.com>
    Sent: 3/11/2014 10:54:49 PM

    Hello all,  I want to execute tp_cleanup_connection query.  The Database No. is pkg_no = 0, perf_no = 3239, seat_no = 360738, locked_by = 240    Which number do I add to the query?

     

     




    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
  • Thank you Kevin.

     

    DARRELL JONES | Assistant Box Office Coordinator | Tasmanian Symphony Orchestra Pty Ltd

    1 Davey Street, Hobart, Tasmania | GPO Box 1450 Hobart, Tasmania                                        

    Tel 03 6232 4404 | Email jonesd@tso.com.au | Website www.tso.com.au

                             

    Description: cid:image002.jpg@01CF009A.9C07BC70

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kevin Madeira
    Sent: Wednesday, 12 March 2014 3:18 PM
    To: Darrell Jones
    Subject: Re: [Tessitura Technical Forum] Locked Seats SQL query

     

    hi Darrell,

    You want  to use the "locked by" number.

    Cheers,

    Kevin

    From: Darrell Jones <bounce-darrelljones8445@tessituranetwork.com>
    Sent: 3/11/2014 10:54:49 PM

    Hello all,  I want to execute tp_cleanup_connection query.  The Database No. is pkg_no = 0, perf_no = 3239, seat_no = 360738, locked_by = 240    Which number do I add to the query?

     

     




    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