Hi, I have a problem with the fulltext search, both from lotusscript than from the client.
In 3 docs I have a field with the value 30789,80981111 ; in other 3 docs I have a field with the value 30789,80973322 .
They are text 16 bit, If I search for 30789,809444 I have back all these 6 documents while expecting none, What is wrong??
Thanks in advance.
Subject: my guess is the comma acts as a delimeter
therefore, 30789 is found in all.
to prove the theory, create a doc with a different first 5 digits and try again.
Subject: RE: my guess is the comma acts as a delimeter
Thanks for the precious suggestion.
Whitout comma is working good and with only few work my problem is solved, but if i must look for values that has commas? is there a way to specify an escape character or something similar?
Tks.
Subject: try putting quotes around the search field
if not, maybe convert the document value to numeric would work.
Subject: RE: try putting quotes around the search field
Thanks a lot.Doublequoting was enough.