Well, we need to get data from a SQL Server database (a complex set of related tables) into another system using XML. I have created a DTD that is based on Dublin Core data model, but with added elements. So I need to get that data into an XML document using our custom DTD that can then be imported into this system.
Now, this is relatively new territory for me. I don't really understand your question about automating the DTD. However, based on other parts of your response, it is apparent that using CF 4.5 would be better than using SQL Server 2000. Thanks for your quick response. Karen >>> [EMAIL PROTECTED] 3/11/03 5:43:06 PM >>> 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
