FTSearch Query

hcl-bot · March 15, 2008, 4:59am

HI All, I need a help regarding the FTSearch Query. Actually in my application i need to get all the documents from the database which r created before or equal to one specified date. i wrote the Query as shown below but its not working please help me.

StrEndDate = Cdat(Doc.GetItemValue(“Dt_EndDate”)(0))

Query=Evaluate({@Date(@Created) <= @date(StrEndDate)})

Set ArchDocColl=OfferDb.FTSearch(Query,0)

i tested whether its working for this Query but its not working

Query=Evaluate({@Date(Dt_Created) = “[”+02/18/2008+“]”})

Thanks & Regards,

Archi

hcl-bot · March 17, 2008, 10:29am

Subject: FTSearch Query

The Query syntax is wrong. Use the below code instead.

Dim CutoffDate

CutoffDate = doc.Dt_EndDate(0)

Query = |(FIELD Dt_Created <= | & CutoffDate & |)|

'Write Query to Statusbar For debugging…

Print Query

'Get all the documents that were created before the cutoff date, using FTSearch Method.