I have the following problem.I have created a database using mysql server which has only one table named "syskeyi" in a schema named "fanis".My question is what should i change in the snippet code I send you to retrieve these data??
I would appreciate it if you answer me soon or tell where to refer for my problem.Thank you very much!
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
>
<html>
<head>
<title></title>
<meta name="GENERATOR"
content="Microsoft Visual Studio .NET 7.1"
>
<meta name="vs_targetSchema"
content="http:/
/schemas.microsoft.com/intellisense/ie5">
<script id="clientEventHandlersJS"
language="javascript"
>
<!--
function
Button1_onclick() {
var
locator = new
ActiveXObject ("WbemScripting.SWbemLocator"
);
var
service = locator.ConnectServer("."
,"rootMicrosoftSQLServer"
);
var
properties = service.ExecQuery("SELECT * FROM MSSQL_UserDefinedFunction WHERE databasename='Northwind'"
);
var
e = new
Enumerator (properties);
document.write("<table border=1>"
);
dispHeading();
for
(;!e.atEnd();e.moveNext ())
{
var
p = e.item ();
document.write("<tr>"
);
document.write("<td>"
+ p.Name + "</td>"
);
document.write("<td>"
+ p.Text + "</td>"
);
document.write("</tr>"
);
}
document.write("</table>"
);
}
function
dispHeading()
{
document.write("<thead>"
);
document.write("<td>Name</td>"
);
document.write("<td>Text</td>"
);
document.write("</thead>"
);
}
//-->
</script>
</head>
<body>
<INPUT id="Button1"
type="button"
value="Button"
name="Button1"
language="javascript"
onclick="return Button1_onclick()"
>
</body>
</html>
Fanis