Re: Dynamic query woes.

2006-03-24 Thread Ted Schrader
Here are some juicy details on the remapResults attribute: http://opensource2.atlassian.com/confluence/oss/pages/viewpage.action?pageId=3057 Ted

Re: Dynamic query woes.

2006-03-23 Thread Larry Meadors
Add remapResults="true" in the select tag. There is a performance hit, but it will work. Larry On 3/23/06, Daniel Pitts <[EMAIL PROTECTED]> wrote: > I have a very generic query which has different column names, depending > on what was passed to it. > > SELECT $columns$ FROM $from$ WHER

Dynamic query woes.

2006-03-23 Thread Daniel Pitts
I have a very generic query which has different column names, depending on what was passed to it. SELECT $columns$ FROM $from$ WHERE $where$ It works fine the first time. And it even works fine if $columns$ doesn't change. However, if $columns$ had (for instance) "my_column" in one quer