Here is a piece that works for me...
<cfquery name="GetPeopleInfoByName" datasource="#Session.datasource#">
SELECT DirPerson.PersonID, DirPerson.isOffice, {fn CONCAT (FirstName, {fn
CONCAT (' ', LastName)})} AS Name
FROM DirPerson
WHERE DirPerson.PersonID > #LastByName#
</cfquery>
<cfif GetPeopleInfoByName.RecordCount GT 0>
<cfindex action="#action#"
collection="PeoplefinderByName_for_#Session.datasource#"
key="PersonID"
custom1="PersonID"
custom2="isOffice"
type="CUSTOM"
title="Name"
query="GetPeopleInfoByName"
body="Name">
</cfif>
<Jaime/>
> -----Original Message-----
> From: J.Milks [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 12, 2000 1:07 PM
> To: CF-Talk
> Subject: Re: Begging now...
>
>
> <CFINDEX COLLECTION="#Session.intCategory#" TYPE="Path"
> ACTION="#txtProcess#"
>
> KEY="#Application.Library##qryGetCustID.intCustomer#\#SESSION.intS
> ite#\#Sess
> ion.intCategory#"
> CUSTOM1="#qryGetCatDetails.intCategory#"
> CUSTOM2="#Session.intCategory#"
> TITLE="#qryGetCatDetails.intCategory#"
> RECURSE="Yes"
> EXTENSIONS=".htm, .html, .cfm, .cfml, *., .doc, .wpd, .xls,
> .txt, .text,
> .pdf">
>
> Hope this helps...
>
> Jim
> ----- Original Message -----
> From: "Hayes, David" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, October 12, 2000 3:56 PM
> Subject: RE: Begging now...
>
>
> > I've used them successfully; show us some code.
> >
> > -----Original Message-----
> > From: J.Milks [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, October 12, 2000 2:58 PM
> > To: CF-Talk
> > Subject: Begging now...
> >
> >
> > This is a multi-part message in MIME format.
> >
> > ------=_NextPart_000_0157_01C03465.3FA20D60
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > Hi,
> > I posted a question about how to use Verity's Custom1 and Custom2 =
> > fields. I have tried to populate them with query results, hard coded =
> > values and more, all with no luck. The files are indexing
> correctly and =
> > in the search results, I can get the URL, Key, etc., but the
> CUSTOM1 and =
> > CUSTOM2 fields are empty.
> >
> > Any ideas?
> >
> > Jim
> >
> > ------=_NextPart_000_0157_01C03465.3FA20D60
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > <HTML><HEAD>
> > <META http-equiv=3DContent-Type content=3D"text/html; =
> > charset=3Diso-8859-1">
> > <META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
> > <STYLE></STYLE>
> > </HEAD>
> > <BODY bgColor=3D#ffffff>
> > <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2>I posted a question about how to use =
> > Verity's=20
> > Custom1 and Custom2 fields. I have tried to populate them with query =
> > results,=20
> > hard coded values and more, all with no luck. The files are indexing =
> > correctly=20
> > and in the search results, I can get the URL, Key, etc., but
> the CUSTOM1 =
> > and=20
> > CUSTOM2 fields are empty.</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> > <DIV><FONT face=3DArial size=3D2>Any ideas?</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> > <DIV><FONT face=3DArial size=3D2>Jim</FONT></DIV></BODY></HTML>
> >
> > ------=_NextPart_000_0157_01C03465.3FA20D60--
> >
> >
> --------------------------------------------------------------------------
> --
> > --
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> > send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in
> > the body.
> >
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
