i am using the examples from chapter 10 of the the wrox book: Professional ASP 3.0.
the examples relate to using RDS but i can not get the data to display in the HTML
page. the following are the code i am using. note that i have changed the params to
reflect my SQL database. Could the problem be some configurtaion i need to set on
the server?. Thanks in advance.
CODE:
<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
ID="dsoData" HEIGHT="1" WIDTH="1">
<PARAM NAME="Connect" VALUE="DSN=pubs;uid=sa;pwd=">
<PARAM NAME="Server" VALUE="http://localhost">
<PARAM NAME="SQL" VALUE="select * from authors">
</OBJECT>
<TABLE ID="tblData" DATASRC="#dsoData">
<THEAD>
<TR>
<TD>au_id</TD>
<TD>au_fname</TD>
<TD>au_lname</TD>
<TD>phone</TD>
<TD>address</TD>
<TD>city</TD>
<TD>state</TD>
<TD>zip</TD>
<TD>contract</TD>
</TR>
</THEAD>
<TBODY>
<TR>
<TD><INPUT TYPE="TEXT" DATAFLD="au_id"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="au_fname"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="au_lname"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="phone"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="address"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="city"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="state"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="zip"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="contract"></INPUT></TD>
</TR>
</TBODY>
</TABLE>What operating system are you running?
-----Original Message-----
From: wissamak@h... [mailto:wissamak@h...]
Sent: Wednesday, November 14, 2001 3:17 AM
To: ASP_ADO_RDS
Subject: [asp_ado_rds] RDS returning empty table
i am using the examples from chapter 10 of the the wrox book: Professional
ASP 3.0.
the examples relate to using RDS but i can not get the data to display in
the HTML
page. the following are the code i am using. note that i have changed the
params to
reflect my SQL database. Could the problem be some configurtaion i need to
set on
the server?. Thanks in advance.
CODE:
<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
ID="dsoData" HEIGHT="1" WIDTH="1">
<PARAM NAME="Connect" VALUE="DSN=pubs;uid=sa;pwd=">
<PARAM NAME="Server" VALUE="http://localhost">
<PARAM NAME="SQL" VALUE="select * from authors">
</OBJECT>
<TABLE ID="tblData" DATASRC="#dsoData">
<THEAD>
<TR>
<TD>au_id</TD>
<TD>au_fname</TD>
<TD>au_lname</TD>
<TD>phone</TD>
<TD>address</TD>
<TD>city</TD>
<TD>state</TD>
<TD>zip</TD>
<TD>contract</TD>
</TR>
</THEAD>
<TBODY>
<TR>
<TD><INPUT TYPE="TEXT" DATAFLD="au_id"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="au_fname"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="au_lname"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="phone"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="address"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="city"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="state"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="zip"></INPUT></TD>
<TD><INPUT TYPE="TEXT" DATAFLD="contract"></INPUT></TD>
</TR>
</TBODY>
</TABLE>
View Cart
