EvanL
asked on
Editing data using Tabular Data Control and IE4
I hope someone is familiar with this.. I am using the built-in Tabular Data Control (TDC) in Internet Explorer 4 to display, sort, and filter a recordset of text data.
I can display the data in form fields, but was wondering how to write that data to the source text file.
I would think that I should rewrite the text file, or export the current recordset to a text file of the same name. Not sure which.
Anyone have any clues?
I can display the data in form fields, but was wondering how to write that data to the source text file.
I would think that I should rewrite the text file, or export the current recordset to a text file of the same name. Not sure which.
Anyone have any clues?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Nope, same stuffs as TDC, just set up the object, pass a SQL string to it to retrieve the data, everything else is standard databinding.
I've done a searchable, sortable by different fields company telephone directory (pulling 1000+ records) entirely in RDS.
It worked like a charm.
I've done a searchable, sortable by different fields company telephone directory (pulling 1000+ records) entirely in RDS.
It worked like a charm.
A suggestion, go visit www.microsoft.com/workshop, and take a look at their data binding section further (in HTML, DHTML, CSS)
If you poke around their sample RDS source code, you probably can understand how they are doing it. It helps if you already know how to use ADO.
If you poke around their sample RDS source code, you probably can understand how they are doing it. It helps if you already know how to use ADO.
ASKER
Funny you should mention the telephone directory, because that is what I'm trying to do as well. The problem I really see, is that the database and HTML will reside on a web server not owned by myself (rented). So how can I identify the database in the ODBC applet in Control Panel on the remote server? I guess the servers have to support IIS before I can do this, correct?
I've raised the points for the question. Thanks for your help..
I've raised the points for the question. Thanks for your help..
ASKER
Wanted to see if this made sense to you.. I put a MS Access DB on a webserver. The DB has a table called "Table1" that contains everything I need to read and write to. I then made a web page with the following:
-----------------
<object classid="clsid:BD96C556-65 A3-11D0-98 3A-00C04FC 29E33" ID="mydb" HEIGHT="0" WIDTH="0">
<param name="Server" value="http://www.capu.net/~imagix/test">
<param name="Connect" value="dsn=db1.mdb;uid=;pw d=;">
<param name="SQL" value="select * from Table1">
</object>
<html>
<head>
<title></title>
</head>
<body>
<p><input TYPE="TEXTBOX" DATASRC="#mydb" DATAFLD="TPEWNum"> </p>
</body>
</html>
-------------------------- -------
When I run the webpage, the textbox is not populated with the data. I'm not sure if the server is running the correct software to support RDS (what ever that software might be). And I'm not sure if I have the dsn= correct. I simply put the name of the file to access, with no username and password.
Any ideas? I'd be glad to raise the points again for some help and more info.
Thanks..
-----------------
<object classid="clsid:BD96C556-65
<param name="Server" value="http://www.capu.net/~imagix/test">
<param name="Connect" value="dsn=db1.mdb;uid=;pw
<param name="SQL" value="select * from Table1">
</object>
<html>
<head>
<title></title>
</head>
<body>
<p><input TYPE="TEXTBOX" DATASRC="#mydb" DATAFLD="TPEWNum"> </p>
</body>
</html>
--------------------------
When I run the webpage, the textbox is not populated with the data. I'm not sure if the server is running the correct software to support RDS (what ever that software might be). And I'm not sure if I have the dsn= correct. I simply put the name of the file to access, with no username and password.
Any ideas? I'd be glad to raise the points again for some help and more info.
Thanks..
ASKER
Comments?