d, you are returning "quoted field names" with the custom function right?
does it return "table.fieldName" or "table::fieldName" ?
remember this is SQL you use the "." between the table and field name, not "::".
thanks for your answer.
However that's not the problem. My CF returns just the field name and I use it in the entire solution. I can even execute the second select as a single query without any problem. The subselect seems to be the "breaker".
I'm wondering if my code is bad or the executeSQL() function doesn't support it. Can't find any documentation about this :-(
1 of 1 people found this helpful
I had posted this in another thread so easy copy and paste. :-)
AFAIK, and from what I have tested, nested subqueries referencing derived tables do not work. You can reference it when using for example an IN but directly referencing it seems to not work.
SELECT * FROM (
GROUP BY Category)qry_sub1
mr_vodka, thanks for your reply.
Yes, this seems unfortunately to be true. I also tested some other queries and – as you say – if you use another select in e.g. an IN clause it works. Directly referencing does not. :-(
Nevertheless thank you for your confirmation.