client side html dynamic table creation

I want to display and update records from a SQL query through an html
table in IE, all without a server. I'm using a 'simple' MSI database
with 1 table and 5 int and 1 char columns So far, I only see a need to
use SELECT and UPDATE. The database will hold no more than 1,000
records, and wouldn't allow new records to be created (only existing
records can be changed).

The db connection in the HTA page is specified as:
Dim Installer
Set Installer = CreateObject("WindowsInstaller.Installer")
Dim Database
Set Database = Installer.OpenDatabase("bldgcondrpt.msi", 1)

My query returns all records with matching values in one of the columns
and now I would like to present the results in an html table, where 4
of the columns would allow changing field values.

My initial thought was to use an array-based html table, and UPDATE
appropriate records but I've found nothing that doesn't involve either
ASP, PHP, CGI, etc.

Having spent most of the week researching this, I'm beginning to wonder
if it's even possible now. I got the idea to use MSI from this website:
www.jsware.net.

1. Is it possible to dynamically generate an html table from a
query/array, client side?
2. If #1 is possible, can changes be made to resulting fields and the
db updated with the changes?

Thanks in advance and looking forward to thoughts on this idea.

.

Relevant Pages

  • Re: [FAQ] addslashes() and striplashes()
    ... How do I use addslashes() and stripslashes() when dealing with HTML ... Use addslasheswhen INSERTing or UPDATEing data into the database. ...
    (comp.lang.php)
  • Re: Virtual SBS server
    ... I have been posting in HTML since I became an MVP for SBS 5 years ago. ... With regard to Outlook over HTTP, it might be a bit faster since you don't have the VPN overhead to contend with. ... >>Depending on the database VPN may work, ... >desktop so making the server do all the work would be ...
    (microsoft.public.backoffice.smallbiz)
  • Re: following radio & hidden does not work..... help please.
    ... So you query the database for records and present the concatenated fname and lname for the user to choose from. ... This works the same with a radio button or a select statement. ... This is a HTML or PHP question! ...
    (alt.html)
  • Re: Photographs in British Naturism
    ... source code file, html, jsp, php or what ever), the only factor is ... not to the server if it's serving a html file, ... Currently, it's programmed to generate HTML pages from the text which operators have typed into the database through the admin interface. ...
    (uk.rec.naturist)
  • Re: GridView
    ... Dim cmd As New CommandField ... I tried to enter html text into the database table but that only ... I'm using a GridView to list data from a table in my database. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading