Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
David Aden #1
web services problem processing embedded query resultset
We ran into an interesting problem with using queries and web services. This
was on MX 6.1 Windows. This may be known already, though we didn't find
anything about it with an initial search on the forums. We created a
component that has a method that returns a structure which contains a query as
one of its members. On trying to invoke the method, we sometimes got a message
that said something to the effect (I don't have the exact error available right
now) that a querybean wasn't available to deserialize the returned structure
(which contained the embedded query). With a bunch of tracing down, we found
that the problem only existed if there was nothing in the component that was
explicitly set to a datatype of 'query'. In other words, if no method had a
return type of 'query' and no arguments were set to type 'query', then the
problem showed up. As soon as the return type of any method in the component
or the datatype of any argument in any method in the component was set to
'query', it started to work. So, it basically appears that unless CF is told
that it needs to include the query deserializer, it doesn't and embedded
queries aren't processed when the web services is invoked. One way to get
around the problem is to simply include a CFARGUMENT of type 'query' in an
init() method. Actually, I don't believe the init() method even needs to be
invoked -- it seems to be just the presence of the argument that allows CF to
process the structure containing a query as one of its members. d
David Aden Guest
-
Access a specific resultset (Query) row
I am iterating over a CF Query and want to implement a generic function which takes the query and the rownumber as a parameter. How can I access a... -
#6503 [Opn->Asn]: no support for multiple resultset query?
ID: 6503 Updated by: bjori@php.net Reported By: alonso at computacionlegal dot com -Status: Open +Status: Assigned Bug Type:... -
return query resultset from custom tag
Hi, How to return an entire query resultset from custom tag to the calling page ? Thanks for your help. vmrao -
Getting recordcount from resultset of 'union' query
Hi, I need to find out the number of records in the resultset of a union of 2 queries. E.g. "select ID from Pages where numPageCatID = " &... -
problem : callable statement / COBOL services How to get ResultSet(s)
LO For a professionnal project i have to work with DB2 data returned by COBOL services. These COBOL services take several blocs in input...



Reply With Quote

