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='FR' 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=1130)) 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='FR' 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=1130)) 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

Inscription à la newsletter