Ok then there must be some issue with classic asp then, @patrick will investigate this.
OK thanks. I tried this on another set of data with the same result
Long shot, but I work in classic asp with MS SQL with ints.
I cannot remember exactly, but a few times I had to modify the underlying dmxconnect .asp page rules where the type = ‘double’ and change to ‘number’
I see in the connection that is is handled as “double” but simply changing that to number does not help. I think you may be on to something though
What was the output for the first query, was the ManagerID a number or a string? You can try using {{ManagerID.toNumber()}} as expression for the condition of the second query.
thanks, let me try that
Well I finally got this working by using the Manager Group description (text) to link the files. In the second query I just used the Manager and Manager ID to link the tables and query the description. I guess as long as the description is unique I’ll be fine. Just weird that it can’t handle regular integers. Seems like a bug but not sure if its mine or wapplers. For now I’ll live with it. Once again, thanks for your time