Category Box

KMandalia · Post by **KMandalia** » Tue Jul 20, 2004 3:19 pm

I have set up several categories in all walk settings. Now in the <summary> function I am printing the category by referencing it as $Category. It always returns the first category even though I change the category via category box.

What am I doing wrong?

Post by **mark** » Tue Jul 20, 2004 3:52 pm

In the search form the Category box's input variable name is cq, not Category. That's a number that you need to convert to a name for display.
<sql "select Category from categories where Catno=$cq"></sql>

KMandalia · Post by **KMandalia** » Tue Jul 20, 2004 4:55 pm

Well, I do know that. If I change $Category to $cq, it gives me correct category number. I use the sql statement you wrote to get Category corresponding to cq and always get the first category, also the $indexcount doesn't work then.

$start through $end of <fmt " %kd " $indexcount> records for "$query" on $Category.

Post by **mark** » Tue Jul 20, 2004 5:11 pm

Not sure why you would expect more than one category in that case. I would only expect the matching one. Are you saying you're getting the same category no matter what the value of $cq is?

In general to print all values of a vortex variable you need to loop over it:
<loop $Category>
$Category
</loop>

By doing your sql inside the main sql you've lost indexcount. Do your sql before the main search sql and save the result in another variable for use later in the summary function.

KMandalia · Post by **KMandalia** » Tue Jul 20, 2004 5:30 pm

Thanks for your help. I got it.