Re: bind HTML table to ADO persisted recordset client-side

Mark,

Thanks. After looking into RDS, this is approximately what I have ...

<html><head><title>test</title>
<script language="VBScript">
const cn = "Provider=MSPersist"
const df = "full path to datafile.adtg"
dim rs
set rs = createobject("ADODB.Recordset")
rs.open df, cn
msgbox rs.recordcount 'gives accurate result
dim dc
set dc = createobject("RDS.DataControl")
dc.SourceRecordset = rs
dc.refresh 'error: One or more arguments are invalid
</script></head><body>
<table datasrc="#dc">
<tbody>
<tr>
<td><span datafld="fieldname1"></span></td>
<td><span datafld="fieldname2"></span></td>
<td><span datafld="fieldname3"></span></td>
</tr>
</tbody></body></html>

The msgbox accurately reflects the recordcount.

However, the dc.refresh throws the error "One or more arguments are
invalid". Without the dc.refresh line I get no errors, but I get no data in
the table.

TDC = Tabular Data Control ... a data source object that can handle simple
delimited text files, like CSVs. Instead of persisting the source recordset
to open in this HTM, I thought I might write a CSV from it, starting with
the result of a recordset.GetString.

Is ADOR another alternative?

Thanks for your help.

Bruce

"Mark J. McGinty" <mmcginty@xxxxxxxxxxxxxxx> wrote in message
news:%23uETtaFxFHA.3312@xxxxxxxxxxxxxxxxxxxxxxx
>
> "Bruce Hensley" <nobody@nowhere> wrote in message
> news:eJgYKNExFHA.1412@xxxxxxxxxxxxxxxxxxxxxxx
> > I've seen hints that it is possible to bind an HTML table to an ADO
> > recordset, but I can't find an example.
> >
> > I would like to persist a disconnected recordset on the local client,
then
> > open it (read-only) from DHTML and bind it to a table. I want to use
> > recordset.sort and .filter to manipulate the display dynamically.
> >
> > I can find info and examples on binding to XML data islands, TDC, and
> > others, but not just to a recordset. Am I missing something?
>
> Persisted to a file on the client and persisted to a data island are
really
> the same basic things, you can open a recordset by passing it an XML
> DOMDocument object (which exposes an IStream) or you can open it by
passing
> it a file name, or even a URL -- it makes no difference really.
>
> Not sure what TDC is -- do you mean RDC? You will want to use an RDC
object
> but you can hook it up to data on the fly, by setting its SourceRecordset
> property to an open recordset object. Sort it using the RDC.recordset
> property.
>
> Not that I want to be disingenous about the task, but there isn't much
more
> to it than that, and the databound-related attributes on the table and its
> cells.
>
>
> -Mark
>
>
>
>
> > Thanks,
> > Bruce
> >
> >
>
>


.

Relevant Pages

  • Re: bind HTML table to ADO persisted recordset client-side
    ... > dim rs ... Instead of persisting the source ... >>> recordset, but I can't find an example. ... >>> I can find info and examples on binding to XML data islands, TDC, and ...
    (microsoft.public.data.ado)
  • Re: Recordset to XML and back
    ... I persist a hierarchical disconnected recordset as xml. ... hierarchy). ... >> I'm persisting an ado hierarchical recordset to xml and cleaning it up. ...
    (microsoft.public.vb.database.ado)
  • Re: ADO 2.7: Multiple-step operation generated errors
    ... You could try persisting the recordset to XML and then reading the XML back ... You could also persist it to XML and modify the XML then load it back. ...
    (microsoft.public.data.ado)
  • Re: Copy Data from one ADO recordset to Another ...
    ... > What about opening the recordset with a batch cursor, ... > call UpdateBatch? ... That should allow changes to the recordset without ... > persisting them to the db. ...
    (microsoft.public.vb.general.discussion)
  • Re: Copy Data from one ADO recordset to Another ...
    ... > What about opening the recordset with a batch cursor, ... > call UpdateBatch? ... That should allow changes to the recordset without ... > persisting them to the db. ...
    (microsoft.public.vb.database)