Debug -->Status: -2147217900-Incorrect syntax near 'Ã'.-
Debug -->wq_prodotto_allegati -->SELECT COD_ART AS att_codart,ID_ART_ALLEGATO AS att_id,NOME_FILE AS att_filename,EST_FILE AS att_extension,FILE_BIN AS att_content,DIM_FILE AS att_size,NOTE AS att_note,CONTENT_TYPE AS att_type
FROM (
SELECT COD_ART,ID_ART_ALLEGATO,NOME_FILE,EST_FILE,FILE_BIN,DIM_FILE,NOTE,'manual' AS CONTENT_TYPE
FROM ART_ALLEGATI
WHERE ID_TIPO_ALLEGATO = 2 AND (DATA_FINE IS NULL OR getdate() BETWEEN DATA_INIZIO AND DATA_FINE)
UNION ALL
SELECT COD_ART,ID_ART_ALLEGATO,NOME_FILE,EST_FILE,FILE_BIN,DIM_FILE,NOTE,'advertising'
FROM ART_ALLEGATI
WHERE ID_TIPO_ALLEGATO = 3 AND (DATA_FINE IS NULL OR getdate() BETWEEN DATA_INIZIO AND DATA_FINE)
UNION ALL
SELECT COD_ART,ID_ART_ALLEGATO,NOME_FILE,EST_FILE,FILE_BIN,DIM_FILE,NOTE,'tech-specification'
FROM ART_ALLEGATI
WHERE ID_TIPO_ALLEGATO = 4 AND (DATA_FINE IS NULL OR getdate() BETWEEN DATA_INIZIO AND DATA_FINE)
UNION ALL
SELECT COD_ART,ID_ART_ALLEGATO,NOME_FILE,EST_FILE,FILE_BIN,DIM_FILE,NOTE,'ce'
FROM ART_ALLEGATI
WHERE ID_TIPO_ALLEGATO = 6 AND (DATA_FINE IS NULL OR getdate() BETWEEN DATA_INIZIO AND DATA_FINE)
UNION ALL
SELECT COD_ART,ID_ART_ALLEGATO,NOME_FILE,EST_FILE,FILE_BIN,DIM_FILE,NOTE,'review'
FROM ART_ALLEGATI
WHERE ID_TIPO_ALLEGATO = 7 AND (DATA_FINE IS NULL OR getdate() BETWEEN DATA_INIZIO AND DATA_FINE)
UNION ALL
SELECT COD_ART,ID_ART_ALLEGATO,NOME_FILE,EST_FILE,FILE_BIN,DIM_FILE,NOTE,'software'
FROM ART_ALLEGATI
WHERE ID_TIPO_ALLEGATO = 8 AND (DATA_FINE IS NULL OR getdate() BETWEEN DATA_INIZIO AND DATA_FINE)
UNION ALL
SELECT COD_ART,ID_ART_ALLEGATO,NOME_FILE,EST_FILE,FILE_BIN,DIM_FILE,NOTE,'brochure'
FROM ART_ALLEGATI
WHERE ID_TIPO_ALLEGATO = 9 AND (DATA_FINE IS NULL OR getdate() BETWEEN DATA_INIZIO AND DATA_FINE)
) AS ALLEGATI
WHERE (1 = 1)
AND ID_ART_ALLEGATO=29359ù
sfilter-->
ssort-->
ADODB.Recordset
error '800a0e78'
Operation is not allowed when the object is closed.
/asp/get_allegato.asp, line 26