Hi,
I've got a COM object that our company uses to access data - a "data broker"
if you will. Calling the "RetrieveDataSet" method returns an ADO query.

I need to output the results into an XML-ish structure to use as a web
service. The thing is, I cannot figure out how to get the results of the COM
call into some sort of usable format.

Any ideas? See code below:

<cfcomponent displayName="PublicWebServices"
hint="Access to Publicly Available Items "
access="remote">
<cffunction name="getNews"
hint="getNews"
access="remote"
output="false"
returntype="string">

<cfset Var xmlDoc = "">
<cfset Var rsNews = "">
<cfset Var rsNews_Schema = "INTRANET">
<cfset Var rsNews_DB = "ORACLE3_CACH">
<cfset Var rsNews_Int = 0>
<cfset Var rsNews_Msg = "">

<cfset Var rsNews_SQL = "SELECT
INA.GROUP_ID,
INA.NEWS_ID,
INN.NEWS_GUID,
INN.NEWS_TITLE,
INN.NEWS_MSG,
INN.FILE_NAME,
INN.ADDED_DATE,
INN.ADDED_BY
FROM
INTRANET.INTR_NEWS_ASSIGN INA,
INTRANET.INTR_NEWS INN
WHERE INA.NEWS_ID = INN.NEWS_ID AND
GROUP_ID = 20
ORDER BY
ADDED_DATE DESC">

<cfobject type="com"
action="create"
class="BICUSObjects.BICUSObject"
name="objBICUS" context="local">
<cfset rsNews =
objBICUS.RetrieveDataSet("ADO",rsNews_DB,rsNews_Schema,"",rsNews_SQL,rsNews_Int,rsNews_Msg)>

<cfsavecontent variable="xmlDoc">
<mig_news>
<cfoutput>
#rsNews#
</cfoutput>
</mig_news>
</cfsavecontent>
<cfreturn xmlDoc>
</cffunction>
</cfcomponent>

--
Andrew Gscheidle


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1394
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to