I would tend to agree w/using CF. However, there are a lot of new XML and web type features built into SQL2K that you may be able to take advantage of.
I'd skim through SQL's BOL and see if any of them apply before going 100% w/CF. However, since you're going w/a DTD, and MS is all about schema's, you may have to go CF. Eric ----- Original Message ----- From: "S. Isaac Dealey" <[EMAIL PROTECTED]> Are you talking about automating the DTD or just making the data into a DTD validateable packet? In most cases I would recommend using CF for the creation of the actual xml output. Unless it's a _very_ simple DTD and you think you can get the whole packet into a single query row, and you don't need to automate the DTD. Which may be the case if you've just got something like a table for RSS newsfeeds and a column for each element / attribute you might want to drop data into. > Which would be easier to use to generate an XML file from > SQL database using a customized DTD - SQL Server 2000 > query or CF4.5? We cannot afford to upgrade to CFMX and > the output must be based on a DTD, not a schema. We will > eventually import the XML file into another system. > Thanks. > Karen R. Harker, MLS > UT Southwestern Medical Library > 5323 Harry Hines Blvd. > Dallas, TX 75390-9049 > 214-648-8946 > http://www.utsouthwestern.edu/library/ > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > Send UNSUBSCRIBE to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
