Sqlite question

[torels]

hi there

I have a question...

how do I get the content of a single column in sqlite ?

thanks in advance

torels_

[PsaltyDS]

hi there

I have a question...

how do I get the content of a single column in sqlite ?

thanks in advance

torels_

Specify the name of the column in the query. For example, to get all columns of all rows, you would query "Select * From TableName". To get just the column PhoneNum you would replace "*" with the column name and query "Select PhoneNum From TableName".

[torels]

Specify the name of the column in the query. For example, to get all columns of all rows, you would query "Select * From TableName". To get just the column PhoneNum you would replace "*" with the column name and query "Select PhoneNum From TableName".

I got it!

I wrote this for the moment...

#include <sqlite.au3>
#include <sqlite.dll.au3>
Local $hQuery,$aRow
_SQLite_Startup()
_SQLite_Open(@ScriptDir & "\artists.db")
_SQLite_Exec(-1,"Create table Songs (Title not null, mp3Path not null, LyricPath not null);" & _
                "Insert into Songs values ('abb','C:\Foo.mp3','C:\foo.txt');" & _
                "Insert into Songs values ('slipknot - before I forget','C:\bif.mp3','C:\bif.txt');")
$d = _SQLite_Exec(-1, "Select Songs.Title From Songs;", "_result")
Func _result($aRow)
    For $s In $aRow
        ConsoleWrite($s & @TAB)
    Next
    ConsoleWrite(@LF)
EndFunc
_SQLite_Close()
_SQLite_Shutdown()

It's the beginning of a lyrics/karaoke program XD

[PsaltyDS]

I got it!

I wrote this for the moment...

#include <sqlite.au3>
#include <sqlite.dll.au3>
Local $hQuery,$aRow
_SQLite_Startup()
_SQLite_Open(@ScriptDir & "\artists.db")
_SQLite_Exec(-1,"Create table Songs (Title not null, mp3Path not null, LyricPath not null);" & _
                "Insert into Songs values ('abb','C:\Foo.mp3','C:\foo.txt');" & _
                "Insert into Songs values ('slipknot - before I forget','C:\bif.mp3','C:\bif.txt');")
$d = _SQLite_Exec(-1, "Select Songs.Title From Songs;", "_result")
Func _result($aRow)
    For $s In $aRow
        ConsoleWrite($s & @TAB)
    Next
    ConsoleWrite(@LF)
EndFunc
_SQLite_Close()
_SQLite_Shutdown()

It's the beginning of a lyrics/karaoke program XD

You got it.

You don't have to specify the table with "Songs.Title"; that query will work the same as "Select Title From Songs". But it works either way.

[torels]

Ok thanks!

[2words4uready]

YES! I Hacked that Idiot of 127.0.0.1 !

Lmao

My friend said he bet he could hack my computer. He asked for my IP and i said its

127.0.0.1