SQLite: How to select only one field?

[fielmann]

SQLite: How to select only one field?

I could only realize it with: _SQLite_QuerySingleRow

#include <SQLite.au3>
#include <SQLite.dll.au3>
Local $aRow
_SQLite_Startup()
_SQLite_Open("..\sqlite\database.db")

$SQL = "select field from table where id=100"

_SQLite_QuerySingleRow(-1,$SQL,$aRow)

MsgBox(0,"SQL-Result:",$aRow[0])

_SQLite_Close()
_SQLite_Shutdown()

Is there a simple way to read out only one field?

Edited December 20, 2008 by fielmann

[ChrisL]

Try that

$SQL = "select field from table where id=100 LIMIT 1"

[fielmann]

Try that

$SQL = "select field from table where id=100 LIMIT 1"

id=100 is already unique!

so I get always back one result.

Can anybody send me an example how to realize?