SQL Server & Radio: OK, I figured out enough of SQL Server 2000's XML and also XSL to be able to write a macro in Radio which publishes the results of a database query. Here's a table of the last 10 books I've read, pulled from my database HTTP/1.1 200 OK
Server: Microsoft-IIS/5.0
Date: Sun, 07 Apr 2002 10:02:59 GMT
Content-type: text/html
Expires: -1;
| Title |
|---|
| Tishomingo Blues | | Dig Infinity! The Life and Art of Lord Buckley | | Back to the Miracle Factory: Rock Etc. 1990's | | Basket Case | | The Dylan Companion | | Miami Blues | | The Deadline: A Novel about Project Management | | Vitals | | The Botany of Desire: A Plant's-Eye View of the World | | Joe College |
Pulling the header stuff off the top shouldn't be too hard; I just need to do it. From the Radio end, this was pretty easy, I just use tcp.httpClient() to call a SQL Server Virutal directory, with the name of a template file and an XSL stylesheet in the URL. It looks something like this:
http://burntfish/books_db/template/recent.xml?xsl=templates/recent_w_last.xsl
Of course this only works, for now inside my own firewall. And of course, I'm using stuff built in to IIS and SQL Server, so Radio isn't necessarily needed. Later I'll use Radio to turn this into a Web Service, which I think will be a lot easier than using SQL Server and .NET.
9:05:47 PM 
|
