Current time: 01-28-2021, 08:05 PM Hello There, Guest! (LoginRegister)

Post Reply 
 
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Query Search Time
08-25-2010, 02:54 AM
Post: #43
RE: Database Query Search Time
Stay tuned! I just found out that you can create a query of file names/paths and make that field the body="" value and cfindex will index the file content.

Code:
    <cfindex  
        query="getAttachments"
        collection="#attributes.theCaseCollection#"
        action="update"
        type="file"
        key="FileKey"    
        title="Contract_File"
        category="Attachments"
        categorytree="UserRealName"
        custom1="CaseFileID"
        custom2="CaseFileName"
        custom3="DateInserted"
        custom4="CaseStatus"
        body="FileKey"
        status="indxResults">

Tried it and it works... I will do some more testing later today.
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Database Query Search Time - pmeenan - 07-04-2010, 12:03 PM
RE: Database Query Search Time - pmeenan - 07-05-2010, 04:35 AM
RE: Database Query Search Time - sajal - 07-05-2010, 05:03 AM
RE: Database Query Search Time - pmeenan - 07-08-2010, 08:47 PM
RE: Database Query Search Time - sajal - 08-13-2010, 10:06 PM
RE: Database Query Search Time - sajal - 08-14-2010, 03:38 AM
RE: Database Query Search Time - sajal - 08-14-2010, 06:50 AM
RE: Database Query Search Time - pmeenan - 08-16-2010, 02:55 AM
RE: Database Query Search Time - sajal - 08-17-2010, 01:14 AM
RE: Database Query Search Time - pmeenan - 08-23-2010, 01:22 AM
RE: Database Query Search Time - pmeenan - 08-23-2010, 08:45 PM
RE: Database Query Search Time - ringman57 - 08-24-2010, 11:52 PM
RE: Database Query Search Time - ringman57 - 08-25-2010 02:54 AM

Forum Jump:


User(s) browsing this thread: 2 Guest(s)