Databinding client side. Still only option RDS?

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Databinding client side. Still only option RDS?

    or since RDS is considered obsolete by MSFT, is there another way?

    Seems RDS way is..

    <OBJECT id=rds classid='xxxx'>
    </Object>

    <Table recordsource="#rds">
    <TR>
    <TD><span datafld="id"></span></TD>
    <TD><input type=text datafld="FirstName"></TD>
    </TR>
    </TABLE>


    <Script VBsript>

    Sub btn_OnClick()

    RDS.url="server/xyz.asp" 'This is response.write XML
    RDS.Refresh

    End Sub

    </SCRIPT>

    Problem is I seem to have reached a size limit in numbers of records that
    XML .ASP page can have and work with RDS. I was just wondering if there was
    a different way? I save using DOM. I can use XMLHTTP to get a disconnected
    recordset and DOM to save both it and an RDS recordset, but I can't find a
    way to bind a disconnected recordset outside of the RDS object. Anyone know
    of a 'non-obsolete' way to do it?

    Many thanks,
    Kevin


    K.M.L. Guest

  2. Similar Questions and Discussions

    1. 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...
    2. 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...
    3. 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...
    4. 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...
    5. 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...
  3. #2

    Default Re: Databinding client side. Still only option RDS?

    K.M.L. wrote:
    > or since RDS is considered obsolete by MSFT, is there another way?
    >
    > Seems RDS way is..
    >
    > <OBJECT id=rds classid='xxxx'>
    > </Object>
    >
    > <Table recordsource="#rds">
    > <TR>
    > <TD><span datafld="id"></span></TD>
    > <TD><input type=text datafld="FirstName"></TD>
    > </TR>
    > </TABLE>
    >
    >
    > <Script VBsript>
    >
    > Sub btn_OnClick()
    >
    > RDS.url="server/xyz.asp" 'This is response.write XML
    > RDS.Refresh
    >
    > End Sub
    >
    > </SCRIPT>
    >
    > Problem is I seem to have reached a size limit in numbers of records
    > that XML .ASP page can have and work with RDS. I was just wondering
    > if there was a different way? I save using DOM. I can use XMLHTTP
    > to get a disconnected recordset and DOM to save both it and an RDS
    > recordset, but I can't find a way to bind a disconnected recordset
    > outside of the RDS object. Anyone know of a 'non-obsolete' way to do
    > it?
    >
    > Many thanks,
    > Kevin
    This has nothing to do with ASP so you should follow up in a client-side
    coding newsgroup. Try one of the groups with "dhtml" in their names, or one
    of the scripting groups. IIRC, there is still an RDS group that sees a lot
    of traffic.

    People still use RDS despite its being deprecated, so that is still an
    option despite the possibility that it may not work in a future version of
    IE.

    Another DSO (data source object) that can be used for data binding is the
    xml data island (there are other DSO's). You can read about it here:
    [url]http://msdn.microsoft.com/workshop/author/databind/data_binding_node_entry.asp[/url]

    I have successfully used this technique (data islands) on simple pages. You
    can use XMLHTTP to refresh the data island (and the bound controls as well).
    Just convert the recordset to XML before returning it to the client, and
    then use loadxml to refresh the data island with the responsetext (or the
    responsexml.xml).

    It seems to me if you are having an issue with the number of records
    involved, that you need to rethink your application so that the number of
    records is limited. You don't want to be running into limitations in client
    memory usage, etc.

    HTH,
    Bob Barrows
    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Barrows Guest

  4. #3

    Default Re: Databinding client side. Still only option RDS?

    Thanks, I'll give that a look.

    In my defense, I don't want to give them all the records, but they want to
    see it all. (mortgage purchasing company - Due Diligence application)

    Thanks,
    Kevin

    "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
    news:ufuujw3KEHA.3012@tk2msftngp13.phx.gbl...
    > K.M.L. wrote:
    > > or since RDS is considered obsolete by MSFT, is there another way?
    > >
    > > Seems RDS way is..
    > >
    > > <OBJECT id=rds classid='xxxx'>
    > > </Object>
    > >
    > > <Table recordsource="#rds">
    > > <TR>
    > > <TD><span datafld="id"></span></TD>
    > > <TD><input type=text datafld="FirstName"></TD>
    > > </TR>
    > > </TABLE>
    > >
    > >
    > > <Script VBsript>
    > >
    > > Sub btn_OnClick()
    > >
    > > RDS.url="server/xyz.asp" 'This is response.write XML
    > > RDS.Refresh
    > >
    > > End Sub
    > >
    > > </SCRIPT>
    > >
    > > Problem is I seem to have reached a size limit in numbers of records
    > > that XML .ASP page can have and work with RDS. I was just wondering
    > > if there was a different way? I save using DOM. I can use XMLHTTP
    > > to get a disconnected recordset and DOM to save both it and an RDS
    > > recordset, but I can't find a way to bind a disconnected recordset
    > > outside of the RDS object. Anyone know of a 'non-obsolete' way to do
    > > it?
    > >
    > > Many thanks,
    > > Kevin
    >
    > This has nothing to do with ASP so you should follow up in a client-side
    > coding newsgroup. Try one of the groups with "dhtml" in their names, or
    one
    > of the scripting groups. IIRC, there is still an RDS group that sees a lot
    > of traffic.
    >
    > People still use RDS despite its being deprecated, so that is still an
    > option despite the possibility that it may not work in a future version of
    > IE.
    >
    > Another DSO (data source object) that can be used for data binding is the
    > xml data island (there are other DSO's). You can read about it here:
    >
    [url]http://msdn.microsoft.com/workshop/author/databind/data_binding_node_entry.a[/url]
    sp
    >
    > I have successfully used this technique (data islands) on simple pages.
    You
    > can use XMLHTTP to refresh the data island (and the bound controls as
    well).
    > Just convert the recordset to XML before returning it to the client, and
    > then use loadxml to refresh the data island with the responsetext (or the
    > responsexml.xml).
    >
    > It seems to me if you are having an issue with the number of records
    > involved, that you need to rethink your application so that the number of
    > records is limited. You don't want to be running into limitations in
    client
    > memory usage, etc.
    >
    > HTH,
    > Bob Barrows
    > --
    > Microsoft MVP - ASP/ASP.NET
    > Please reply to the newsgroup. This email account is my spam trap so I
    > don't check it very often. If you must reply off-line, then remove the
    > "NO SPAM"
    >
    >

    K.M.L. Guest

  5. #4

    Default Re: Databinding client side. Still only option RDS?

    Do you use seperate page as DataIsland or embedded between XML tags on the
    displayed client page?

    Many thanks ,
    Kevin

    "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
    news:ufuujw3KEHA.3012@tk2msftngp13.phx.gbl...
    > K.M.L. wrote:
    > > or since RDS is considered obsolete by MSFT, is there another way?
    > >
    > > Seems RDS way is..
    > >
    > > <OBJECT id=rds classid='xxxx'>
    > > </Object>
    > >
    > > <Table recordsource="#rds">
    > > <TR>
    > > <TD><span datafld="id"></span></TD>
    > > <TD><input type=text datafld="FirstName"></TD>
    > > </TR>
    > > </TABLE>
    > >
    > >
    > > <Script VBsript>
    > >
    > > Sub btn_OnClick()
    > >
    > > RDS.url="server/xyz.asp" 'This is response.write XML
    > > RDS.Refresh
    > >
    > > End Sub
    > >
    > > </SCRIPT>
    > >
    > > Problem is I seem to have reached a size limit in numbers of records
    > > that XML .ASP page can have and work with RDS. I was just wondering
    > > if there was a different way? I save using DOM. I can use XMLHTTP
    > > to get a disconnected recordset and DOM to save both it and an RDS
    > > recordset, but I can't find a way to bind a disconnected recordset
    > > outside of the RDS object. Anyone know of a 'non-obsolete' way to do
    > > it?
    > >
    > > Many thanks,
    > > Kevin
    >
    > This has nothing to do with ASP so you should follow up in a client-side
    > coding newsgroup. Try one of the groups with "dhtml" in their names, or
    one
    > of the scripting groups. IIRC, there is still an RDS group that sees a lot
    > of traffic.
    >
    > People still use RDS despite its being deprecated, so that is still an
    > option despite the possibility that it may not work in a future version of
    > IE.
    >
    > Another DSO (data source object) that can be used for data binding is the
    > xml data island (there are other DSO's). You can read about it here:
    >
    [url]http://msdn.microsoft.com/workshop/author/databind/data_binding_node_entry.a[/url]
    sp
    >
    > I have successfully used this technique (data islands) on simple pages.
    You
    > can use XMLHTTP to refresh the data island (and the bound controls as
    well).
    > Just convert the recordset to XML before returning it to the client, and
    > then use loadxml to refresh the data island with the responsetext (or the
    > responsexml.xml).
    >
    > It seems to me if you are having an issue with the number of records
    > involved, that you need to rethink your application so that the number of
    > records is limited. You don't want to be running into limitations in
    client
    > memory usage, etc.
    >
    > HTH,
    > Bob Barrows
    > --
    > Microsoft MVP - ASP/ASP.NET
    > Please reply to the newsgroup. This email account is my spam trap so I
    > don't check it very often. If you must reply off-line, then remove the
    > "NO SPAM"
    >
    >

    K.M.L. Guest

  6. #5

    Default Re: Databinding client side. Still only option RDS?

    I've done both. It depends on where the data is coming from.

    Again, when using XMLHTTP to refresh data, I use loadXML to refresh the data
    in the island with the data from the responseXML.

    Bob Barrows

    K.M.L. wrote:
    > Do you use seperate page as DataIsland or embedded between XML tags
    > on the displayed client page?
    >
    > Many thanks ,
    > Kevin
    >
    > "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
    > news:ufuujw3KEHA.3012@tk2msftngp13.phx.gbl...
    >> K.M.L. wrote:
    >>> or since RDS is considered obsolete by MSFT, is there another way?
    >>>
    >>> Seems RDS way is..
    >>>
    >>> <OBJECT id=rds classid='xxxx'>
    >>> </Object>
    >>>
    >>> <Table recordsource="#rds">
    >>> <TR>
    >>> <TD><span datafld="id"></span></TD>
    >>> <TD><input type=text datafld="FirstName"></TD>
    >>> </TR>
    >>> </TABLE>
    >>>
    >>>
    >>> <Script VBsript>
    >>>
    >>> Sub btn_OnClick()
    >>>
    >>> RDS.url="server/xyz.asp" 'This is response.write XML
    >>> RDS.Refresh
    >>>
    >>> End Sub
    >>>
    >>> </SCRIPT>
    >>>
    >>> Problem is I seem to have reached a size limit in numbers of records
    >>> that XML .ASP page can have and work with RDS. I was just wondering
    >>> if there was a different way? I save using DOM. I can use XMLHTTP
    >>> to get a disconnected recordset and DOM to save both it and an RDS
    >>> recordset, but I can't find a way to bind a disconnected recordset
    >>> outside of the RDS object. Anyone know of a 'non-obsolete' way to
    >>> do it?
    >>>
    >>> Many thanks,
    >>> Kevin
    >>
    >> This has nothing to do with ASP so you should follow up in a
    >> client-side coding newsgroup. Try one of the groups with "dhtml" in
    >> their names, or one of the scripting groups. IIRC, there is still an
    >> RDS group that sees a lot of traffic.
    >>
    >> People still use RDS despite its being deprecated, so that is still
    >> an option despite the possibility that it may not work in a future
    >> version of IE.
    >>
    >> Another DSO (data source object) that can be used for data binding
    >> is the xml data island (there are other DSO's). You can read about
    >> it here:
    >>
    >
    [url]http://msdn.microsoft.com/workshop/author/databind/data_binding_node_entry.a[/url]
    > sp
    >>
    >> I have successfully used this technique (data islands) on simple
    >> pages. You can use XMLHTTP to refresh the data island (and the bound
    >> controls as well). Just convert the recordset to XML before
    >> returning it to the client, and then use loadxml to refresh the data
    >> island with the responsetext (or the responsexml.xml).
    >>
    >> It seems to me if you are having an issue with the number of records
    >> involved, that you need to rethink your application so that the
    >> number of records is limited. You don't want to be running into
    >> limitations in client memory usage, etc.
    >>
    >> HTH,
    >> Bob Barrows
    >> --
    >> Microsoft MVP - ASP/ASP.NET
    >> Please reply to the newsgroup. This email account is my spam trap so
    >> I don't check it very often. If you must reply off-line, then remove
    >> the "NO SPAM"
    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Barrows [MVP] Guest

  7. #6

    Default Re: Databinding client side. Still only option RDS?

    Thanks. I rarely ask for help beyond that which is given. I usually get in
    and do my own leg work, but I'm confused on this.

    oHTTP=GetObject ("", "MSXML.XMLHTTP")
    oHTTP.Send [url]http://server/xyz.asp[/url]

    now where to I send my oHTTP.responseXML? Between some Div tags?

    or

    oDOMDocument=GetObject("","MSXML.DOMDocument40")
    Even if I do oDOMDocument.loadXML(oHTTP.responseXML), how do I bind to the
    oDOMDocument ?

    Many thanks again,
    Kevin

    "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
    news:OKeUUK6KEHA.1644@TK2MSFTNGP09.phx.gbl...
    > I've done both. It depends on where the data is coming from.
    >
    > Again, when using XMLHTTP to refresh data, I use loadXML to refresh the
    data
    > in the island with the data from the responseXML.
    >
    > Bob Barrows
    >
    > K.M.L. wrote:
    > > Do you use seperate page as DataIsland or embedded between XML tags
    > > on the displayed client page?
    > >
    > > Many thanks ,
    > > Kevin
    > >
    > > "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
    > > news:ufuujw3KEHA.3012@tk2msftngp13.phx.gbl...
    > >> K.M.L. wrote:
    > >>> or since RDS is considered obsolete by MSFT, is there another way?
    > >>>
    > >>> Seems RDS way is..
    > >>>
    > >>> <OBJECT id=rds classid='xxxx'>
    > >>> </Object>
    > >>>
    > >>> <Table recordsource="#rds">
    > >>> <TR>
    > >>> <TD><span datafld="id"></span></TD>
    > >>> <TD><input type=text datafld="FirstName"></TD>
    > >>> </TR>
    > >>> </TABLE>
    > >>>
    > >>>
    > >>> <Script VBsript>
    > >>>
    > >>> Sub btn_OnClick()
    > >>>
    > >>> RDS.url="server/xyz.asp" 'This is response.write XML
    > >>> RDS.Refresh
    > >>>
    > >>> End Sub
    > >>>
    > >>> </SCRIPT>
    > >>>
    > >>> Problem is I seem to have reached a size limit in numbers of records
    > >>> that XML .ASP page can have and work with RDS. I was just wondering
    > >>> if there was a different way? I save using DOM. I can use XMLHTTP
    > >>> to get a disconnected recordset and DOM to save both it and an RDS
    > >>> recordset, but I can't find a way to bind a disconnected recordset
    > >>> outside of the RDS object. Anyone know of a 'non-obsolete' way to
    > >>> do it?
    > >>>
    > >>> Many thanks,
    > >>> Kevin
    > >>
    > >> This has nothing to do with ASP so you should follow up in a
    > >> client-side coding newsgroup. Try one of the groups with "dhtml" in
    > >> their names, or one of the scripting groups. IIRC, there is still an
    > >> RDS group that sees a lot of traffic.
    > >>
    > >> People still use RDS despite its being deprecated, so that is still
    > >> an option despite the possibility that it may not work in a future
    > >> version of IE.
    > >>
    > >> Another DSO (data source object) that can be used for data binding
    > >> is the xml data island (there are other DSO's). You can read about
    > >> it here:
    > >>
    > >
    >
    [url]http://msdn.microsoft.com/workshop/author/databind/data_binding_node_entry.a[/url]
    > > sp
    > >>
    > >> I have successfully used this technique (data islands) on simple
    > >> pages. You can use XMLHTTP to refresh the data island (and the bound
    > >> controls as well). Just convert the recordset to XML before
    > >> returning it to the client, and then use loadxml to refresh the data
    > >> island with the responsetext (or the responsexml.xml).
    > >>
    > >> It seems to me if you are having an issue with the number of records
    > >> involved, that you need to rethink your application so that the
    > >> number of records is limited. You don't want to be running into
    > >> limitations in client memory usage, etc.
    > >>
    > >> HTH,
    > >> Bob Barrows
    > >> --
    > >> Microsoft MVP - ASP/ASP.NET
    > >> Please reply to the newsgroup. This email account is my spam trap so
    > >> I don't check it very often. If you must reply off-line, then remove
    > >> the "NO SPAM"
    >
    > --
    > Microsoft MVP -- ASP/ASP.NET
    > Please reply to the newsgroup. The email account listed in my From
    > header is my spam trap, so I don't check it very often. You will get a
    > quicker response by posting to the newsgroup.
    >
    >

    K.M.L. Guest

  8. #7

    Default Re: Databinding client side. Still only option RDS?

    You would have a data island defined as follows:

    <XML id-xmlData>
    </XML>

    In your scrip, you would do this:

    xmlData.loadXML oHTTP.responseXML.xml

    HTH,
    Bob Barrows


    K.M.L. wrote:
    > Thanks. I rarely ask for help beyond that which is given. I usually
    > get in and do my own leg work, but I'm confused on this.
    >
    > oHTTP=GetObject ("", "MSXML.XMLHTTP")
    > oHTTP.Send [url]http://server/xyz.asp[/url]
    >
    > now where to I send my oHTTP.responseXML? Between some Div tags?
    >
    > or
    >
    > oDOMDocument=GetObject("","MSXML.DOMDocument40")
    > Even if I do oDOMDocument.loadXML(oHTTP.responseXML), how do I bind
    > to the oDOMDocument ?
    >
    > Many thanks again,
    > Kevin
    >
    > "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
    > news:OKeUUK6KEHA.1644@TK2MSFTNGP09.phx.gbl...
    >> I've done both. It depends on where the data is coming from.
    >>
    >> Again, when using XMLHTTP to refresh data, I use loadXML to refresh
    >> the data in the island with the data from the responseXML.
    >>
    >> Bob Barrows
    >>
    >> K.M.L. wrote:
    >>> Do you use seperate page as DataIsland or embedded between XML tags
    >>> on the displayed client page?
    >>>
    >>> Many thanks ,
    >>> Kevin
    >>>
    >>> "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
    >>> news:ufuujw3KEHA.3012@tk2msftngp13.phx.gbl...
    >>>> K.M.L. wrote:
    >>>>> or since RDS is considered obsolete by MSFT, is there another way?
    >>>>>
    >>>>> Seems RDS way is..
    >>>>>
    >>>>> <OBJECT id=rds classid='xxxx'>
    >>>>> </Object>
    >>>>>
    >>>>> <Table recordsource="#rds">
    >>>>> <TR>
    >>>>> <TD><span datafld="id"></span></TD>
    >>>>> <TD><input type=text datafld="FirstName"></TD>
    >>>>> </TR>
    >>>>> </TABLE>
    >>>>>
    >>>>>
    >>>>> <Script VBsript>
    >>>>>
    >>>>> Sub btn_OnClick()
    >>>>>
    >>>>> RDS.url="server/xyz.asp" 'This is response.write XML
    >>>>> RDS.Refresh
    >>>>>
    >>>>> End Sub
    >>>>>
    >>>>> </SCRIPT>
    >>>>>
    >>>>> Problem is I seem to have reached a size limit in numbers of
    >>>>> records that XML .ASP page can have and work with RDS. I was
    >>>>> just wondering if there was a different way? I save using DOM.
    >>>>> I can use XMLHTTP to get a disconnected recordset and DOM to save
    >>>>> both it and an RDS recordset, but I can't find a way to bind a
    >>>>> disconnected recordset outside of the RDS object. Anyone know of
    >>>>> a 'non-obsolete' way to
    >>>>> do it?
    >>>>>
    >>>>> Many thanks,
    >>>>> Kevin
    >>>>
    >>>> This has nothing to do with ASP so you should follow up in a
    >>>> client-side coding newsgroup. Try one of the groups with "dhtml" in
    >>>> their names, or one of the scripting groups. IIRC, there is still
    >>>> an RDS group that sees a lot of traffic.
    >>>>
    >>>> People still use RDS despite its being deprecated, so that is still
    >>>> an option despite the possibility that it may not work in a future
    >>>> version of IE.
    >>>>
    >>>> Another DSO (data source object) that can be used for data binding
    >>>> is the xml data island (there are other DSO's). You can read about
    >>>> it here:
    >>>>
    >>>
    >>
    >
    [url]http://msdn.microsoft.com/workshop/author/databind/data_binding_node_entry.a[/url]
    >>> sp
    >>>>
    >>>> I have successfully used this technique (data islands) on simple
    >>>> pages. You can use XMLHTTP to refresh the data island (and the
    >>>> bound controls as well). Just convert the recordset to XML before
    >>>> returning it to the client, and then use loadxml to refresh the
    >>>> data island with the responsetext (or the responsexml.xml).
    >>>>
    >>>> It seems to me if you are having an issue with the number of
    >>>> records involved, that you need to rethink your application so
    >>>> that the
    >>>> number of records is limited. You don't want to be running into
    >>>> limitations in client memory usage, etc.
    >>>>
    >>>> HTH,
    >>>> Bob Barrows
    >>>> --
    >>>> Microsoft MVP - ASP/ASP.NET
    >>>> Please reply to the newsgroup. This email account is my spam trap
    >>>> so
    >>>> I don't check it very often. If you must reply off-line, then
    >>>> remove the "NO SPAM"
    >>
    >> --
    >> Microsoft MVP -- ASP/ASP.NET
    >> Please reply to the newsgroup. The email account listed in my From
    >> header is my spam trap, so I don't check it very often. You will get
    >> a quicker response by posting to the newsgroup.
    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Barrows [MVP] Guest

  9. #8

    Default Re: Databinding client side. Still only option RDS?

    Okay, not working for me:

    Q1..did you mean <XML id=xmlData> rather than <XML id-xmlData>?
    Q2..is loadXML a method of a tag? No intellisense on xmlData to suggest it
    to this newbie.
    Q3..How do I reference XML tags to get data back into a DOM object as
    streamed recordset? document.all("xmlData").XMLDocument?

    My code:

    '******************* Client ***********
    '**********ttEdit.asp **********
    <%@ Language=VBScript %>
    <HTML>
    <META name=VI60_defaultClientScript content=VBScript>
    <BODY>

    <SCRIPT Language="VBScript">
    Sub btn_OnCLick()

    Dim oHTTP

    Set oHTTP=GetObject("","MSXML2.XMLHTTP")

    oHTTP.Open "GET","http://" + window.location.host +
    "/PreBoarding/_Modules/funcIndicativeBid.asp?Action=IBList&DueDilNo=2001" ,fa
    lse

    oHTTP.Send

    msgbox oHTTP.responseText 'returns it

    xmlData.loadXML oHTTP.responseXML

    msgbox "Finished"

    Set oHTTP=Nothing

    End Sub

    </SCRIPT>

    <XML id=xmlData>
    </XML>
    <TABLE id="tabBooks" border=1 datasrc="#xmlData" Datapagesize="25">
    <THEAD>
    <TR>
    <TH>LoanID</TH>
    <TH>Zip Code </TH>
    </TR>
    </THEAD>
    <TBODY>
    <TR bgcolor=LightGrey>
    <TD><DIV datafld="LoanID"></DIV></TD>
    <TD><INPUT type=text datafld="PropZip"></TD>
    </TR>
    </TBODY>
    </TABLE>
    <DIV id=msg></DIV>
    <BR>
    <INPUT TYPE=BUTTON name=btn Value="Get">

    </BODY>
    </HTML>

    '**********Server Code/Returns XML ***********
    '**********funcIndicativeBid.asp ************
    <%

    Set cn=Server.CreateObject("ADODB.Connection")
    Set rsBid=server.CreateObject("ADODB.Recordset")
    Set strmXML=Server.CreateObject("ADODB.Stream")

    cn.ConnectionString=strCN
    cn.Open

    rsBid.LockType = 4
    rsBid.CursorLocation = 3
    rsBid.ActiveConnection=cn

    strSQL="SELECT IB.*" & _
    " FROM pbdIndicativeBid IB" & _
    " Where IB.BidNumber=" & Request.QueryString("DueDilNo") & " ORDER BY
    IB.SeqNo"

    rsBid.Open strSQL

    Set rsBid.ActiveConnection=nothing
    cn.Close
    set cn = nothing

    rsBid.Save strmXML, adPersistXML

    Response.ContentType = "text/xml"
    'Response.Expires = 0
    'Response.Buffer = False
    Response.Write ("<?xml version='1.0'?>" + vbCrLf)
    Response.Write strmXML.ReadText

    'Clean Up
    %>

    Above works with RDS, but not <XML id=xmlData><XML> xmlData.loadXML
    oHttp.responseXML

    "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
    news:ulqWXT7KEHA.2012@TK2MSFTNGP11.phx.gbl...
    > You would have a data island defined as follows:
    >
    > <XML id-xmlData>
    > </XML>
    >
    > In your scrip, you would do this:
    >
    > xmlData.loadXML oHTTP.responseXML.xml
    >
    > HTH,
    > Bob Barrows
    >
    >
    > K.M.L. wrote:
    > > Thanks. I rarely ask for help beyond that which is given. I usually
    > > get in and do my own leg work, but I'm confused on this.
    > >
    > > oHTTP=GetObject ("", "MSXML.XMLHTTP")
    > > oHTTP.Send [url]http://server/xyz.asp[/url]
    > >
    > > now where to I send my oHTTP.responseXML? Between some Div tags?
    > >
    > > or
    > >
    > > oDOMDocument=GetObject("","MSXML.DOMDocument40")
    > > Even if I do oDOMDocument.loadXML(oHTTP.responseXML), how do I bind
    > > to the oDOMDocument ?
    > >
    > > Many thanks again,
    > > Kevin
    > >
    > > "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
    > > news:OKeUUK6KEHA.1644@TK2MSFTNGP09.phx.gbl...
    > >> I've done both. It depends on where the data is coming from.
    > >>
    > >> Again, when using XMLHTTP to refresh data, I use loadXML to refresh
    > >> the data in the island with the data from the responseXML.
    > >>
    > >> Bob Barrows
    > >>
    > >> K.M.L. wrote:
    > >>> Do you use seperate page as DataIsland or embedded between XML tags
    > >>> on the displayed client page?
    > >>>
    > >>> Many thanks ,
    > >>> Kevin
    > >>>
    > >>> "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
    > >>> news:ufuujw3KEHA.3012@tk2msftngp13.phx.gbl...
    > >>>> K.M.L. wrote:
    > >>>>> or since RDS is considered obsolete by MSFT, is there another way?
    > >>>>>
    > >>>>> Seems RDS way is..
    > >>>>>
    > >>>>> <OBJECT id=rds classid='xxxx'>
    > >>>>> </Object>
    > >>>>>
    > >>>>> <Table recordsource="#rds">
    > >>>>> <TR>
    > >>>>> <TD><span datafld="id"></span></TD>
    > >>>>> <TD><input type=text datafld="FirstName"></TD>
    > >>>>> </TR>
    > >>>>> </TABLE>
    > >>>>>
    > >>>>>
    > >>>>> <Script VBsript>
    > >>>>>
    > >>>>> Sub btn_OnClick()
    > >>>>>
    > >>>>> RDS.url="server/xyz.asp" 'This is response.write XML
    > >>>>> RDS.Refresh
    > >>>>>
    > >>>>> End Sub
    > >>>>>
    > >>>>> </SCRIPT>
    > >>>>>
    > >>>>> Problem is I seem to have reached a size limit in numbers of
    > >>>>> records that XML .ASP page can have and work with RDS. I was
    > >>>>> just wondering if there was a different way? I save using DOM.
    > >>>>> I can use XMLHTTP to get a disconnected recordset and DOM to save
    > >>>>> both it and an RDS recordset, but I can't find a way to bind a
    > >>>>> disconnected recordset outside of the RDS object. Anyone know of
    > >>>>> a 'non-obsolete' way to
    > >>>>> do it?
    > >>>>>
    > >>>>> Many thanks,
    > >>>>> Kevin
    > >>>>
    > >>>> This has nothing to do with ASP so you should follow up in a
    > >>>> client-side coding newsgroup. Try one of the groups with "dhtml" in
    > >>>> their names, or one of the scripting groups. IIRC, there is still
    > >>>> an RDS group that sees a lot of traffic.
    > >>>>
    > >>>> People still use RDS despite its being deprecated, so that is still
    > >>>> an option despite the possibility that it may not work in a future
    > >>>> version of IE.
    > >>>>
    > >>>> Another DSO (data source object) that can be used for data binding
    > >>>> is the xml data island (there are other DSO's). You can read about
    > >>>> it here:
    > >>>>
    > >>>
    > >>
    > >
    >
    [url]http://msdn.microsoft.com/workshop/author/databind/data_binding_node_entry.a[/url]
    > >>> sp
    > >>>>
    > >>>> I have successfully used this technique (data islands) on simple
    > >>>> pages. You can use XMLHTTP to refresh the data island (and the
    > >>>> bound controls as well). Just convert the recordset to XML before
    > >>>> returning it to the client, and then use loadxml to refresh the
    > >>>> data island with the responsetext (or the responsexml.xml).
    > >>>>
    > >>>> It seems to me if you are having an issue with the number of
    > >>>> records involved, that you need to rethink your application so
    > >>>> that the
    > >>>> number of records is limited. You don't want to be running into
    > >>>> limitations in client memory usage, etc.
    > >>>>
    > >>>> HTH,
    > >>>> Bob Barrows
    > >>>> --
    > >>>> Microsoft MVP - ASP/ASP.NET
    > >>>> Please reply to the newsgroup. This email account is my spam trap
    > >>>> so
    > >>>> I don't check it very often. If you must reply off-line, then
    > >>>> remove the "NO SPAM"
    > >>
    > >> --
    > >> Microsoft MVP -- ASP/ASP.NET
    > >> Please reply to the newsgroup. The email account listed in my From
    > >> header is my spam trap, so I don't check it very often. You will get
    > >> a quicker response by posting to the newsgroup.
    >
    > --
    > Microsoft MVP -- ASP/ASP.NET
    > Please reply to the newsgroup. The email account listed in my From
    > header is my spam trap, so I don't check it very often. You will get a
    > quicker response by posting to the newsgroup.
    >
    >

    K.M.L. Guest

  10. #9

    Default Re: Databinding client side. Still only option RDS?

    K.M.L. wrote:
    > Okay, not working for me:
    >
    > Q1..did you mean <XML id=xmlData> rather than <XML id-xmlData>?
    Yes
    > Q2..is loadXML a method of a tag? No intellisense on xmlData to
    > suggest it to this newbie.
    No intellisense is available for it. loadXML is a method of the XML
    DOMDocument. You treat the data island as if it was a DOMDocument (which it
    is)
    [url]http://msdn.microsoft.com/library/en-us/xmlsdk/htm/xml_obj_ixmldomdocument_692s.asp[/url]
    > Q3..How do I reference XML tags to get data back into a DOM object as
    > streamed recordset? document.all("xmlData").XMLDocument?
    I've never tried using a streamed recordset for databinding. I've always
    converted my recordset to a new XML document by using the DOM methods
    (CreateElement, etc). Moreover, you are attempting to bind a table to the
    DSO. I have found that certain events don't work correctly when table
    elements are bound to attributes in the xml document. If you look at the xml
    for your streamed recordset, you will see that the data is contained in
    attributes rather than elements.

    Given this data island:
    <XML ID="xml1">
    <topic-info>
    <page-type>reference</page-type>
    </topic-info>
    <topic-info>
    <page-type>reference2</page-type>
    </topic-info>
    </XML>

    You would use this:
    <table datasrc="#xml1">
    <tr><td><INPUT type="text" datafld="page-type"></td></tr>
    </table>


    Please follow up in a more appropriate newsgroup. This has nothing to do
    with ASP, unless you wish to discuss the server-side code, of course.

    Bob Barrows
    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Barrows [MVP] Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139