Hi I am very new to DHTML. 2 days to be exact. I hopefully have a simple issue to resolve. I am trying to connect to a MySql database using DHTML and the Microsoft RDS DSO. I want to use Data Bound Objects on my page to display data and I can't figure out why this isn't working. The code that I have so far is below. I'm not getting an error when the page loads. I just don't get any data.
<Html>
<Body>
<TABLE DATASRC=#dsoComposer>
<TR>
<TD><DIV DATAFLD=FieldName></DIV></TD>
</TR>
</TABLE>
<OBJECT classid="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
ID=dsoComposer HEIGHT=0 WIDTH=0>
<PARAM NAME="Server" VALUE="localhost">
<PARAM NAME="Connect" VALUE="dsn=dbName;uid=User;pwd=Pass">
<PARAM NAME="SQL" VALUE="select Field from Table">
</OBJECT>
<SCRIPT>
function window.onload()
{
dsoComposer.open;
}
</SCRIPT>
</Body>
</Html>
<Html>
<Body>
<TABLE DATASRC=#dsoComposer>
<TR>
<TD><DIV DATAFLD=FieldName></DIV></TD>
</TR>
</TABLE>
<OBJECT classid="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
ID=dsoComposer HEIGHT=0 WIDTH=0>
<PARAM NAME="Server" VALUE="localhost">
<PARAM NAME="Connect" VALUE="dsn=dbName;uid=User;pwd=Pass">
<PARAM NAME="SQL" VALUE="select Field from Table">
</OBJECT>
<SCRIPT>
function window.onload()
{
dsoComposer.open;
}
</SCRIPT>
</Body>
</Html>