function dblookup()
{
	adOpenForwardOnly = 0;
adLockReadOnly = 1;
adCmdText = 1;

var myConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\Sergio\\apps\\braunco\\db\\braunco.mdb"; 

    var ConnectObj = Server.CreateObject("ADODB.Connection");
    var RS = Server.CreateObject("ADODB.Recordset");
    var sql="SELECT * FROM tbl_main_menu;";

    ConnectObj.Open (myConnect);
    RS.Open(sql,ConnectObj,adOpenForwardOnly,adLockReadOnly,adCmdText);

    var fieldCount = RS.Fields.Count;
	alert(fieldCount);
    Response.Write ("Field Count" + fieldCount);
    RS.Close();
    ConnectObj.Close();
}
function mmLoadMenus() {
   window.mm_menu_0511221144_5 = new Menu("Premiere Estates Auctions",290,20,"Verdana, Arial, Helvetica, sans-serif",11,"#FFFFFF","#FFFFFF","#6699CC","#FF9900","left","middle",0,0,750,-15,57,true,true,true,2,true,false);
   mm_menu_0511221144_5.addMenuItem("Premiere Estates Auctions","window.open('http://www.premiereestates.com/auctions.php','','width=1000,height=900,location=no,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,left=0,top=0')");

   mm_menu_0511221144_5.fontWeight="bold";
   mm_menu_0511221144_5.hideOnMouseOut=true;
   mm_menu_0511221144_5.bgColor='#FFFFFF';
   mm_menu_0511221144_5.menuBorder=0;
   mm_menu_0511221144_5.menuLiteBgColor='#FFFFFF';
   mm_menu_0511221144_5.menuBorderBgColor='#FFFFFF';
	
  window.mm_menu_0511221144_4 = new Menu("Current Listings",290,20,"Verdana, Arial, Helvetica, sans-serif",11,"#FFFFFF","#FFFFFF","#6699CC","#FF9900","left","middle",0,0,750,-5,7,true,true,true,2,true,false);
 // mm_menu_0511221144_0.addMenuItem("Auctions\Sales","location='?page_id=22'");

//This is the real estate stuff
  mm_menu_0511221144_4.addMenuItem("None at this time","location='#'");
//  mm_menu_0511221144_4.addMenuItem("20300 Bear Creek Santa Cruz", "location='home.asp?page_id=62'");
//  mm_menu_0511221144_4.addMenuItem("20288 Bear Creek Santa Cruz","location='home.asp?page_id=66'");
//  mm_menu_0511221144_4.addMenuItem("Hillsborough, CA - Sealed Bid Auction","location='home.asp?page_id=65'");
//  mm_menu_0511221144_4.addMenuItem("Marysville, CA. - Court Ordered Sale","location='home.asp?page_id=63'");
//  mm_menu_0511221144_4.addMenuItem("Covina, CA - 1009 SB Rd Covina","location='home.asp?page_id=64'");


   mm_menu_0511221144_4.fontWeight="bold";
   mm_menu_0511221144_4.hideOnMouseOut=true;
   mm_menu_0511221144_4.bgColor='#FFFFFF';
   mm_menu_0511221144_4.menuBorder=0;
   mm_menu_0511221144_4.menuLiteBgColor='#FFFFFF';
   mm_menu_0511221144_4.menuBorderBgColor='#FFFFFF';


   window.mm_menu_0511221144_3 = new Menu("Current Auctions",290,20,"Verdana, Arial, Helvetica, sans-serif",11,"#FFFFFF","#FFFFFF","#6699CC","#FF9900","left","middle",0,0,750,-15,57,true,true,true,2,true,false);
   	mm_menu_0511221144_3.addMenuItem("Former Ramada Inn Hotel Freeport Illinois","location='home.asp?page_id=83'");
   	mm_menu_0511221144_3.addMenuItem("Howard Johnson – Florence SC","location='home.asp?page_id=81'");
   	mm_menu_0511221144_3.addMenuItem("Baymont Inn & Suites Macon- GA","location='home.asp?page_id=89'");
	mm_menu_0511221144_3.addMenuItem("John Boyd Design Auction","location='home.asp?page_id=88'");
   	mm_menu_0511221144_3.addMenuItem("Half Moon Bay - Commercial Land","location='home.asp?page_id=84'");   
	mm_menu_0511221144_3.addMenuItem(" Watsonville - Commercial/Residential","location='home.asp?page_id=82'");
//   mm_menu_0511221144_3.addMenuItem("Kirkland Winery Auction","location='home.asp?page_id=85'");   
//   mm_menu_0511221144_3.addMenuItem("Wholesale Lighting Liquidation","location='home.asp?page_id=86'");   
   	mm_menu_0511221144_3.addMenuItem("Industrial Building, Boston MA","location='home.asp?page_id=87'");     
   


//   mm_menu_0511221144_3.addMenuItem("Lender Builder Auction","location='home.asp?page_id=82'");   
//   mm_menu_0511221144_3.addMenuItem("Fresno Industrial Building - Sealed Bid","location='home.asp?page_id=89'");   

//   mm_menu_0511221144_3.addMenuItem("Colton Motel - In Escrow","location='home.asp?page_id=81'");
   /*mm_menu_0511221144_3.addMenuItem("San Bernardino Shopping Ctr.","location='home.asp?page_id=82'");
   mm_menu_0511221144_3.addMenuItem("Pomona Commercial Land","location='home.asp?page_id=83'");
   mm_menu_0511221144_3.addMenuItem("Covina Shopping Ctr.","location='home.asp?page_id=84'");*/
   //mm_menu_0511221144_3.addMenuItem("Long Beach Office Building - In Escrow","location='home.asp?page_id=85'");  
   //mm_menu_0511221144_3.addMenuItem("New Mexico Motel","location='home.asp?page_id=86'");  
   //mm_menu_0511221144_3.addMenuItem("2 Huntington Beach Homes","location='home.asp?page_id=87'");  

   mm_menu_0511221144_3.fontWeight="bold";
   mm_menu_0511221144_3.hideOnMouseOut=true;
   mm_menu_0511221144_3.bgColor='#FFFFFF';
   mm_menu_0511221144_3.menuBorder=0;
   mm_menu_0511221144_3.menuLiteBgColor='#FFFFFF';
   mm_menu_0511221144_3.menuBorderBgColor='#FFFFFF';

window.mm_menu_0511221144_2 = new Menu("Auctions & Listings",150,20,"Verdana, Arial, Helvetica, sans-serif",11,"#FFFFFF","#FFFFFF","#6699CC","#FF9900","left","middle",0,0,750,-5,7,true,true,true,2,true,false);
   mm_menu_0511221144_2.addMenuItem(mm_menu_0511221144_3);
   mm_menu_0511221144_2.addMenuItem(mm_menu_0511221144_4);
   mm_menu_0511221144_2.fontWeight="bold";
   mm_menu_0511221144_2.hideOnMouseOut=true;
   mm_menu_0511221144_2.childMenuIcon="images/arrows.gif";
   mm_menu_0511221144_2.bgColor='#FFFFFF';
   mm_menu_0511221144_2.menuBorder=0;
   mm_menu_0511221144_2.menuLiteBgColor='#FFFFFF';
   mm_menu_0511221144_2.menuBorderBgColor='#FFFFFF';
   
      
   window.mm_menu_0511221144_1 = new Menu("Documents",300,20,"Verdana, Arial, Helvetica, sans-serif",11,"#FFFFFF","#FFFFFF","#6699CC","#FF9900","left","middle",0,0,750,-5,7,true,true,true,2,true,false);
  mm_menu_0511221144_1.addMenuItem("Absentee Sealed Bid Form","window.open('pdf/docs/Absentee_Sealed_Bid_Form.pdf','','width=620,height=475,location=no,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,left=0,top=0')");
//  mm_menu_0511221144_1.addMenuItem("Account Wire Instruction","window.open('pdf/docs/Account_Wiring_Instructions.pdf','','width=620,height=475,location=no,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,left=0,top=0')");
  mm_menu_0511221144_1.addMenuItem("Agent Release Authorization","window.open('pdf/docs/Agent_Release_Shipping_Form.pdf','','width=620,height=475,location=no,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,left=0,top=0')");
  mm_menu_0511221144_1.addMenuItem("Bank Letter Of Guarantee","window.open('pdf/docs/Bank_Ltr_of_Guarantee_form.pdf','','width=620,height=475,location=no,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,left=0,top=0')");
  mm_menu_0511221144_1.addMenuItem("Procedure Equipment Disconnect  & Removal","window.open('pdf/docs/Equip_Disconnect_&_Removal.pdf','','width=620,height=475,location=no,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,left=0,top=0')");
  mm_menu_0511221144_1.addMenuItem("Sales Tax Exemption Form","window.open('pdf/docs/Sales_Tax_Resale-Exempt.pdf','','width=620,height=475,location=no,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,left=0,top=0')");
//  mm_menu_0511221144_1.addMenuItem("Terms Of Auction Sale of Personal Property","window.open('pdf/docs/Terms_of_Auction_Sale_Personal_Prop.pdf','','width=620,height=475,location=no,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,left=0,top=0')");
//  mm_menu_0511221144_1.addMenuItem("Wire Transfer Instructions","window.open('pdf/docs/Account_Wiring_Instructions.pdf','','width=620,height=475,location=no,toolbar=no,menubar=no,scrollbars=yes,resizable=yes,left=0,top=0')");
  
  //mm_menu_0511221144_0.addMenuItem("Code of Ethics","location='http://www.braunco.com'");
   mm_menu_0511221144_1.fontWeight="bold";
   mm_menu_0511221144_1.hideOnMouseOut=true;
  // mm_menu_0511221144_1.childMenuIcon="/images/arrows.gif";
   mm_menu_0511221144_1.bgColor='#FFFFFF';
   mm_menu_0511221144_1.menuBorder=0;
   mm_menu_0511221144_1.menuLiteBgColor='#FFFFFF';
   mm_menu_0511221144_1.menuBorderBgColor='#FFFFFF';
   
   window.mm_menu_0511221144_0 = new Menu("root",190,20,"Verdana, Arial, Helvetica, sans-serif",11,"#FFFFFF","#FFFFFF","#6699CC","#FF9900","left","middle",0,0,750,-5,7,true,true,true,2,true,false);
//   mm_menu_0511221144_0.addMenuItem(mm_menu_0511221144_2);
//  this was the top menu for auctions and listings.
	mm_menu_0511221144_0.addMenuItem(mm_menu_0511221144_3);
  mm_menu_0511221144_0.addMenuItem(mm_menu_0511221144_4);
//  mm_menu_0511221144_0.addMenuItem("Past Auctions & Listings","location='?page_id=21'");
   mm_menu_0511221144_0.addMenuItem(mm_menu_0511221144_1);
   mm_menu_0511221144_0.addMenuItem(mm_menu_0511221144_5);
   
  //mm_menu_0511221144_0.addMenuItem("Code of Ethics","location='http://www.braunco.com'");
   mm_menu_0511221144_0.fontWeight="bold";
   mm_menu_0511221144_0.hideOnMouseOut=true;
   mm_menu_0511221144_0.childMenuIcon="images/arrows.gif";
   mm_menu_0511221144_0.bgColor='#FFFFFF';
   mm_menu_0511221144_0.menuBorder=0;
   mm_menu_0511221144_0.menuLiteBgColor='#FFFFFF';
   mm_menu_0511221144_0.menuBorderBgColor='#FFFFFF';


/*   window.mm_menu_0222_1 = new Menu("root2",170,20,"Verdana, Arial, Helvetica, sans-serif",11,"#FFFFFF","#FFFFFF","#6699CC","#FF9900","left","middle",0,0,750,-5,7,true,true,true,2,true,false);
//   mm_menu_0511221144_0.addMenuItem(mm_menu_0511221144_2);
//  this was the top menu for auctions and listings.
//	mm_menu_0222_1.addMenuItem(mm_menu_0511221144_3);
//  mm_menu_0222_1.addMenuItem(mm_menu_0511221144_4);
  //mm_menu_0222_1.addMenuItem("Past Auctions & Listings","location='home.asp?page_id=21'");
//   mm_menu_0222_1.addMenuItem(mm_menu_0511221144_1);
  //mm_menu_0511221144_0.addMenuItem("Code of Ethics","location='http://www.braunco.com'");
   mm_menu_0222_1.fontWeight="bold";
   mm_menu_0222_1.hideOnMouseOut=true;
   mm_menu_0222_1.childMenuIcon="images/arrows.gif";
   mm_menu_0222_1.bgColor='#FFFFFF';
   mm_menu_0222_1.menuBorder=0;
   mm_menu_0222_1.menuLiteBgColor='#FFFFFF';
   mm_menu_0222_1.menuBorderBgColor='#FFFFFF';
*/
//mm_menu_0222_1.writeMenus();
mm_menu_0511221144_0.writeMenus();


dblookup();
//mm_menu_0511221144_1.writeMenus();
} // mmLoadMenus()  

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}