[TYPO3-english] cooluri and calendar base

[Jan Bednarik]

Hi Oliver,

you can try something, but I'm not sure if it will work. If it doesn't 
then it's not possible. Use this SELECT:

SELECT CONCAT( uid , '_', title ) FROM tx_cal_event WHERE uid=$1 and 
'event' = '{tx_cal_controller[view]}'
UNION
SELECT CONCAT( uid , '_', title ) FROM tx_cal_location WHERE uid=$1 and 
'location' = '{tx_cal_controller[view]}'

Regards

Jan

Dne 19.11.2012 21:25, web napsal(a):
>
>
> Hello list members,
>
>
>
> i just try to find a working solution for calendar base with cool uri.
>
>
>
> The problem is the query within the <uriparts>
>
>
>
> Ex.
>
> <part>
>
>         <parameter>tx_cal_controller[uid]</parameter>
>
>         <lookindb>
>
>           <to>SELECT CONCAT( uid , '_', title ) FROM tx_cal_event WHERE
> uid=$1</to>
>
>           <translatetoif>
>
>             <match>^[0-9]+$</match>
>
>           </translatetoif>
>
>           <urlize>1</urlize>
>
>         </lookindb>
>
>      </part>
>
>
>
> Everything is fine for tx_cal_controller[view]=event, but for location
> and/or organizer the lookindb fail.
>
> The select is done by using the wrong table.
>
> Location should use the table tx_cal_location and not ex_cal_event. the url
> result shows the wrong url including the result of select tx_cal_event.
>
>
>
> So is there a way to use a if marker or something else?
>
>
>
> Best regards Oliver
>