Hi,
I have an DMX query which has to have named or positional parameters:
select * from openquery(TAO, 'WITH MEMBER [ID] AS :id MEMBER [NAME] AS :name MEMBER [CHILDREN] AS :children select {[ID]} ON COLUMNS, order( {[CHILDREN}, [NAME], asc) on rows from [TAO]')
The problem is that the org.hibernate.engine.query.ParameterParser, which is responsible for parsing a query string and recognizing tokens, skips everything within single quotes. Hence, I can't substitute any defined parameters. Any advice/workaround is appreciated. Thanks!
|