Searching RTF fields using GrooveForms2.QueryRecords()

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top