Re: ILLUSTRA-SQL

> Is it possible to detect an End-Of-Line in a $var selected by an SQL > ORDER ? > > To do something like this : > > <?MISQL SQL="select ... > from .... > $(SETVER,$var,$1) > <?/MISQL> > <?MIVAR DELIMIT="End-Of-Line??" REP'LACE="<BR>"> > $vat > <?MIVAR> > Hi I would do something like this: (create $var with <BR> attached at the end) STEP 1 :define varaible '$linebreak', with the value of the html code <?MIVAR NAME="linebreak"><BR><?/MIVAR> STEP 2 :define your variable '$var' as '$1' conca tinated with the '$linebreak' variable <?MISQL SQL="select ... from .... where ... ;"> $(SETVAR,$var,$1$linebreak) <?/MISQL> STEP 3 : display the endresult <?MIVAR>Display variable var with linebreak: $var<?/MIVAR> I hope this is what you are looking for. regards Micha Haas