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 19: | Line 19: | ||
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> | ||
Revision as of 10:37, 11 March 2016
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 );
}