|
 |
asp_ado_rds thread: what's wrong with my RDS?
Message #1 by "adam" <riverdu@s...> on Wed, 28 Feb 2001 12:47:00
|
|
hi:
now i am read <<Professional Active Server Pages 3.0>> and i have
download the code from www.wrox.com. But when i run the program of chapter
10, some error happen! RDS Doesn't Load Records
my code:
-------------------------
<HTML>
<HEAD>
<TITLE>RDSTableBinding.asp</TITLE>
<STYLE TYPE="text/css">
BODY {font-family:Tahoma,Arial,sans-serif; font-size:10pt}
.heading {font-family:Tahoma,Arial,sans-serif; font-size:14pt; font-
weight:bold}
.cite {font-family:Tahoma,Arial,sans-serif; font-size:8pt}
</STYLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<SPAN CLASS="heading">Table Data Binding with RDS</SPAN><HR>
<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
ID="dsoData" HEIGHT="0" WIDHTH="0">
<PARAM NAME="Connect" VALUE="driver={Oracle odbc
driver};server=wtbwww;uid=scott;pwd=tiger;DBQ=orawww">
<PARAM NAME="Server" VALUE="http://10.88.8.247">
<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>
</BODY>
</HTML>
-----------------------------
Thanks !
adam
Message #2 by "dan robinson" <the_cowman@h...> on Wed, 28 Feb 2001 15:10:00
|
|
it probably doesn't matter, but if this is your exact code...You have mis-
spelled the word "width" in your object declaration. And you should also
specify a non-zero number (i.e:1) for your height and width.
dan
> hi:
> now i am read <<Professional Active Server Pages 3.0>> and i have
> download the code from www.wrox.com. But when i run the program of
chapter
> 10, some error happen! RDS Doesn't Load Records
> my code:
>
>
> -------------------------
> <HTML>
> <HEAD>
> <TITLE>RDSTableBinding.asp</TITLE>
> <STYLE TYPE="text/css">
> BODY {font-family:Tahoma,Arial,sans-serif; font-size:10pt}
> .heading {font-family:Tahoma,Arial,sans-serif; font-size:14pt; font-
> weight:bold}
> .cite {font-family:Tahoma,Arial,sans-serif; font-size:8pt}
> </STYLE>
> </HEAD>
> <BODY BGCOLOR="#FFFFFF">
> <SPAN CLASS="heading">Table Data Binding with RDS</SPAN><HR>
>
> <OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
> ID="dsoData" HEIGHT="0" WIDHTH="0">
> <PARAM NAME="Connect" VALUE="driver={Oracle odbc
> driver};server=wtbwww;uid=scott;pwd=tiger;DBQ=orawww">
> <PARAM NAME="Server" VALUE="http://10.88.8.247">
> <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>
> </BODY>
> </HTML>
> -----------------------------
> Thanks !
|
|
|
View Cart
