I suppose you COULD get rid of the \n in the query.... Its a Linux thing. *sigh*
On Fri, Oct 19, 2018 at 10:50 AM Stephen Chrzanowski <pontia...@gmail.com> wrote: > This would be something you'd need to write something quick for. There's > no application in the world that knows how to use your specific schema and > react to it. There may be apps that will read the values and automatically > 'understand' that http:// and https:// are addresses, but, these probably > are custom built applications that do something completely different to > what you're doing. I've just checked with SQLite Expert, and it doesn't > have any knowledge of how to treat a field as a URL/URI. > > That said, you may be able to get an ugly query going, and dump it to an > HTML file you can bring up in your browser. > > My example table: > CREATE TABLE [Test]( [TestID] INTEGER, [Name] CHAR, [Address] URL); > INSERT INTO [Test]([TestID], [Name], [Address]) VALUES(1, 'Google', ' > http://www.google.com'); > INSERT INTO [Test]([TestID], [Name], [Address]) VALUES(2, 'YouTube', ' > http://www.youtube.com'); > > Then execute SQLite3.exe like this: > > R:\>c:\myapps\sqlite3.exe > SQLite version 3.20.0 2017-08-01 13:24:15 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> .open TestDB.db3 > sqlite> .output test.html > sqlite> select '<a href="'||Address||'">'||Name||'</a><br>\n' from Test; > sqlite> .quit > > R:\>type test.html > <a href="http://www.google.com";>Google</a><br>\n > <a href="http://www.youtube.com";>YouTube</a><br>\n > > (R: for me is a RamDRIVE) > > > > On Fri, Oct 19, 2018 at 10:03 AM Winfried <codecompl...@free.fr> wrote: > >> Hello, >> >> I have a bunch of hyperlinks in an SQLite database, and need to read each >> page for validation before deleting the record. >> To make it easier, the DB manager should launch the default web browser >> when >> I double click on a column that contains a hyperlink. >> >> Before I build a GUI, is there a Windows SQLite database manager that can >> do >> this? >> >> I tried DB Browser for SQLite, SQLitespeed, and SQLiteStudio, but none >> seems >> to support this feature. >> >> Thank you. >> >> >> >> -- >> Sent from: http://sqlite.1065341.n5.nabble.com/ >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
