[TYPO3-dam] dd_dam_gallery - development discussion (was 'DAM Photo Gallery' in german list)

Thomas Peterson info at thomas-peterson.de
Wed Oct 5 01:12:45 CEST 2005


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