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

#206 HTML, live links in SQL worksheet results grid

open
nobody
None
5
2012-12-13
2003-07-30
Bobby O
No

For data-mining, data inspection, & also inspecting
database-backed cgi/web-pages:

Option to display SQL worksheet results-grid in html.

Initially, it would be sufficient to allow URLs to be
detected & converted into links that would be be
launched in the default browser by clicking on them
(e.g. field TEXT_URL with contents
http://localhost/cgi-bin/genomebrowser?position=chr22%3A15573184-15600411
becomes a clickable link). (As in many wordprocessors &
email programs, which auto-convert URLs & email
addresses into hyperlinks).

Perhaps even more easily, just allowing the SQL
Worksheet query-results pane to display results in the
formats it can export would be sufficient. E.g. set SQL
worksheet display mode to HTML, and display the same
HTML table that can be generated when exporting data
from TOra. (So field HTML_URL with contents <a
href="http://localhost/cgi-bin/genomebrowser?position=chr22%3A15573184-15600411">GENE
USP18</a> becomes a clickable link)

The above would allow users to write SQL queries that
both generate lists of sumary/statistical results from
a database, plus URLs to lists of files or graphical
web-pages of the results, and thus make it very quick
to inspect large numbers of results.

Discussion