By automating the DTD I just mean that -- it's possible to automate the
process of getting data into an xml packet without automating the format of
that packet. i.e. we do it all the time with html or xhtml, we say
#showmyimage('blah.gif','right')# and that function (as an example) knows
where the image is stored and how to display it in html or xhtml format as
<img src="yaddayadda/blah.gif" border="0" align="right" />
Now if I wanted to go significantly further than that and say I decided that
I wanted a way to be able to make the showmyimage() function transparent to
the DTD or the schema being used (so that if the DTD or schema were changed
or updated I wouldn't have to also edit my function), the function would
have to be able to read the DTD or schema and determine what elements are
available, with what attributes and in what order, and then it would have to
examine the data provided to it (in your case most likely column names), to
determine what data is available to it and then compare that data to the
elements and attributes specified in the DTD or schema to determine the
placement of the data. So I'm guessing that's more than you need or want. :)
Glad I could help. :)
> 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
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
