Does anyone know how to add Constituency to Output Set Builder? Thanks.
Hi Beth,
For some reason, it’s still not working for me. It doesn’t seem to like what I put in the Data Where column.
I specified “list_no=<<p6>>”
(Where “6” is the row ID where I added the list parameter inTR_QUERY_ELEMENT_PARAMETER).
I get the error:
SyntaxFrom SQL caused these errors: SQLSTATE = 42000
Microsoft OLE DB Provider for SQL Server
Incorrect syntax near “=”
Execute dbo.RP.RUN_QUERY;1 @query_no = 15, @list_no = 0
Thanks for the help!
Elizabeth
___________________________________
ELIZABETH LEE
Associate Director, I.T.
NEW YORK PHILHARMONIC
10 Lincoln Center Plaza
New York, NY 10023
Ph. 212.875.5589
eFax 646.349.5170
email: LeeE@nyphil.org
www.nyphil.org
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Hawryluk Sent: Friday, September 07, 2012 1:57 PM To: Lee, Elizabeth Subject: RE: [Tessitura Technical Forum] Adding Constituency to Output Set Builder
Hmm. To me it looks like it simply doesn't like what you've put into one of the columns (possibly the data_where box?). But I noticed that the forum post didn't like my previous copy/paste from the cookbook. I've tried it in my system here and got this to work for me.
In the table TR_QUERY_ELEMENT: Description: Constituency String Category: Custom Data Select: !.constit Data From: (select customer_no, dbo.fs_const_string(customer_no) as 'constit', list_no from t_list_contents) Data Where: list_no=<<p5>> Control Group: (Blank) Single Row: Checked In the Data Where column you want to make sure that the number following the 'p' matches the id number from TR_QUERY_ELEMENT_PARAMETER that you are building for this. In my system it matches row 5.
In the table TR_QUERY_ELEMENT_PARAMETER: Description: List Data Type: Number End of Day: Unchecked Multi Select: Unchecked Ref Tbl: vs_list Ref Id: List_no Ref Desc: list_desc Ref Where: (blank) Ref Sort: list_desc
Hope that helps....
From: Elizabeth Lee <bounce-elizabethlee9872@tessituranetwork.com> Sent: 9/7/2012 12:12:25 PM
Thank you for responding. We are on v.10. I tried the sample from the cookbook but end up with the following SQL error. I am not a SQL guru so I have no idea what it means or what I’ve done wrong.
SyntaxFrom SQL caused these errors: SQKSTATE = 4200
Incorrect syntax near ‘<’.
Execute dbo.RP_RUN_QUERY:1 @query_no =15, @list_no = 0
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Hawryluk Sent: Friday, September 07, 2012 12:47 PM To: Lee, Elizabeth Subject: Re: [Tessitura Technical Forum] Adding Constituency to Output Set Builder
Hi Elizabeth,
Are you on V10 or V11? I can't seem to find the most recent version of the Output Set Builder Cookbook on the website here but I do have an older one saved on my computer. This should give you the constituency string (from the header) for V10. And maybe V11....? Good luck!
800x600 Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
This element outputs the constituency string that is used in the Constituent Header.
Column Name
Example Value
Description
Constituency_String
Category
Custom
Data_Select
!.constit
Data_From
(select customer_no, dbo.fs_const_string(customer_no) as 'constit', list_no from t_list_contents)
Data_Where
list_no = <<p##>>
Control_Group
[Blank]
Single_row
[Checked]
List
Data_Type
Number
End_Of_Day
[Unchecked]
Multi_Select
Ref_Tbl
vs_list
Ref_Idcol
list_no
Ref_Desccol
list_desc
Ref_Where
Ref_sort
From: Elizabeth Lee <bounce-elizabethlee9872@tessituranetwork.com> Sent: 9/7/2012 11:00:50 AM
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!
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
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!
Elizabeth,
If you can take the entries you currently have for this element in TR_QUERY_ELEMENT and TR_QUERY_ELEMENT_PARAMETER and enter it in a support help ticket, we'll be happy to help you work out where the incorrect syntax is.