Joshua Olson wrote: > Here is a trick if you need to dump information from an SQL table directly > into an HTML table. Note, this works on MS SQL Server 2k: > > SELECT > id AS td > , name AS td > , username AS td > , password AS td > FROM admins tr > ORDER BY 1 > FOR XML AUTO, ELEMENTS > > That will produce an output stream that looks roughly like this: > > <tr><td>1</td><td>Administrator</td><td>administrator</td><td>password</td>< > /tr><tr><td>2</td><td>Joshua Olson</td><td>joshua</td><td>12345</td></tr> > > This block of code is ready to be dropped into a table on the page. > > One tricky point is that the result set you get back will have one column > with the data, and the column name will be XML_[GUID]. Most scripting > languages should have tools in place to let you figure out how to get to the > data. fwiw, MySQL 4.0 will also produce query results as XML :) -- Burhan Khalid thelist[at]meidomus[dot]com http://www.meidomus.com ----------------------- "Documentation is like sex: when it is good, it is very, very good; and when it is bad, it is better than nothing."