Example #1
0
<!-- Header table -->
<TABLE BORDER="0" WIDTH="800" CELLPADDING="0" CELLSPACING="0">
<TR><TD WIDTH="3">&nbsp;</TD><TD WIDTH="597">
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="100%"><TR>
  <TD><P CLASS="title">Ad Hoc Menu (<?php 
echo $nextMenu;
?>
 / <?php 
echo pdoRowCount($adHocStmt);
?>
)</P></TD>
<?php 
if (cMultipleSites) {
    $sqlSites = "SELECT site_num, site_name FROM sites";
    $adHocSitesStmt = pdoQuery($sqlSites, $connAdHoc);
    $adHocSitesRows = pdoFetch($adHocSitesStmt);
    ?>
<TD>
<FORM ACTION="adHocMenu.php" METHOD="post">
<SELECT NAME="sitenum" SIZE="1" ONCHANGE="this.form.submit();">
<?php 
    foreach ($adHocSitesRows as $row) {
        if ($siteNum == pdoData($row, "site_num")) {
            $sel = "SELECTED";
        } else {
            $sel = "";
        }
        ?>
<OPTION <?php 
        echo $sel;
        ?>
Example #2
0
} else {
    traceHide("query has no parameters");
}
//===================================================================================
//This section runs the constructed detail query
//Different handling for stored procedures and conventional SQL
if ($isStoredProcedure) {
    //**FIX**
    // $aCmd is of type "ADODB.Command"
    //$aCmd_ActiveConnection=;
    //$aCmd_CommandText=$detailSelect;
    //$aCmd_CommandType=$adCmdText;
    //$row=  $aCmd_Execute=);;
} else {
    $udbStmt = pdoQuery($detailSelect, $conn_udb);
    $udbRows = pdoFetch($udbStmt);
}
$numRecords = pdoRowCount($udbStmt);
//===================================================================================
// Home and Back buttons
?>
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="100%"><TR><TD ALIGN="right">
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0"><TR>
  <TD>
    <P CLASS="navBar">
    &nbsp;&nbsp;&nbsp;&nbsp;
    <A HREF="javascript:history.back()">Back</A>
    &nbsp;&nbsp;&middot;&nbsp;&nbsp;
    <A HREF="adHocMenu.php">Ad Hoc Home</A>
    &nbsp;&nbsp;&nbsp;&nbsp;
    </P>
Example #3
0
function loadLinks($dbAdHoc)
{
    $sql = "SELECT q.link_field, m.menu_num, m.line_num FROM queries q" . " JOIN menus m ON q.query_num = m.main_query_num";
    $stmt = pdoQuery($sql, $dbAdHoc);
    return pdoFetch($stmt);
}
Example #4
0
    pdoQuery($sql, $connAdHoc);
}
if (isset($_REQUEST['addm'])) {
    $sql = "call sp_addmenu(" . $MenuNum . ")";
    pdoQuery($sql, $connAdHoc);
}
if (isset($_REQUEST['addq'])) {
    $sql = "call sp_addquery(" . $nextMenu . ")";
    pdoQuery($sql, $connAdHoc);
}
// end of updates
/////////////////
$sql = "call sp_getmenu(" . $nextMenu . ")";
pdoQuery($sql, $connAdHoc);
$adHocStmt = pdoQuery($sql, $connAdHoc);
$adHocRows = pdoFetch($adHocStmt);
?>
<HTML>
<HEAD>
<?php 
echo cHeaderComment;
?>
<TITLE>Ad Hoc Admin</TITLE>
<LINK REL="stylesheet" HREF=<?php 
echo cStylesheet;
?>
 TYPE="text/css" />
</HEAD>
<BODY BGCOLOR="#000000">
<!-- Header table -->
<TABLE BORDER="0" WIDTH="800" CELLPADDING="0" CELLSPACING="0">
Example #5
0
</span>
</CENTER>
<BR>
</TABLE>
<br />
<FORM ACTION="adHocAdminEditMenu.php" METHOD=POST>
<TABLE>
<TR>
<TD>
Parent Menu:<BR>
</TD>
<TD>
<?php 
$sql = "call sp_menusfordropdown();";
$stmt = pdoQuery($sql, $connAdHoc);
$rows = pdoFetch($stmt);
?>
  <SELECT NAME="parent_menu" SIZE="1">
  <OPTION VALUE="1">Top Level</OPTION>
<?php 
foreach ($rows as $row) {
    if ($curMenu == pdoData($row, "sub_menu_num")) {
        $sel = "SELECTED";
    } else {
        $sel = "";
    }
    ?>
 <OPTION <?php 
    echo $sel;
    ?>
 VALUE="<?php