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

[Jan Bednarik]

Hi Oliver,

the thing is that I don't know whether {tx_cal_controller[view]} will be 
replaced by the actual value. If it was then the query would work? Could 
you try to replace the values manually and run it in some SQL tool? If 
the query is OK, but doesn't work on web, then I guess the replacement 
is not working.

Regards

Jan

Dne 1.12.2012 19:27, web napsal(a):
> 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
>
>
>