[TYPO3-dam] dd_dam_gallery - development discussion (was 'DAM Photo Gallery' in german list)
Thomas Peterson
info at thomas-peterson.de
Wed Oct 5 22:01:05 CEST 2005
Hello
>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 ;)
>
My Links have categories.
>
> "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
More information about the TYPO3-project-dam
mailing list