Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#276 SqlTool - Displaying results with line breaks

open
nobody
tools (21)
5
2012-03-20
2012-03-20
James Housley
No

Let's say I have a table with a column that contains some HTML:

<table>
<td>aaa</td>
</table>

At the moment, if I do a SELECT on this table, the results will look like this:

NUMBER HTML
------ -------
1 <table>
<td>aaa</td>
</table>
2 <table>
<td>bbb</td>
</table>

whereas ideally, I'd want it to be formatted as:

NUMBER HTML
------ -------
1 <table>
<td>aaa</td>
</table>
2 <table>
<td>bbb</td>
</table>

(This description might make more sense if viewed in a fixed-width font).

Discussion

  • James Housley
    James Housley
    2012-04-24

    It appears the spacing has been stripped out of my description. The two sets of results should look like this, using underscores in place of the spaces:

    NUMBER_HTML
    ------_-------
    _____1_<table>
    <td>aaa</td>
    </table>
    _____2_<table>
    <td>bbb</td>
    </table>

    NUMBER_HTML
    ------_-------
    _____1_<table>
    _______<td>aaa</td>
    _______</table>
    _____2_<table>
    _______<td>bbb</td>
    _______</table>

    (Again, this will make more sense in a fixed-width font)