RJ,
Direct DBMS:
SELECT (IHASH('@@local$TangoVarName',0)) FROM DUMMY
Results:
<@ASSIGN name=hashValue scope=local value="<@COL 1>">
Then do your Search Action with the ihashed index column = @@local
$hashValue and the text column = @@local$TangoVarName
Takes one extra hit against the database, but to a one-row table.
Bill
On Wed, 15 Aug 2001 18:01:18 -0700, RJ Hendrickson wrote:
>Wondering if there is some equivalent metatag in Tango which
performs a
>function similar to IHASH in R:Base. We've been playing with indexed
>IHASHed columns in R:Base lately, and the speed increase in
lookups is
>nothing short of phenomenal. I'd love to be able to apply this to our
>website search somehow. Anybody tried this?
