Scripting/Squirrel/Functions/GetSQLColumnData

From Vice City Multiplayer
Revision as of 10:37, 11 March 2016 by Ysc3839 (talk | contribs)
Jump to navigation Jump to search
Caution icon
This wiki is using an old backup from 2020
Some information may be old/missing

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