SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'www.likhom.com'<br />SELECT puFP FROM factures_produits WITH(NOLOCK) where idFP=21<br />SELECT top 8 idserv, nomserv, adrpictook, motserven FROM services WITH(NOLOCK) ORDER by ordre<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'page'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'personne'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'personnes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'personne'<br />SELECT V.[nomvilleen],D.[nomdepen], R.[nomregen], P.[nompaysen], L.adresse, L.tel ,  L.Numlieu, L.codecatlieu, V.[code dep], L.codpost, L.lat, L.lng, L.site, L.email, L.ville,L.nomlieu,L.idville ,P.code, L.pays from lieux L  WITH (NOLOCK) INNER JOIN villesmonde V with(nolock) ON L.idville = V.[code ville] INNER JOIN départementmonde D WITH (NOLOCK) ON V.[code dep] = D.id INNER JOIN régionmonde R WITH (NOLOCK) ON D.idreg = R.id INNER JOIN pays P WITH (NOLOCK) ON R.pays = P.code WHERE ( V.[nomvilleen]='plouha' or V.[nomvilleen]='plouha' ) AND LOWER(replace(replace(replace(L.[nomlieu],' ','-'),'''','-'),'°','-')) LIKE 'univers-ponies-ecurie-d-and-g-ollivier' COLLATE French_CI_AI<br />SELECT [nom affiché], [nomdepen] FROM départementmonde WHERE [id] = '22' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambres-proche-loisir' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'France'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Activités disponibles à proximité'<br />SELECT libellecatlieu FROM categorielieux WITH (NOLOCK) where codecatlieu = '4' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Activités sportives'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'page'<br />EXECUTE [dbo].[Rech_serv_capacite_rand_loisir] '10152','', '15', 'ville', '', '0', '', '', '0'<br />Execute vignette 'en', 'BR2210018', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'avis'<br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />EXECUTE [dbo].[Rech_serv_capacite_round_loisir] '30','48.681','2.9015','+','en', '10152', '' , '15' ,'ville' , '', '0' <br />Execute vignette 'en', 'FR180183', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR180183' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Texte de présentation en'<br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='fr' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR180183' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='en' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR180183' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='it' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR180183' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='es' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR180183' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='nl' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR180183' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='de' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR180183' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'FR120422', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'avis'<br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BR2208013', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'avis'<br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'FR170027', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR170027' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Texte de présentation en'<br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='fr' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR170027' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='en' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR170027' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='it' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR170027' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='es' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR170027' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='nl' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR170027' <br />Select texteintroc FROM [chambre/languetxt] with(nolock) where isnull(tradautoc,0) = 0 AND idlang='de' AND isnull(texteintroc,'') <> '' AND [code chambre] Like 'FR170027' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'FR140081', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'avis'<br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BR2209006', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'avis'<br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BR2200005', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />Execute vignette 'en', 'BR2207009', 'classiqueC'<br />Select [EUR] as Vdevisech, symbole from devises with(nolock) where diminutif = 'GBP' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'avis'<br />SELECT TOP 1 en, DATEDIFF(day,date,getdate()) as Jour, urlasp FROM traductionurl WITH (NOLOCK)  WHERE fr= 'chambre_hotes' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambre d''hôtes'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'jour'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Lire la suite'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Détails'<br />SELECT TOP 1 numlieu from LieuxStats where numlieu like '4451' and [moiscourant] like '19/04' <br />UPDATE LieuxStats SET [ANGnbconn]= [ANGnbconn]+1 WHERE numlieu like '4451' and [moiscourant] like '19/04'<br />SELECT libelle FROM descriptions with(nolock) WHERE ISNULL(libelle,'') <> '' AND  idlang='en' AND libtype='lieux' AND idtype = '4451' AND statut = 1  <br />Select url,titre FROM photos with(nolock) WHERE idtype = '4451' AND statut = 1 AND libtype='lieux' order by principale desc<br />Select (L.nomlieu) as nom, (V.[nomvilleen]) as nom1, (D.[nomdepen]) as nom2, (R.[nomregen]) as nom3, (P.[nompaysen]) as nom4 from lieux L with(nolock) INNER JOIN villesmonde V with(nolock) ON L.[idville] = V.[code ville] INNER JOIN départementmonde D with(nolock) ON V.[code dep] = D.id INNER JOIN régionmonde R with(nolock) ON D.idreg = R.id INNER JOIN pays P with(nolock) ON R.pays = P.code where L.[Numlieu] = '4451' <br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traduction WITH (NOLOCK)  WHERE francais= 'Chambres d''hôtes et gîtes proche : ||lieu||'<br />SELECT TOP 1 anglais, DATEDIFF(day,dateacces,getdate()) as Jour FROM traductionsupp WITH (NOLOCK)  WHERE francais= 'Chambres d''hôtes et gîtes proche : ||lieu||'<br /> <font face="Arial" size=2>
<p>Erreur d'ex&#233;cution Microsoft VBScript</font> <font face="Arial" size=2>erreur '800a000d'</font>
<p>
<font face="Arial" size=2>Type incompatible: 'ANGdate'</font>
<p>
<font face="Arial" size=2>/fonctions_asp/fonction-traductions.asp</font><font face="Arial" size=2>, ligne 77</font>