[TYPO3-english] cooluri and calendar base (Jan Bednarik)

[web]

Hi Jan,

I test this, but 
<to>
SELECT CONCAT( uid , '_', title ) FROM tx_cal_event WHERE uid=$1 and 'event'
= '{tx_cal_controller[view]}'
UNION
SELECT CONCAT( uid , '_', name ) FROM tx_cal_location WHERE uid=$1 and
'location' = '{tx_cal_controller[view]}'
	
</to>

The event link is ok, the location show the UID select on Event. The Link
would work but shows the wrong information.

It seems that the union won't work, or the result of union is the UID of the
first Table. The clause where in combination of 'event', normaly in this
case sql will have a look to field "event"... so may be this section is
ignored and the result show the title of table Event.
I don't know. But it won't work...
Good Idee, but...

Thanks, if you have any other ideas?? 

Oliver