|Welcome to the Monastery|
Re: Re: getting 0 to printby rbc (Curate)
|on Jan 13, 2003 at 21:32 UTC||Need Help??|
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.