Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FTSearch & Syntax

Status
Not open for further replies.
mutancik

mutancik

Programmer
Joined
Dec 8, 2002
Messages
3
Location
PL
Hello!

I have a question ... about FTSearch. i try to find sh on this form but solutions which I found doesn't work ...

I have agent which should find some docs, which are filtered by "Profile document"


Everything work great beside my search formula :-)

when i set:

searchFormula$ = {Form = "ala"} then it finds all docs, and it is good but when i try to use profile document then I have errors or don't find any documents

Firma$=profile.RP_Firma(0)
I tried:

searchFormula$ = {FIELD FIRMA_1 CONTAINS } + {"} & Firma$ & {"}
searchFormula$ = {FIELD FIRMA_1 CONTAINS }+Firma$
searchFormula$ = " [FIRMA_1] = "+Firma$+" "
searchFormula$ = " [FIRMA_1] =Firma$ "

these don't work....

If you know any solution, I will appreciate ....

Joanna
 
Sort by date Sort by votes
Your first searchFormula works fine in a test of mine!
I will test the others tomorrow but its not seems correct.
Ask yourself some question:
- Is my db correctly indexed ?
- Firma$ contains a rigth value for the search or contains some wrong char (i.e. some spaces)? (use the debugger to verify it)
- In the FT index of the db there is difference from upper and lower case ? If so, Firma$ is right capitalized?
And, finally, the last important question I ask to you:
You're using FTSearch from Notesdatabase, Notesview, Notesdocumentcollection or NotesViewEntryCollection class?
Let me know and we'll find a solution.


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

pechettysuguna
  • Locked
  • Question Question
Disable default double Click on form and document & save prompt
Replies
2
Views
352
pechettysuguna
pechettysuguna
mutancik
  • Locked
  • Question Question
dash & export to excel ....
Replies
1
Views
161
mutancik
mutancik
lespaul
  • Locked
  • Question Question
Frames & Framesets - controlling content
Replies
1
Views
149
nicusor
nicusor
tess25
  • Locked
  • Question Question
Adding a date & time columns to inbox in lotus notes
Replies
2
Views
234
apinkerton
apinkerton

Part and Inventory Search

Sponsor

Back
Top