select max(protocollo) as num_prot from protocollo where data = #createODBCdate(dateformat(form.data_prot, "dd/mm/yyyy"))# select max(IDprotocollo) as max_id_prot from protocollo insert into segnalazioni (tipo, Idutente, IDoggetto, Data_ins) values ('protocollo', #i#, #cattura.max_id_prot#, #createODBCdateTIME(now())#) select p.*, d.Doc_pert_settore from protocollo p INNER JOIN doc_pertinenza d ON p.ID_doc_pertinenza = d.ID_doc_pertinenza where IDprotocollo = #url.generato#
Protocollo assegnato: #dateformat(dati.data, "yymmdd")#0#dati.protocollo##dati.Doc_pert_settore#

select IDSocieta, Societa, eliminato from anagrafica where Cliente = 'si' and nascosto = 0 and eliminato = 0 order by Societa SELECT * FROM doc_tipo order by doc_tipo SELECT * FROM doc_formato order by doc_formato SELECT * FROM doc_pertinenza SELECT IDUtente, Nome, Cognome FROM utenti Where #session.logo# = 1 and IDutente <> #session.IDutente# ORDER BY Cognome, nome

" class="form-control">