N
Neil
Hi folks
I've made an .aspx page from which I'm searching for records made from a
form containing a rich text field. My problem is that apparently the records'
rich text field isn't searchable. According to
http://msdn2.microsoft.com/en-us/library/bb290884.aspx a query like the ones
below should be "Valid for string and rich text fields."
txtTitle is a plain text field and in my test record contains the word
'title'.
txtDescription is a rich text field and in my test record contains the word
'description'.
The first query returns my test record, like it should.
whereClause = "ddlDocumentType = 'IT' AND (txtTitle LIKE '%title%' OR
txtDescription LIKE '%title%' OR txtKeyworks LIKE '%title%')"
The second query does not return my test record. It should.
whereClause = "ddlDocumentType = 'IT' AND (txtTitle LIKE '%description%' OR
txtDescription LIKE '%description%' OR txtKeyworks LIKE '%description%')"
I've tested this on other records than my test record and it doesn't work.
Does anybody have any ideas?
Thanks in advance
Neil
P.S. Shouldn't there be a group for question to the Groove SDK?
I've made an .aspx page from which I'm searching for records made from a
form containing a rich text field. My problem is that apparently the records'
rich text field isn't searchable. According to
http://msdn2.microsoft.com/en-us/library/bb290884.aspx a query like the ones
below should be "Valid for string and rich text fields."
txtTitle is a plain text field and in my test record contains the word
'title'.
txtDescription is a rich text field and in my test record contains the word
'description'.
The first query returns my test record, like it should.
whereClause = "ddlDocumentType = 'IT' AND (txtTitle LIKE '%title%' OR
txtDescription LIKE '%title%' OR txtKeyworks LIKE '%title%')"
The second query does not return my test record. It should.
whereClause = "ddlDocumentType = 'IT' AND (txtTitle LIKE '%description%' OR
txtDescription LIKE '%description%' OR txtKeyworks LIKE '%description%')"
I've tested this on other records than my test record and it doesn't work.
Does anybody have any ideas?
Thanks in advance
Neil
P.S. Shouldn't there be a group for question to the Groove SDK?