[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Editing data using Tabular Data Control and IE4

Posted on 1999-01-19
6
Medium Priority
?
212 Views
Last Modified: 2010-04-09
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?  
0
Comment
Question by:EvanL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 6

Accepted Solution

by:
PBall earned 220 total points
ID: 1845457
TDC is read-only.  You can't add data to the source by using TDC.  In order to modify the data, you'll need server side scripting like ASP.

Or you might want to try the alternative and more powerful solution to TDC, RDS (Remote Data Services).

RDS will allow you to have your data in say.. Access mdb or SQL Server, and yes, you can update data directly from within IE4 using just the databinding.


see: http://www.microsoft.com/data/ado/adords15/


0
 
LVL 1

Author Comment

by:EvanL
ID: 1845458
One problem I see, is that the web server must be running RDS before I can make apps work.  The good thing about the TDC, is that it works anywhere on any server.  Also, it looks a lot more difficult to set up a simple page that displays data and lets the user edit it.

Comments?


0
 
LVL 6

Expert Comment

by:PBall
ID: 1845459
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.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 6

Expert Comment

by:PBall
ID: 1845460
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.
0
 
LVL 1

Author Comment

by:EvanL
ID: 1845461
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..
0
 
LVL 1

Author Comment

by:EvanL
ID: 1845462
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-65A3-11D0-983A-00C04FC29E33" ID="mydb" HEIGHT="0" WIDTH="0">
  <param name="Server" value="http://www.capu.net/~imagix/test">
  <param name="Connect" value="dsn=db1.mdb;uid=;pwd=;">
  <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..
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a PowerShell web interface I use to manage some task as a network administrator. Clicking an action button on the left frame will display a form in the middle frame to input some data in textboxes, process this data in PowerShell and display…
This article discusses four methods for overlaying images in a container on a web page
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question