[TYPO3-dam] dd_dam_gallery - development discussion (was 'DAM Photo Gallery' in german list)
Jan-Hendrik Heuing [DD]
jh at digitaldistrict.de
Wed Oct 5 10:18:04 CEST 2005
I guess it's related to the links not having any categories... This is alpha
anyway, so it just needs some more time I have to spend on that ;)
JH
"Thomas Peterson" <info at thomas-peterson.de> schrieb im Newsbeitrag
news:mailman.1.1128467565.29671.typo3-project-dam at lists.netfielders.de...
> Hey,
>
> I have a Problem with dd_links.
>
> The Query:
>
> SELECT tx_ddlinks_link.uid, tx_ddlinks_link.tstamp, tx_ddlinks_link.title,
> tx_ddlinks_link.link, tx_ddlinks_link.description, tx_ddlinks_cat.title AS
> cat_title FROM tx_ddlinks_link, tx_ddlinks_cat,
> tx_ddlinks_link_category_mm WHERE tx_ddlinks_link.uid =
> tx_ddlinks_link_category_mm.uid_local AND
> tx_ddlinks_link_category_mm.uid_foreign = tx_ddlinks_cat.uid AND
> tx_ddlinks_link.deleted=0 AND tx_ddlinks_link.hidden=0 AND
> tx_ddlinks_link.fe_group IN (0,-1) AND tx_ddlinks_cat.deleted=0 AND
> tx_ddlinks_cat.hidden=0 AND tx_ddlinks_cat.fe_group IN (0,-1) AND
> tx_ddlinks_link_category_mm.uid_foreign IN (-1) AND tx_ddlinks_link.title
> LIKE '%' LIMIT 0,30
>
> dosen't work.
>
> When i edit:
>
> tx_ddlinks_link_category_mm.uid_foreign IN (-1)
>
> in:
>
> tx_ddlinks_link_category_mm.uid_foreign = 1
>
> it works :-D
>
> Best Regards
> Thomas Peterson
>
More information about the TYPO3-project-dam
mailing list