SQLite, HTML output and some comparsion

Multimedia Builder

SQLite, HTML output and some comparsion

Postby Nigg » Mon Mar 20, 2017 5:44 pm

Hey guys,

I have some database here:

Code: Select all
html_file$ = '<SrcDir>\table.html'
SQL$ = 'SELECT some_id, some_other_id, some_name, some_info FROM blah;'



I fetch the information from SQLite and then I do some text-file HTML output with the database entries:

Code: Select all
  For i=1 To Rows
    Rows$[i] = GetArrayItem(Results$,Delimiter$,i)
    Rows$[i] = Rows$[i] + '|'
    NumberOfFields = GetArrayNum(Rows$[i],|)
    ***
    some_id$ = GetArrayItem(Rows$[i],|,1)
    some_other_id$ = GetArrayItem(Rows$[i],|,2)
    some_name$ = GetArrayItem(Rows$[i],|,3)
    some_info$ = GetArrayItem(Rows$[i],|,4)
    ***
    html_line1$ = '<tr>'
    html_line2$ = '<td>' + some_id$ + '</td>'
    html_line3$ = '<td>' + some_other_id$ + '</td>'
    html_line4$ = '<td>' + some_name$ + '</td>'
    html_line5$ = '<td>' + some_info$ + '</td>'
    html_line6$ = '</tr>'
    ***
    ReturnVal=StrToLine(html_file$, html_line6$, 2, FALSE)
    ReturnVal=StrToLine(html_file$, html_line5$, 2, FALSE)
    ReturnVal=StrToLine(html_file$, html_line4$, 2, FALSE)
    ReturnVal=StrToLine(html_file$, html_line3$, 2, FALSE)
    ReturnVal=StrToLine(html_file$, html_line2$, 2, FALSE)
    ReturnVal=StrToLine(html_file$, html_line1$, 2, FALSE)
  Next i


<snip>

Now I want to realize a comparison with some registry values. In the Windows registry, I have some variables like:

some_id_53 with value 1 .. but at this moment, I dont know their names.

The comparison-code should do something, if there exists a variable in registry in relation to one or more SQLite query results. For example, changing the HTML output:

Code: Select all
html_line2$ = '<td color="red">' + some_id$ + '</td>'



Any ideas how to achieve that?
Nigg
 
Posts: 39
Joined: Thu Apr 14, 2011 2:10 pm

Re: SQLite, HTML output and some comparsion

Postby zzoff » Wed Mar 29, 2017 12:27 pm

Try fetch registry entries with some of plugins...
zzoff
 
Posts: 1
Joined: Fri Oct 22, 2010 2:46 pm

Re: SQLite, HTML output and some comparsion

Postby Nigg » Thu Mar 30, 2017 1:54 am

I thought about a plugin, but I don't know one which is able to do that
Nigg
 
Posts: 39
Joined: Thu Apr 14, 2011 2:10 pm

Re: SQLite, HTML output and some comparsion

Postby Nigg » Sun Apr 09, 2017 6:57 am

Delboy, dgilmour, maybe you guys have an idea?
Nigg
 
Posts: 39
Joined: Thu Apr 14, 2011 2:10 pm

Re: SQLite, HTML output and some comparsion

Postby CodeHouse » Mon Apr 17, 2017 10:33 am

Use Plugy Plugin for registry manipulation and of course the Almighty SmallPlugin by dgilmour.
Attachments
mbd.rar
(115.05 KiB) Downloaded 69 times
plugy.rar
(102.28 KiB) Downloaded 75 times
CodeHouse
 
Posts: 294
Joined: Sun Aug 14, 2011 12:33 am

Re: SQLite, HTML output and some comparsion

Postby Nigg » Thu Apr 20, 2017 4:12 pm

Thanks CodeHouse!! I've never heard of "plugy" before. It works!
Nigg
 
Posts: 39
Joined: Thu Apr 14, 2011 2:10 pm

Re: SQLite, HTML output and some comparsion

Postby CodeHouse » Mon Apr 24, 2017 4:03 am

Nigg wrote:Thanks CodeHouse!! I've never heard of "plugy" before. It works!


Glad, plugy is a great plugin
CodeHouse
 
Posts: 294
Joined: Sun Aug 14, 2011 12:33 am


Return to MMB

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

cron