Error Executing Database Query.
|
Table 'location_knd.Offres_Courantes' doesn't exist
|
|
The error occurred in /var/www/cfcs/f_dl_LADP/offre.cfc: line 1067
Called from /var/www/DL_ladp2015/fiche-produit.cfm: line 36
Called from /var/www/DL_ladp2015/fiche-produit.cfm: line 1
Called from /var/www/DL_ladp2015/Application.cfc: line 139
Called from /var/www/cfcs/f_dl_LADP/offre.cfc: line 1067
Called from /var/www/DL_ladp2015/fiche-produit.cfm: line 36
Called from /var/www/DL_ladp2015/fiche-produit.cfm: line 1
Called from /var/www/DL_ladp2015/Application.cfc: line 139
|
1065 : ,CASE WHEN date_format(Offre_DateCreation,'%d/%m/%y')=date_format(Offre_DateCreation,'%d/%m/%y') THEN DATE_ADD(offre_datecreation,INTERVAL #arguments.nHeuresVIP# HOUR) ELSE DATE_ADD(offre_dateconvention,INTERVAL #arguments.nHeuresVIP# HOUR) END as Offre_compteur2
1066 : from Offres_Courantes
1067 : where offre_dossier ='#arguments.offre_dossier#'
1068 : and (offre_enattentevalidation IS NULL or offre_enattentevalidation=0)
1069 : and offre_dateConvention IS NOT NULL
|
|
SQLSTATE |
42S02 |
DATASOURCE |
directe-location |
VENDORERRORCODE |
1146 |
SQL |
select *,
CASE WHEN Offre_quartierBis<>'' then Offre_quartierBis WHEN Offre_Quartier<>'' then Offre_quartier ELSE ''END as quartier2,
CASE WHEN date_format(Offre_DateCreation,'%d/%m/%y')=date_format(Offre_DateConvention,'%d/%m/%y') THEN offre_datecreation ELSE offre_dateConvention END as Offre_compteur
,CASE WHEN date_format(Offre_DateCreation,'%d/%m/%y')=date_format(Offre_DateCreation,'%d/%m/%y') THEN DATE_ADD(offre_datecreation,INTERVAL 24 HOUR) ELSE DATE_ADD(offre_dateconvention,INTERVAL 24 HOUR) END as Offre_compteur2
from Offres_Courantes
where offre_dossier ='30-0182-21'
and (offre_enattentevalidation IS NULL or offre_enattentevalidation=0)
and offre_dateConvention IS NOT NULL
and offre_dateConvention <> ''
and 150=150
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
172.70.134.99 |
Referrer |
|
Date/Time |
28-Mar-24 11:01 PM |
|