Francisco,
It is possible to use more than value for custom1 and custom2. When you
write the query
that creates your index,use aggregate functions to build a list of those
values. Then use listgetat() to build your <a href>.
<CFQUERY name="foo" datasource="#dsn#">
Select field1+ ',' + field2 as fieldlist.....
..
<cfquery>
<cfindex custom1=#fieldlist#........>
<a href="......whatever=#Listgetat(custom1,1)#
I don't have my exact code in front of me that
works but this is the idea and the only concern is that you watch
performance if you add too many fields to the list.
-----Original Message-----
From: Francisco Montes; Spain on Line [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 1:30 AM
To: [EMAIL PROTECTED]
Subject: CFSEARCH and CUSTOM fields
This is a multi-part message in MIME format.
------=_NextPart_000_0071_01BFEFD9.F8721130
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I wonder if someone else had this "little" problem with Verity and the =
CUSTOM1 and CUSTOM2 fields returned after a CFSEARCH.
I don=B4t know if it can be possible. I just want to go into more detail =
on a verity results page, that is, for every resource i show as a result =
i want to show more information about it than just the Name and the id =
from a table to retrieve it at a later time.
For example a resource can have several properties that are represented =
with little icons. If they were two i could use both custom fields to =
store them... but what if i want to store more than two? or even =
something else? Is there a way of encoding a "list" of values to put in =
these custom fields in order to retrieve all the information i want in a =
results page without actually having to make an extra query to get it?
Comments?
Francisco J. Montes
------=_NextPart_000_0071_01BFEFD9.F8721130
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>Hi,</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>I wonder if someone else had this=20
"little" problem with Verity and the CUSTOM1 and CUSTOM2 =
fields=20
returned after a CFSEARCH.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>I don´t know if it can be =
possible. I just=20
want to go into more detail on a verity results page, that is, for every =
resource i show as a result i want to show more information about it =
than just=20
the Name and the id from a table to retrieve it at a later =
time.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>For example a resource can have =
several=20
properties that are represented with little icons. If they were two i =
could use=20
both custom fields to store them... but what if i want to store =
more than=20
two? or even something else? Is there a way of encoding a =
"list" of=20
values to put in these custom fields in order to retrieve all the =
information i=20
want in a results page without actually having to make an extra query to =
get=20
it?</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>Comments?</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>Francisco J. Montes</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0071_01BFEFD9.F8721130--
----------------------------------------------------------------------------
--
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.
