Using Web Services for Stored Procedures?

[Tom Jordahl]

Doug,

Try creating a cfcomponent that has multiple cfproperty tags in it with the
data you want to return. Then defined that CFC component as the return type
of the cffunction.

I think that will get you what you want:

<!--- Data type CFC --->
<cfcomponent name="myinfo">
<cfproperty name="retval" type="numeric">
<cfproperty name="mseq" type="string">
...

</cfcomponent>

<!--- Web Service CFC --->
<cfcomponent>
<cffunction name="fcnWS_Login_SP" access="remote" returntype="myinfo"
output="false">
....


Hope that gets you on the right track.

--
Tom Jordahl
Macromedia.

[Doug_iCohere]

Tom,

Thanks for the advice. I eventually discovered the problem - and it had been
staring me right in the face. I read many times about refreshing CFC's in CF
Administrator, but what I failed to realize (or read, despite reading many,
many threads covering this issue) is that once you invoke the CFC the first
time, the Administrator automatically logs it under webservices, thereby
caching it. Even if you delete it from the log, it gets re-created again the
very next time it's invoked. I hope this clarification helps other people if
they experience this same snafu.

I may try your suggestion anyway...but I have a question about it - If I
return a cfcomponent that contains multiple cfproperties that are structs or
arrays, can the cfreturn handle this (i.e. multiple arrays/structs)?

Thanks again,

Doug E.

[Tom Jordahl]

Doug,

Glad you found the solution to your previous problem. Yes all web services
are "registered" in the admin. What this means is that the Java code
generated from the WSDL has been created and compiled. This is expensive,
so we only want to do this once.

> I may try your suggestion anyway...but I have a question about it - If I
> return a cfcomponent that contains multiple cfproperties that are structs

or

> arrays, can the cfreturn handle this (i.e. multiple arrays/structs)?

It can., but remember the structs map *anything* to *anything* and in the
web service world it is much better to be explicit about things and thus use
another cfcomponent instead of a struct.

--
Tom Jordahl