execute($sql); echo $db->errorMsg(); while (!$rsMenu->EOF) { $sql = "select P.pgna_endereco, M.menu_nome, MC.menu_ctgr_descricao, M.MENU_DESCRICAO from usuario U inner join grupo_permissao GP on U.GRUPO_ID = GP.GRUPO_ID inner join menu M on M.PAGINA_ID = GP.PAGINA_ID inner join pagina P on P.PAGINA_ID = GP.PAGINA_ID inner join menu_categoria MC on MC.MENU_CATEGORIA_ID = M.MENU_CATEGORIA_ID where U.usuario_id = '" . $_SESSION["security_usuario_id"]."' and MC.MENU_CATEGORIA_ID = " .$rsMenu->fields("MENU_CATEGORIA_ID"). " and M.MENU_SHOW = 1 and GP.GRPO_PRMS_BLOQUEIA = 'Libera' order by menu_ctgr_descricao, menu_nome"; $rs=$db->execute($sql); ?> movenext(); } //-------------------------------------------------------------------------------------------------- ?>
Fields("menu_ctgr_descricao"),0,30).((strlen($rsMenu->Fields("menu_ctgr_descricao"))>30)?"...":"");?>
EOF) { ?> MoveNext(); } ?>
Fields("pgna_endereco")?>" class="link_menu" target="_self" title="Fields("MENU_DESCRICAO")?>">Fields("menu_nome")?>