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
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)