COPYHOUSE / CREATION – COPY – DIGITAL PRINTING

COPYHOUSE / CREATION – COPY – DIGITAL PRINTING – LARGE FORMAT http://www.copyhouse.be COPYHOUSE / CREATION – COPY – DIGITAL PRINTING – LARGE FORMAT FR COPYHOUSE / CREATION – COPY – DIGITAL PRINTING – LARGE FORMAT info@copyhouse.be info@copyhouse.be 20 May 2012 00:00:00 +0100 20 May 2012 00:00:00 +0100 MegaraM - BONSSSA CMS http://blogs.law.harvard.edu/tech/rss 60 http://www.copyhouse.be/uploads/xslt/rss.jpg COPYHOUSE / CREATION – COPY – DIGITAL PRINTING – LARGE FORMAT http://www.copyhouse.be

ERR : 20/05/2012 11:44:45 99121755
-2147217900 : The text data type cannot be selected as DISTINCT because it is not comparable.
SQL GET RS : select 'news',id,dateDebut,titreFR,introFR,descriptionFR from actualites where dateDebut<='20120520' and dateFin>'20120520' and titreFR<>'' UNION select 'agendas',id,datemodif,titreFR+' ('+dateFR+')',courteFR,descrFR from agenda where titreFR<>'' UNION select 'pages',page,datepub,page,'',contenu from cms where langue='FR' and datepub = (select max(datepub) from cms as cmsJoin where cms.page=cmsJoin.page and cmsJoin.langue=cms.langue) UNION select 'liens',id,datemodif,titreFR,'',descrFR from liens where titreFR<>'' UNION select 'photos',id,datemodif,'Photo ('+galerie+')',description,photo from photos order by 3 desc, 2 desc