I'll have to go the other way and say SQL 2k is the better tool for this job. SQL servers native support for xml is much more powerful than the clumsy hoops you'll have to jump through to get your data formatted in CF. Is there a bit of a learning curve? Sure, but a little research on MSDN and you'll have a good solution in no time. In addition, you'll find you might actually utilize SQL Server to a fuller extent on future projects.
Plus, there is no reason why you couldn't use a schema to validate to a DTD, you'll just have to understand the differences. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of S. Isaac Dealey Sent: Tuesday, March 11, 2003 5:43 PM To: [EMAIL PROTECTED] Subject: Re: Generating an XML document 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
