Hy Guys !!!
I'm Riccardo from Florence, Italy
I'll like to know who have solved this problem ::
Using Adodb on Mysql the query (belowe) give results,
the same query on Adodb on MSSQL dont' give result !!😕 😕
I dink to much beer?? Or i miss somethigs??
The Query ::
/** tables
$pag_list =the ist of pages
$right_list= the righs on pages
/** list of selected fields
$cmp="$pag_list.ida, $pag_list.nome_link, $pag_list.link_fisico, $pag_list.menu, $pag_list.tipologia, $pag_list.profilo, $pag_list.sequenza, $pag_list.ordine, $pag_list.descrizione_estesa, $pag_list.non_reale, $pag_list.stato_doc, $pag_list.menu_ord, $pag_list.icona, $pag_list.vario4, $right_list.id_utente";
/** The query
FROM $pag_list INNER JOIN $right_list ON $pag_list.ida = $right_list.id_pagina
WHERE ($right_list.id_utente)=$idut
:eek: :eek:
