5 : SELECT s.*, m.mid FROM showcase s
6 : LEFT JOIN media_core m ON m.mfilenameorig = 'referenz_' + s.bildbasename + '.jpg' AND m.mlocation = '6DR6X2XB'
7 : WHERE id=<cfqueryparam value="#int(id)#" cfsqltype="CF_SQL_INTEGER">
8 : </cfquery>
9 : <cfif referenz.recordcount gt 0>
|