Hvordan henter man database over i dreamweaver, så det virker
Jeg har e lille dumt problem, her er det så...:<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/Faaborg_Tennis_K.asp" -->
<%
Dim Tennis_klubben
Dim Tennis_klubben_numRows
Set Tennis_klubben = Server.CreateObject("ADODB.Recordset")
Tennis_klubben.ActiveConnection = MM_Faaborg_Tennis_K_STRING
Tennis_klubben.Source = "SELECT * FROM FTKdatabase ORDER BY ftkID DESC"
Tennis_klubben.CursorType = 0
Tennis_klubben.CursorLocation = 2
Tennis_klubben.LockType = 1
Tennis_klubben.Open()
Tennis_klubben_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<!-- TemplateBeginEditable name="doctitle" -->
<title>Faaborg Tennisklub</title>
<!-- TemplateEndEditable --><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
background-image: url(img/baggrund.jpg);
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
color: #ECE9D8;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function mmLoadMenus() {
if (window.mm_menu_0125131928_0) return;
window.mm_menu_0125131928_0 = new Menu("root",171,18,"sans-serif, serif",12,"#000000","#FFFFFF","#CCCCCC","#0000CC","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0125131928_0.addMenuItem("Om Faaborg Tennisklub","location='Om_faaborg_Tennisklub.asp'");
mm_menu_0125131928_0.addMenuItem("Kontakt Info","location='kontaktinfo.asp'");
mm_menu_0125131928_0.addMenuItem("DAGBOG---TEST","location='login.asp'");
mm_menu_0125131928_0.hideOnMouseOut=true;
mm_menu_0125131928_0.bgColor='#555555';
mm_menu_0125131928_0.menuBorder=1;
mm_menu_0125131928_0.menuLiteBgColor='#FFFFFF';
mm_menu_0125131928_0.menuBorderBgColor='#777777';
window.mm_menu_0125134537_0_1 = new Menu("Trænere",126,18,"sans-serif, serif",12,"#000000","#FFFFFF","#CCCCCC","#0000CC","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0125134537_0_1.addMenuItem("Junior Trænere","location='jun_traner.asp'");
mm_menu_0125134537_0_1.addMenuItem("Voksen Trænere","location='voksen_traner.asp'");
mm_menu_0125134537_0_1.hideOnMouseOut=true;
mm_menu_0125134537_0_1.bgColor='#555555';
mm_menu_0125134537_0_1.menuBorder=1;
mm_menu_0125134537_0_1.menuLiteBgColor='#FFFFFF';
mm_menu_0125134537_0_1.menuBorderBgColor='#777777';
window.mm_menu_0125134537_0 = new Menu("root",75,18,"sans-serif, serif",12,"#000000","#FFFFFF","#CCCCCC","#0000CC","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0125134537_0.addMenuItem(mm_menu_0125134537_0_1,"location='Tranere.asp'");
mm_menu_0125134537_0.addMenuItem("OSV....","location='OSV....asp'");
mm_menu_0125134537_0.hideOnMouseOut=true;
mm_menu_0125134537_0.childMenuIcon="arrows.gif";
mm_menu_0125134537_0.bgColor='#555555';
mm_menu_0125134537_0.menuBorder=1;
mm_menu_0125134537_0.menuLiteBgColor='#FFFFFF';
mm_menu_0125134537_0.menuBorderBgColor='#777777';
window.mm_menu_0125135339_0 = new Menu("root",134,18,"sans-serif, serif",12,"#000000","#FFFFFF","#CCCCCC","#0000CC","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0125135339_0.addMenuItem("Vinter 2004","location='Vinter_2004.asp'");
mm_menu_0125135339_0.addMenuItem("sommer 2004","location='sommer_04.asp'");
mm_menu_0125135339_0.addMenuItem("Mande Aften - 04","location='mande_aften_04.asp'");
mm_menu_0125135339_0.hideOnMouseOut=true;
mm_menu_0125135339_0.bgColor='#555555';
mm_menu_0125135339_0.menuBorder=1;
mm_menu_0125135339_0.menuLiteBgColor='#FFFFFF';
mm_menu_0125135339_0.menuBorderBgColor='#777777';
window.mm_menu_0125140633_0 = new Menu("root",113,18,"sans-serif, serif",12,"#000000","#FFFFFF","#CCCCCC","#0000CC","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0125140633_0.addMenuItem("Medlems Liste","location='medlems_liste.asp'");
mm_menu_0125140633_0.hideOnMouseOut=true;
mm_menu_0125140633_0.bgColor='#555555';
mm_menu_0125140633_0.menuBorder=1;
mm_menu_0125140633_0.menuLiteBgColor='#FFFFFF';
mm_menu_0125140633_0.menuBorderBgColor='#777777';
window.mm_menu_0125140734_0_1 = new Menu("2005",173,18,"sans-serif, serif",12,"#000000","#FFFFFF","#CCCCCC","#0000CC","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0125140734_0_1.addMenuItem("Bane Reservation Online","location='Bane_Reserv_online.asp'");
mm_menu_0125140734_0_1.hideOnMouseOut=true;
mm_menu_0125140734_0_1.bgColor='#555555';
mm_menu_0125140734_0_1.menuBorder=1;
mm_menu_0125140734_0_1.menuLiteBgColor='#FFFFFF';
mm_menu_0125140734_0_1.menuBorderBgColor='#777777';
window.mm_menu_0125140734_0 = new Menu("root",56,18,"sans-serif, serif",12,"#000000","#FFFFFF","#CCCCCC","#0000CC","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_0125140734_0.addMenuItem("2003","location='nyhed_2003.asp'");
mm_menu_0125140734_0.addMenuItem("2004","location='nyhed_2004.asp'");
mm_menu_0125140734_0.addMenuItem(mm_menu_0125140734_0_1,"location='nyhed_2005.asp'");
mm_menu_0125140734_0.hideOnMouseOut=true;
mm_menu_0125140734_0.childMenuIcon="arrows.gif";
mm_menu_0125140734_0.bgColor='#555555';
mm_menu_0125140734_0.menuBorder=1;
mm_menu_0125140734_0.menuLiteBgColor='#FFFFFF';
mm_menu_0125140734_0.menuBorderBgColor='#777777';
mm_menu_0125140734_0.writeMenus();
} // mmLoadMenus()
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
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;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<script language="JavaScript" src="mm_menu.js"></script>
<link href="CSS/styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style2 {font-size: 12px}
.style3 {
font-size: 16px;
color: #5A7973;
}
-->
</style>
<!-- TemplateBeginEditable name="head" --><!-- TemplateEndEditable -->
</head>
<body onLoad="MM_preloadImages('img/Menu_buttons_Om_klubben.gif','img/Menu_buttons_traening.gif','img/Menu_buttons_medlemmer.gif','img/Menu_buttons_Billed.gif','img/Menu_buttons_nyheder.gif')">
<script language="JavaScript1.2">mmLoadMenus();</script>
<table width="722" height="100%" border="0" align="center" cellpadding="1" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="724" height="102" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="102" valign="top"><!-- TemplateBeginEditable name="Top_Banenr" --><img src="img/FT_Banner.jpg" name="Image2" width="722" height="157" id="Image2"><!-- TemplateEndEditable --></td>
</tr>
<tr>
<td><!-- TemplateBeginEditable name="Menu_buttons" --><img src="img/Menu_buttons_venstreborder.gif" width="146" height="17"><a href="#" onMouseOver="MM_swapImage('Image1','','img/Menu_buttons_Om_klubben.gif',1);MM_showMenu(window.mm_menu_0125131928_0,0,17,null,'Image1')" onMouseOut="MM_swapImgRestore();MM_startTimeout();"><img src="img/Menu_buttons_Om_klubben_off.gif" name="Image1" width="84" height="17" border="0" id="Image1"></a><a href="#" onMouseOver="MM_swapImage('Image3','','img/Menu_buttons_traening.gif',1);MM_showMenu(window.mm_menu_0125134537_0,0,17,null,'Image3')" onMouseOut="MM_swapImgRestore();MM_startTimeout();"><img src="img/Menu_buttons_traening_off.gif" name="Image3" width="64" height="17" border="0" id="Image3"></a><a href="#" onMouseOver="MM_swapImage('Image4','','img/Menu_buttons_medlemmer.gif',1);MM_showMenu(window.mm_menu_0125140633_0,0,17,null,'Image4')" onMouseOut="MM_swapImgRestore();MM_startTimeout()"><img src="img/Menu_buttons_medlemmer_off.gif" name="Image4" width="84" height="17" border="0" id="Image4"></a><a href="#" onMouseOver="MM_swapImage('Image5','','img/Menu_buttons_Billed.gif',1);MM_showMenu(window.mm_menu_0125135339_0,0,17,null,'Image5')" onMouseOut="MM_swapImgRestore();MM_startTimeout();"><img src="img/Menu_buttons_Billed_off.gif" name="Image5" width="64" height="17" border="0" id="Image5"></a><a href="#" onMouseOver="MM_swapImage('Image6','','img/Menu_buttons_nyheder.gif',1);MM_showMenu(window.mm_menu_0125140734_0,0,17,null,'Image6')" onMouseOut="MM_swapImgRestore();MM_startTimeout();"><img src="img/Menu_buttons_nyheder_off.gif" name="Image6" width="64" height="17" border="0" id="Image6"></a><img src="img/Menu_buttons_hejreborder.gif" width="216" height="17"><!-- TemplateEndEditable --></td>
</tr>
<tr>
<td><!-- TemplateBeginEditable name="Hoved_menu" -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="116"> </td>
<td><p> </p>
<p align="center" class="style3">Velkommen til denne Dagbog !!!</p>
<table width="500" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td height="25"><div align="center"><%=(Tennis_klubben.Fields.Item("Overskrift").Value)%></div></td>
</tr>
<tr>
<td><div align="center"><%=(Tennis_klubben.Fields.Item("Dato").Value)%></div></td>
</tr>
<tr>
<td><div align="center"><%=(Tennis_klubben.Fields.Item("Fakta").Value)%></div></td>
</tr>
<tr>
<td><div align="center"><%=(Tennis_klubben.Fields.Item("Tekst").Value)%></div></td>
</tr>
</table> <p align="center" class="style3"> </p>
<p align="center"> </p>
<p align="center" class="lilleforsidetekst style2">Faaborg Tennisklub....Stadionvej 45....5600 Faaborg....Tlf.: 62-61-45-34</p>
<p class="style2"> </p>
<p> </p></td>
<td width="80"> </td>
</tr>
</table>
<!-- TemplateEndEditable --></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<%
Tennis_klubben.Close()
Set Tennis_klubben = Nothing
%>
ville kunne bruge "Live Data View" knappen til at kunne se det fra min database....
Det kan jeg også når jeg tester Sql databasen i dreamweaver....
Men når jeg trykker på knappen, så sker der ingen ting, der kommer sådan en dum lille extra menu under kode halvdelen...
Jeg har hentet "records" ind i tablen, så jeg ved ikke rigtig hvad der kan være galt