DevForce Community Forum : String Comparisons

DevForce Community Forum : String Comparisons http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2012 : String Comparisons Sat, 11 Apr 2026 01:22:27 -700 Fri, 12 Apr 2013 06:34:19 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4110 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ String Comparisons : Have you tried looking at the... http://www.ideablade.com/forum/forum_posts.asp?TID=4110&PID=16215#16215 Author: smi-mark
Subject: 4110
Posted: 12-Apr-2013 at 6:34am

Have you tried looking at the DebugLog or using SQL Profiler to look at the generated SQL? My guess is it's trimming off the space before it queries it.

Edit:

I've just tested some queries using LinqPad (http://drc.ideablade.com/devforce-2012/bin/view/Documentation/linqpad-driver)
and I'm not able to reproduce it. Have you tried doing a simple query like the below to see if this even works?

manager.EntityType.Where(e => e.Field == "Sy ");

Edited by smi-mark - 12-Apr-2013 at 6:39am]]> Fri, 12 Apr 2013 06:34:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4110&PID=16215#16215 String Comparisons : HiI am banging my head against... http://www.ideablade.com/forum/forum_posts.asp?TID=4110&PID=16214#16214 Author: murray.bryant
Subject: 4110
Posted: 12-Apr-2013 at 12:13am

Hi

I am banging my head against the wall with a problem.

It is to do with a string comparison not matching the string in an EntityQuery.

I am using the following code

PredicateDescription pd = PredicateBuilder.Make(

entityType, lookUpField, FilterOperator.IsEqualTo, lookUpValue);

query = EntityQuery.Create(entityType, Context).Where(pd);

pd.IgnoreCase = true;

retEntity = (Entity) query.FirstOrNullEntity();

My problem is occuring when the lookupValue is 'Sy ' as in Sy with a space following. trying to match the same in the database

This code does not find it.

However if I change the value and remove the space following it does find it. Even though in the database the data it is looking up does contain a space.

I am at a loss as to why this is happening I was hoping someone here would know.

thanks

Murray

]]> Fri, 12 Apr 2013 00:13:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4110&PID=16214#16214