Erreur req. SQL listleft pgm VIEW_ALBUM : ASA Error -131: Syntax error near 'and'
select a.* from DBA.HIGHLIGHTS a,DBA.HIGHLIGHT_SERIES b where a.HIGHLIGHT_ID=b.HIGHLIGHT_ID and a.LANGUE='UK' and b.SERIE_ID= and DATEFORMAT(a.DATE_DEBUT_PARUTION,'yyyy/mm/dd')<=DATEFORMAT(getdate(),'yyyy/mm/dd') and DATEFORMAT(a.DATE_FIN_PARUTION,'yyyy/mm/dd')>=DATEFORMAT(getdate(),'yyyy/mm/dd') and NOT(a.HIGHLIGHT_ID in (select a.HIGHLIGHT_ID from DBA.HIGHLIGHTS a,DBA.HIGHLIGHT_OUVRAGES b where a.HIGHLIGHT_ID=b.HIGHLIGHT_ID and b.OUVRAGE_ID=594)) order by a.HIGHLIGHT_ID DESC
Erreur req. SQL listleft pgm VIEW_ALBUM : ASA Error -131: Syntax error near ')'
select a.* from DBA.HIGHLIGHTS a,DBA.CAT_SERIES b where a.COLLECTION_ID=b.SERIE_COLLECTION_ID and a.LANGUE='UK' and DATEFORMAT(a.DATE_DEBUT_PARUTION,'yyyy/mm/dd')<=DATEFORMAT(getdate(),'yyyy/mm/dd') and DATEFORMAT(a.DATE_FIN_PARUTION,'yyyy/mm/dd')>=DATEFORMAT(getdate(),'yyyy/mm/dd') and NOT(a.HIGHLIGHT_ID in (select a.HIGHLIGHT_ID from DBA.HIGHLIGHTS a,DBA.HIGHLIGHT_OUVRAGES b where a.HIGHLIGHT_ID=b.HIGHLIGHT_ID and b.OUVRAGE_ID=594)) and NOT(a.HIGHLIGHT_ID in (select a.HIGHLIGHT_ID from DBA.HIGHLIGHTS a,DBA.HIGHLIGHT_SERIES b where a.HIGHLIGHT_ID=b.HIGHLIGHT_ID and b.SERIE_ID=)) and b.SERIE_ID= order by a.HIGHLIGHT_ID DESC
