Split then Sort

wdavies · Post by **wdavies** » Thu Mar 07, 2002 4:23 pm

So I can't get this to work...

It just prints out the first item of the list.
SearchPhrase should contain
"blue yellow red"
and I want it to return
the list

"blue" "red " "yellow"

Cheers,
Winton

<sql $sqlcommand>
START: $SEARCHPHRASE
<split " " $SEARCHPHRASE>
<$SEARCHPHRASE = $ret >
<sort $SEARCHPHRASE>
<$SEARCHPHRASE = $ret >
<LOOP $SEARCHPHRASE>
$SEARCHPHRASE
</LOOP>
END
</sql>

wdavies · Post by **wdavies** » Thu Mar 07, 2002 4:27 pm

Oh well this seems to work. Go figure

Post by **mark** » Thu Mar 07, 2002 10:15 pm

There could be an issue if SEARCHPHRASE is one of the fields selected in your sql statement. If so, use some other variable name after splitting it.

Post by **John** » Fri Mar 08, 2002 9:23 am

Assuming that $SEARCHPHRASE came from your SQL statement you are looping over the results, building up the array $SEARCHPHRASE, so you can only see a single element of the $SEARCHPHRASE array. Your much shorter and simpler form avoided reassigning a list to a single element of $SEARCHPHRASE.

You might also want <sql ROW> to avoid keeping all the results in memory.