Dynamic Query API

Re: using Like in query with Oracle db

mulgurul — Tue, 20 Oct 2009 09:36:22 GMT

I have the same problem here, so it does not seem to have changed in newer versions. Did you ever get this problem solved?

Could be grat with some internal help here from the ES guys!

It does not matter wetter you use wildcards or not, ie. '%peted%' and 'peter' both fails with ORA-12704 error.

Best regards

Peter Meldgaard

Re: using Like in query with Oracle db

msyoung — Fri, 29 Jun 2007 16:07:09 GMT

LoadAll works fine.

Re: using Like in query with Oracle db

David.Parsons — Fri, 29 Jun 2007 15:38:49 GMT

Using DynamicQuery, there is no way to interact with the parameters that EntitySpaces creates. So, changing the parameter type from String to Empty is not possible. Does this only affect Where parameters? Does LoadAll() work?

Re: using Like in query with Oracle db

msyoung — Fri, 29 Jun 2007 10:37:16 GMT

It is a varchar2. Is there a way to specify the parameter datatype? Or do you have an alternate suggestion besides just writing the sql?

Re: using Like in query with Oracle db

David.Parsons — Thu, 28 Jun 2007 22:49:41 GMT

A quick Google search on that error indicates there may be some issues related to Oracle 8i that do not apply to 10g.

http://forums.asp.net/p/957619/1186441.aspx

Is this an NVARCHAR2 column? Can you change it to VARCHAR2?

Re: using Like in query with Oracle db

msyoung — Thu, 28 Jun 2007 19:29:35 GMT

Value "%THE COSBY SHOW%" object {string}

and here is the parameter value as seen in the watch window.

Re: using Like in query with Oracle db

msyoung — Thu, 28 Jun 2007 19:25:23 GMT

"SELECT * FROM \"PROMDBA\".\"DT_CAMP\" WHERE (\"NAME\" LIKE :NAME1 )"

Looks fine to me.

Re: using Like in query with Oracle db

David.Parsons — Thu, 28 Jun 2007 18:48:36 GMT

Can you post campaigns.Query.es.LastQuery? We do not test against Oracle 8, but you should be able to tell whether the SQL generated is valid for your version.

using Like in query with Oracle db

msyoung — Thu, 28 Jun 2007 18:25:48 GMT

I am trying to use a query with this "like" statement with Oracle 8.1.7

campaigns.Query.Where(campaigns.Query.Name.Like(criteria.Name));

criteria.Name is a valid string value;

When execute campaigns.Query.Load(),

I get Oracle exception: ORA-12704: character set mismatch.

Any suggestions