This content has been marked as final. Show 4 replies
I am just adding additionnal informations for the problem.
Using these mutiple CFINDEXING, make that for a same table (ans same datasoource)
some text are retrived , and some others NO !
I do not understand why ?
Is there any body from Adobe, or ex Macromedia who could help on this question ?
Thanks to all.
Did you ever figure this out? I'm having very similar problems.
Does it work fine if you do them in seperate CFMs?
I am still trying to understand that problem with multiple cfindex,
I think I unsderstand something :
If I first do a cfindex on a query 1 : it keeps the record keys
when running a second cfindex, if the key found have the same value (from another table)
it takes the last , and the first found in first cfindex is lost.
So how to use the "key" in cfindex to work with multiple cfindex with different cfquery ?
This is what I am looking for now.
Thanks for any help.
Adobe people do not care of this Forum ? why did they buy ColdFusion ?
I finally found the solution,
the keys found in all CFindex must be different.
So if I use an primary key for the key, which is a numeric,
there is a chance to find the same number with different cfindex,
So the key of cfindex should refer to table column which have different data (unic).
It better to refer to a field containing text than a numeric.
Text have more chance to be different.