2 Replies Latest reply on Aug 13, 2007 10:06 AM by rgurganus

    CFC query union with database query

    rgurganus
      I'm trying to invoke a webservice to return a query, and then run a parallel query in another database, and UNION the two with a query of query. Both the webservice server and the local server are CF7, both running MySQL, both accessing tables with parallel structures. The webservice returns what appears to be a normal query from CFDUMP, but then when I UNION it with the second query, I get either "Incorrect Select List" or "Columns with index number equal "1" have diffent types (SMALLINT, JAVA_OBJECT)" errors. So apparently there's something different about the query from the webservice that's causing problems?