[ic] coordinated search and cs=0

[maillists <suppressed>]

Hi,

I'm trying to get a coordinated search to be case insensitive. I thought
that it would be the default, but no matter what I do, it only returns
records that match case.

In my test table, I have a record with the following values
fieldtosearch=testvalue pending=0 inactive=0. 
Also "fieldtosearch" is the primary key.

The following search returns nothing at all:

[loop
  prefix=test_select
  list_prefix=test_select_list
  search="
  fi=test
  st=db
  co=1
  sf=fieldtosearch
  cs=0
  se=TeStVaLuE
  op=eq
  nu=0
  sf=pending
  cs=0
  se=0
  op=eq
  sf=inactive
  cs=0
  se=0
  op=eq
"]
[test_select_list]
  fieldtosearch: [test_select-data test fieldtosearch]
[/test_select_list]
[/loop]


The next following code works perfectly:

[loop
  prefix=test_select
  list_prefix=test_select_list
  search="
  fi=test
  st=db
  co=1
  sf=fieldtosearch
  cs=0
  se=testvalue
  op=eq
  nu=0
  sf=pending
  cs=0
  se=0
  op=eq
  sf=inactive
  cs=0
  se=0
  op=eq
"]
[test_select_list]
  fieldtosearch: [test_select-data test fieldtosearch]
[/test_select_list]
[/loop]


The following non-coordinated search also works perfectly:

[loop
  prefix=test_select
  list_prefix=test_select_list
  search="
  fi=test
  st=db
  cs=0
  sf=fieldtosearch
  se=TeSTvaLuE
  op=eq
"]
[test_select_list]
  fieldtosearch: [test_select-data test fieldtosearch]
[/test_select_list]
[/loop]


What is going on. I am obviously missing something.
Can anybody help?

Thanks
Rick

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users