AnsweredAssumed Answered

NSQL User Supplied Parameters Question

Question asked by bfarquhar on Apr 6, 2011
Latest reply on Apr 7, 2011 by bfarquhar
Question for you.... I'm writing a bunch of NSQL queries and I'm having trouble with User-supplied Parameters. I'm finding that they don’t work when I have them a few levels down in my nested sub-queries. Is it possible to put them in sub queries or do they always need to be in the outer most "Where" ?

Also... in my latest query I was trying to use the same 2 parameters in 3 different places/sub-queries and I was getting an error saying something about my parameters being inconsistently specified. The syntax was identical in all 3 places so I don’t know what is going on. When I removed them from all locations my NSQL checks out ok. Now I'm thinking I need to carry the values I want to filter on up through all my sub queries to the outer most query so that I can then use the Param once at the outer most where. Is this the best approach ?

Any help you can provide would be much appreciated !!