After last update did not work most of the queries event onSctiptInit
SQL:
SELECT TOP 5 rc.DataRic, rc.NoteAzioni, rc.DataEff, ma.codpercric, rc.CodOperatRic, rc.CodSito FROM RicCli rc
LEFT JOIN ON mio_assegnaric but ma.codric = rc.Codice
onScripyInit:
sc_select_where (add) = “WHERE rc.CodSito = ‘[codsito]’”;
ERROR:
(mssqlnative): select count() from (SELECT TOP 5 rc.DataRic, rc.NoteAzioni,rc.DataEff,ma.codpercric,rc.CodOperatRic,rc.CodSito FROM RicCli rc LEFT JOIN mio_assegnaric ma ON ma.codric=rc.Codice ) nm_sel_esp WHERE rc.CodSito =‘392’ [HR][/HR]4104: SQLState: 42000 Error Code: 4104 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]The multi-part identifier “rc.CodSito” could not be bound.
ADOConnection._Execute(select count() from (SELECT TOP 5 rc.DataRic, rc.NoteAzioni,rc.DataEff,ma.codpercric,rc.CodOperatRic,rc.CodSito FROM RicCli…, false)[SIZE=-1] % line 1085, file: adodb.inc.php[/SIZE] ADOConnection.Execute(select count() from (SELECT TOP 5 rc.DataRic, rc.NoteAzioni,rc.DataEff,ma.codpercric,rc.CodOperatRic,rc.CodSito FROM RicCli…)[SIZE=-1] % line 46, file: aatest_total.class.php[/SIZE] aatest_total.quebra_geral()[SIZE=-1] % line 520, file: aatest_grid.class.php[/SIZE] aatest_grid.inicializa()[SIZE=-1] % line 89, file: aatest_grid.class.php[/SIZE] aatest_grid.monta_grid(0)[SIZE=-1] % line 1850, file: index.php[/SIZE] [TABLE=“class: scErrorTable, align: center, cellpadding: 0, cellspacing: 0”]
[TR]
[TD=“class: scErrorTitle, bgcolor: #FF0000, align: left”]Errore[/TD]
[/TR]
[TR]
[TD=“class: scErrorMessage, bgcolor: #FFDDDD, align: center”]Errore durante l’accesso alla banca dati:
SQLState: 42000 Error Code: 4104 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]The multi-part identifier “rc.CodSito” could not be bound. SQLState: 42000 Error Code: 4104 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]The multi-part identifier “rc.CodSito” could not be bound.
select count() from (SELECT TOP 5 rc.DataRic, rc.NoteAzioni,rc.DataEff,ma.codpercric,rc.CodOperatRic,rc.CodSito FROM RicCli rc LEFT JOIN mio_assegnaric ma ON ma.codric=rc.Codice ) nm_sel_esp WHERE rc.CodSito =‘392’[/TD]
[/TR]
[/TABLE]