-
-
2. Re: Unexpected Results Query of Queries
CRidgway wrote:
> Quite an unexpected result.
>
> CR
What was the unexpected result?
I think I received what I would have expected to see, but it is an
unusual query. -
3. Re: Unexpected Results Query of Queries
What I expect (and use in apps I write when needed) is the result from the 2nd query should be:
q2.recordcount = 1
q2.fieldlist = "abc"
q2.abc = 0
Running these types of queries directly against MS SQL and MS Access yields the results listed above. In the case of the QoQ results, the recordcount is 0 thus abc is not defined.
CR -
4. Re: Unexpected Results Query of Queries
quote:
Originally posted by: CRidgway
What I expect (and use in apps I write when needed) is the result from the 2nd query should be:
q2.recordcount = 1
q2.fieldlist = "abc"
q2.abc = 0
Running these types of queries directly against MS SQL and MS Access yields the results listed above. In the case of the QoQ results, the recordcount is 0 thus abc is not defined.
CR
Aww, you gave away the answer. This scenario (different sql of course) happened to me this afternoon. I couldn't believe it. In any event I handled it in the template I was working on and logged a bug to Adobe.