[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