Scripting/Squirrel/Functions/GetSQLColumnData: Difference between revisions
Jump to navigation
Jump to search
This wiki is using an old backup from 2020
Some information may be old/missing
No edit summary |
No edit summary |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 15: | Line 15: | ||
== Example == | == Example == | ||
<source lang= | <source lang=lua>local db = ConnectSQL( "db.db" ); | ||
local query = QuerySQL( db, "SELECT Cash FROM Accounts WHERE Name='KAKAN'" ); | local query = QuerySQL( db, "SELECT Cash FROM Accounts WHERE Name='KAKAN'" ); | ||
if ( query ) { | if ( query ) { | ||
local data = GetSQLColumnData( query, 0 ); | local data = GetSQLColumnData( query, 0 ); | ||
if( data ) print( "KAKAN has " + | if( data ) print( "KAKAN has " + data + "$" ); | ||
FreeSQLQuery( query ); | FreeSQLQuery( query ); | ||
}</source> | }</source> | ||
== Related Functions == | |||
{{Scripting/Squirrel/Functions/SQLite Functions}} | |||
[[Category:Scripting/Squirrel/Functions/SQLite _Functions]] | |||
Latest revision as of 08:00, 20 July 2019
Get a result row as a string.
Syntax
GetSQLColumnData( query, columnNumber )
Arguments
- query - Name of the previously executed query.
- columnNumber - Number of the column you want to get data of.
Return value
- The data in the column and/or null on failure
Example
local db = ConnectSQL( "db.db" );
local query = QuerySQL( db, "SELECT Cash FROM Accounts WHERE Name='KAKAN'" );
if ( query ) {
local data = GetSQLColumnData( query, 0 );
if( data ) print( "KAKAN has " + data + "$" );
FreeSQLQuery( query );
}