Ask a Question related to ASP Database, Design and Development.
-
Regan #1
Client side recordset with RDS
This is my first exposure to RDS Client side recordsets.
I have a wrox professional Active Server Page book that is
my bible. But i cannot get Asp page to show any data.
The page is below.. It does not return an error, just an
empty row..
After searching the web, I have read posts from people
with similar problems. I have concluded that it is "OLD"
techology and I should be using XML recordset streaming.
Is this correct? My operating system client side is
Win2000 Professional. web Server is running iis4.0
The Ultimate goal of this project is to be able to return
a SQL from web server to HTML, then give the client the
option on exporting this to Excel. Hence the reason of
the client side recordset. (note xl 2000)
I though about using server side record, returing HTML to
the client, then "Screen Scraping" this to create an XL
sheet. (but this is not really that elegant is it).
Note this is for an intranet app, so i can be sure the
client software (ie xl) is in place
Any help appreciated...... Thanks
<html>
<head>
<title>BoundTable.asp</title>
</head>
<object CLASSID="clsid:BD96C556-65A3-11D0-983A-
00C04FC29E33" ID="objDC"
HEIGHT="0" WIDTH="0">
<param name="Connect"
value="Provider=Microsoft.Jet.OLEDB.4.0;Persist Security
Info=False;Data Source=D:\database.MDB">
<param name="Server" value="http://<%
=Request.ServerVariables("Server_Name")%>">
<param name="SQL" value="SELECT * FROM Contact">
</object>
<body bgcolor="#F0E68C">
<hr>
<!---------------------------------------------------------
------------------>
<p align="center"><font size="4"><b>CONTACTS</b></font></p>
<hr>
<!---------------------------------------------------------
------------------>
<TABLE ID="tblData" BORDER="1" DATASRC="#objDC">
<THEAD>
<TR>
<TD><FONT SIZE="4"><B>Contact</B></FONT></TD>
</TR>
</THEAD>
<TBODY>
<TR>
<TD><SPAN DATAFLD="contact_ID"></SPAN></TD>
</TR>
</TBODY>
</TABLE>
</body>
</html>
Regan Guest
-
flashcom: client side cant access server side
hi all, i hav install the flash com on the PC. It work well, on the server PC, i can access and log in to the 'chat room'.. however, if im... -
Controls with a client side onLoad function or seting a cursor server side
Is there any way to create a web control that calls a client side onLoad function? Its diffucilt since you are not able to access the form or... -
Client side and server side scripting problem
Hiya I have a problem with using some client side and server side scripting together in an ASP. I'm using VBScript. What I'm trying to achieve... -
server-side ASP w/ client -side component
Hello good folks! I need your advice on a project that i am working on. I am integrating a signature pad, a client-side web browser, and my... -
button evet ---- server side - client side ???
I want to use button. My question is that How can use server side and client site event at the same time. That is: I want to use button : when... -
Bob Barrows #2 Re: Client side recordset with RDS
Yes. RDS is old technology, which was problematic to use from the get-go.
Here is a demo of a technique that uses XML to get a recordset to your
client:
[url]http://www.davidpenton.com/testsite/tips/xml.recordset.server2client.asp[/url]
The advantage of this technique is you don't really need to know anything
about XML to use it. The disadvantange is that client machines have been
known to have damaged installations of MDAC (ADO) so it is worthwhile
learning how to use the MS XML Parser in your client code.
Here is another way to get data to your client:
[url]http://www.davidpenton.com/testsite/tips/xml.data.islands.asp[/url]
You should investigate using the XMLHTTP object to interact with a
server-side page to get data without submitting a form. An example of this
is here:
[url]http://www.thrasherwebdesign.com/index.asp?pi=links&hp=links.asp[/url]
Scroll down to the dynamic listbox example.
In the future, please direct client-side coding question which have nothing
to do with asp (server-side) to an appropriate newsgroup such as
m.p.scripting.* or any group with DHTML in its name.
HTH,
Bob Barrows
Regan wrote:> This is my first exposure to RDS Client side recordsets.
> I have a wrox professional Active Server Page book that is
> my bible. But i cannot get Asp page to show any data.
> The page is below.. It does not return an error, just an
> empty row..
>
> After searching the web, I have read posts from people
> with similar problems. I have concluded that it is "OLD"
> techology and I should be using XML recordset streaming.
> Is this correct? My operating system client side is
> Win2000 Professional. web Server is running iis4.0
>
> The Ultimate goal of this project is to be able to return
> a SQL from web server to HTML, then give the client the
> option on exporting this to Excel. Hence the reason of
> the client side recordset. (note xl 2000)
>
> I though about using server side record, returing HTML to
> the client, then "Screen Scraping" this to create an XL
> sheet. (but this is not really that elegant is it).
>
> Note this is for an intranet app, so i can be sure the
> client software (ie xl) is in place
>
>
> Any help appreciated...... Thanks
>
>
>
> <html>
> <head>
> <title>BoundTable.asp</title>
> </head>
>
> <object CLASSID="clsid:BD96C556-65A3-11D0-983A-
> 00C04FC29E33" ID="objDC"
> HEIGHT="0" WIDTH="0">
> <param name="Connect"
> value="Provider=Microsoft.Jet.OLEDB.4.0;Persist Security
> Info=False;Data Source=D:\database.MDB">
> <param name="Server" value="http://<%
> =Request.ServerVariables("Server_Name")%>">
> <param name="SQL" value="SELECT * FROM Contact">
> </object>
>
> <body bgcolor="#F0E68C">
> <hr>
> <!---------------------------------------------------------
> ------------------>
> <p align="center"><font size="4"><b>CONTACTS</b></font></p>
>
> <hr>
> <!---------------------------------------------------------
> ------------------>
>
> <TABLE ID="tblData" BORDER="1" DATASRC="#objDC">
> <THEAD>
> <TR>
> <TD><FONT SIZE="4"><B>Contact</B></FONT></TD>
> </TR>
> </THEAD>
> <TBODY>
> <TR>
> <TD><SPAN DATAFLD="contact_ID"></SPAN></TD>
>
> </TR>
> </TBODY>
> </TABLE>
> </body>
> </html>
Bob Barrows Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
