in reply to
Re: getting 0 to print
in thread getting 0 to print
I have to disagree with you.
The fact the data is coming from a database is very
relevant and key to the solution to this problem.
Instead of trying to output the data coming from the query:
select * from $table
... I decided to deal with the formatting of the output
in SQL like so ...
select $cols from $table
... where $cols is built up with ltrim, rtrim and ||
and the previous query. $cols for this particular
example would look like this ...
ltrim(rtrim(VALUE)) || '|' || ltrim(rtrim(DESCRIPTION)) || '|'
Thanks for your input anyways.
Sorry your meta-help couldn't of been of more use.