How do incorporate this XML to instead pull live recordset out of a database. (sql server)


<xml id="Datos">
            <ROOT>
                <ROW Chk="0" ps_id="1" psid_id="5" tipPrd_id="5" />
                <ROW Chk="0" ps_id="3" psid_id="3" tipPrd_id="4" />
                <ROW Chk="0" ps_id="1" psid_id="2" tipPrd_id="3" />
                <ROW Chk="0" ps_id="1" psid_id="5" tipPrd_id="5" />
                <ROW Chk="0" ps_id="3" psid_id="3" tipPrd_id="4" />
                <ROW Chk="0" ps_id="1" psid_id="2" tipPrd_id="3" />
                <ROW Chk="0" ps_id="1" psid_id="2" tipPrd_id="3" />
            </ROOT>
        </xml>

        <TABLE DATASRC=#Datos BORDER=1 align="center">
            <thead>
                <th nowrap>&nbsp;</th>
                <th nowrap>Packet</th>
                <th nowrap>Type</th>
                <th nowrap>size</th>
            </thead>
            <tr>
                <td nowrap ><input type="checkbox" datafld="Chk" id="Chk" name="Chk" ></td>
                <td><span datafld="ps_id"></span></td>
                <td><span datafld="psid_id"></span></td>
                <td><span datafld="tipPrd_id"></span></td>
            </tr>
        </TABLE>

If you are using SQL Server 2000 with xml add on then set up a virtual templates folder and put in an xml query that delivers your xml. After that change your xml island to have a src attribute pointing at the xml query file instead of having an actual body. See msdn.com for advice on setting up the virtual folder. Serach for sqlxml.

--

Joe

I already know how to set up virtual Dir in IIS. The only thing is where do I store these templates? Do I create a folder in my ASP project and store them there. Please give me some infor on where do I physcally store these templates after I have created my VirDir. Also where do I store any XSL files.

This site has dozens of examples of doing what you want. No one is going to spoon feed you forever in software development, you need to be able to read these sorts of documents and apply them to your specific circumstances. If you have specific examples that you have created but they are not working people are willing to help debug but not to do all the work for you.

http://www.sqlxml.org/

Good luck

--

Joe

Hey come down. I know what you mean though, maybe I just need some direction as to where I can find these resources.