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 |
||
| 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 ) { | ||
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 );
}