Argh!

[the_gneech]

CFIndex and CFSearch are just sitting on my head and crushing it.

The code is right! I've triple-checked that the code is right. But the search is returning bizarre, almost-random results! It's swapping fields for no good reason (intProductID and chvPubID are having their values swapped for some records -- but not ALL!), and it's driving me up a wall!

If it was happening for ALL of my search results, I could just swap the variable names and be done with it -- but it's not! It works right on one, then screws up another, then works right on the next one, all on the same page!

ColdFusion MX has some major problems, my fellow geeks. Stick with version 5!

-The Gneech

Followup: Okay, I fixed it. But sheesh!

Comments

[shockwave77598.livejournal.com]

Oh, you fixed it. What was it? Enquiring mimes want to know...

[the-gneech.livejournal.com]

The "body" parameter of a CFIndex tag has to include all of the fields being indexed. I thought it only needed to include one.

Go fig! Would have been nice if the manual said so... ;)

-The Gneech

[torakiyoshi.livejournal.com]

Something as hideously simple as a missing semicolon? It cost me a whole letter grade in high school...

[the-gneech.livejournal.com]

Nope, it was a bit more complicated than that -- I reserve mistakes like that for BIG emergencies! ;) -TG

[level-head.livejournal.com]

It did sound like a key sequence specification problem; you've already resolved it, I see.

Good tune.

===|==============/ Level Head