Hey everyone (by which I mean Sandra Ashby J if you’re listening),
I built two custom query elements to output attribute values (Birthdate N1 and Birthdate N2). They run fine when they are in output sets individually, but when I put both of them into a single output set I get an “ambiguous column name keyword_no” error. Anyone know how I can work around this?
Here’s what I’ve got for my elements:
ID
DESCRIPTION
CATEGORY
DATA_SELECT
DATA_FROM
DATA_WHERE
CONTROL_GROUP
207
Birthdate N1
101
!.key_value
VXS_CUST_KEYWORD
keyword_no = 1
208
Birthdate N2
keyword_no = 2
Thanks in advance,
Rey
--
A. Rey Pamatmat
Tessitura Manager
The Public Theater
425 Lafayette Street
New York, NY 10003
(212) 539-8739
rpamatmat@publictheater.org
Ahhh, clever… and effective! It worked!
Thank you, Mr. Barnett.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick Barnett Sent: Monday, December 13, 2010 12:47 PM To: Rey Pamatmat Subject: Re: [Tessitura Technical Forum] Ambiguous Column Name Output Set Kerfuffle
I'm not certain this will work, but I'm hopeful...
Try moving the WHERE clause into the FROM clause. So, for example, put this whole string in the DATA_FROM, including:
(select * from vxs_cust_keyword where keyword_no=1)
From: A. Rey Pamatmat <bounce-areypamatmat2177@tessituranetwork.com> Sent: 12/13/2010 11:29:31 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!