Generate XML from CFC...HELP

[cfhottie]

Can any of you CF experts help me visualize how a CFC needs to look to generate
XML? Do I need to use CF tags to create the XML within a query and return it
as a string ??

I also need to have a CFC to take an XML file and parse it within the service.

A simple sample would be ideal otherwise I could get by with some hand holding.

TIA

[adonis1976]

this depends on how you are building the xml from the query? how is the result
set going to look like? once you know this, what you can do is to have a
cfsavecontent variable with this xml document... After call the method in your
cfc that will read and parse it.. something like

<cfset readMyXml(myXMLvar)>

in the CFC method itself you can have a required argument of type any. Let me
know if it makes sense.

[cfhottie]

What I would like to do is to have a CFC receive an arguement and run a query.
Produce the results of the query in an XML format.

Conversely, I need a CFC to receive an XML file, and execute a query to update
a database table for the XML doc it receives. I am basically starting out with
this and would prefer a straight forward, basic sample.

I am just having trouble getting the whole job started. I feel a bit
intimidated by the web service and XML.

:confused;

[jim1234]

It's easy to do. Here's an example:

<cfcomponent output="no" displayname="Books">

<cffunction access="remote" name="getEvaluation" returntype="string">
<cfargument name="Id" type="numeric" required="yes">

<cfquery datasource="your_datasource" name="thisQuery">
select id, name, title
from books
where id = <cfqueryparam type="cf_sql_bigint" value="#id#">
</cfquery>

<cfxml variable="XMLEval">
<books>
<cfoutput query="thisQuery">
<book_detail>
<book_id id="#thisQuery.id#"/>
<name>#thisQuery.name#</namd>
<title>#thisQuery.title#</title>
</book_detail>
</cfoutput>
</books>
</cfxml>
<cfset XMLString = toString(XMLBooks)>

<cfreturn XMLBooks>
</cffunction>

</cfcomponent>

[lad4bear]

Hi there,

Just a quick additon. Depending on how you create you xml and how picky the
your target xml parser is, you can run into problems with whitespace existing
before your xml declaration. If you run into this problem you can sidestep it
as follows:

#Trim(ToString(insertnameofxmldocumenthere)#

[developwin]

:)

Many thanks to the awesome guys who responded, especially, jim1234 and lad4bear. It made the approach I need to take quite clear.