tracker issue : CF-3948955

select a category, or use search below
(searches all categories and all time range)
Title:

Empty Query Improperly Displaying in WebServices in CF 11

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Kevin Benore / Kevin Benore (Kevin Benore)

Created: 03/05/2015

Components: Web Services, Axis 2

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Win 2012 Server x64

Vote Count: 1

Listed in the version 2016.0.0.297996 Issues Fixed doc
Verification notes: verified_fixed on September 08, 2019 using build 2016.0.01.298513 
Problem Description: Empty queries on Axis 2 for BOTH CF 10/CF 11 comes back as a QueryBean object instead of empty query (as it does with Axis 1). Queries with results come back as normal queries.

I realize CF is supposed to convert the wsdl item which is actually a querybean, but it does not seem to be doing so in this case.

Steps to Reproduce: Create a WSDL (remote) function with an empty query. Call that function from either createobject or cfinvoke.

Actual Result: Empty query results in a querybean object whose details are undefined.

Expected Result: Query with zero results

Any Workarounds: Not elegant, but we can check to see if the item is an object and assume it is an empty query result ... qResult = isObject(qFunc(id=0)) ? querynew("") : qFunc(id=0);

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3948955

External Customer Info:
External Company:  
External Customer Name: Kevin
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments:

You need to add modern Windows servers / browsers to your "Platform" / "Browser" sections.
Comment by External U.
8174 | March 05, 2015 09:24:01 AM GMT
Upgraded from cf 8 to cf 11 to find out that my code was breaking. Work around was to downgrade to axis 1. Looking forward to this bugfix to be deployed.
Vote by External U.
8176 | August 25, 2015 09:50:15 PM GMT
The test case works for me. Please check it in new build. Is returned result a query? YES query ADDRESS ARTISTID CITY EMAIL FAX FIRSTNAME LASTNAME PHONE POSTALCODE STATE THEPASSWORD It is an instance of QueryTable. Please check.
Comment by Paul N.
8175 | September 22, 2015 12:48:36 AM GMT
Hi Adobe, I've verified this is fixed in CF2016 Update 1 (build 2016.0.01.298513). Thanks!, -Aaron
Comment by Aaron N.
31311 | September 08, 2019 08:41:27 AM GMT