Best Available seat question

Thanks Bob!

>>> "Bob Bell" 6/3/2011 9:26 AM >>>

The Section assigned to a seat in Facility Manager is stored in the T_SEAT table. The Section column in T_SEAT is a numeric value that joins to the ID column in the TR_SECTION table.

Bob


From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Gloria Ormsby
Sent: Friday, June 03, 2011 9:11 AM
To: Robert Bell
Subject: RE: [Tessitura Web Forum] Best Available seat question


I believe the sections are pulled from zones.

From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Amy Aldrich
Sent: Thursday, June 02, 2011 4:52 PM
To: Gloria Ormsby
Subject: [Tessitura Web Forum] Best Available seat question


I am going to try to explain this as best as possible since I am not a technical mastermind.
We are in the process of developing a new web site. We have a seat map for one of our venues that has seating built as tables, with 5 seats at a table. So when you see the seat listed its (Section aka.. table) 101, (Row) C, (Seats) 1-3.
Our web developers tell me that when they query the seats (this is for best available seating) they don't see the "Sec" (table) number. They just see the ID of the section description from TR_Section, which is different from the table label or name.
How can they see this table number? Anyone have any ideas or suggestions?They see the row and the seat numbers, but not the correct "section (table)" not to be confused with the labels on the sections tab in the facility manager seat map.
I apologize if this doesn't make sense.
Thanks,
Amy





You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!



You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!



You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!

Thanks Bob!

>>> "Bob Bell" 6/3/2011 9:26 AM >>>

The Section assigned to a seat in Facility Manager is stored in the T_SEAT table. The Section column in T_SEAT is a numeric value that joins to the ID column in the TR_SECTION table.

Bob


From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Gloria Ormsby
Sent: Friday, June 03, 2011 9:11 AM
To: Robert Bell
Subject: RE: [Tessitura Web Forum] Best Available seat question


I believe the sections are pulled from zones.

From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Amy Aldrich
Sent: Thursday, June 02, 2011 4:52 PM
To: Gloria Ormsby
Subject: [Tessitura Web Forum] Best Available seat question


I am going to try to explain this as best as possible since I am not a technical mastermind.
We are in the process of developing a new web site. We have a seat map for one of our venues that has seating built as tables, with 5 seats at a table. So when you see the seat listed its (Section aka.. table) 101, (Row) C, (Seats) 1-3.
Our web developers tell me that when they query the seats (this is for best available seating) they don't see the "Sec" (table) number. They just see the ID of the section description from TR_Section, which is different from the table label or name.
How can they see this table number? Anyone have any ideas or suggestions?They see the row and the seat numbers, but not the correct "section (table)" not to be confused with the labels on the sections tab in the facility manager seat map.
I apologize if this doesn't make sense.
Thanks,
Amy





You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!



You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!



You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!