Problem ORACLE 10G Select ?

2009-01-30 Thread lucy . x . cameron
Im having an issue with a specific clause in an oracle select, that I'm using within a sqlMap. The offending code is this AND (('ALL' IN ($types$)) OR (TXT.TYPES IN ($types$))) I have set remapResults=true, the java parameter class has types property as a String and types is of type

Re: Problem ORACLE 10G Select ?

2009-01-30 Thread Larry Meadors
What's the value of types? Larry PS: That has to be the longest disclaimer ever. Congratulations.

Re: Problem ORACLE 10G Select ?

2009-01-30 Thread lucy . x . cameron
Subject Please respond to Re: Problem ORACLE 10G Select ? user-j...@ibatis. apache.org

Re: Problem ORACLE 10G Select ?

2009-01-30 Thread Nathan Maves
Along larry's point I would expect that your value for $types$ looks something like 'test','me','out' make sure you have your single quotes around your data and no extra commas :) or post your code! nathan On Fri, Jan 30, 2009 at 7:24 AM, Larry Meadors larry.mead...@gmail.comwrote: What's

Re: Problem ORACLE 10G Select ?

2009-01-30 Thread Nathan Maves
Please respond to Re: Problem ORACLE 10G Select ? user-j...@ibatis. apache.org What's the value of types? Larry PS: That has to be the longest disclaimer ever. Congratulations. Generally, this communication is for informational purposes only

Re: Problem ORACLE 10G Select ?

2009-01-30 Thread Nathan Maves
@ibatis.apache.org 30/01/2009 14:24 cc Subject Please respond to Re: Problem ORACLE 10G Select ? user-j...@ibatis. apache.org