Scripting/Squirrel/Functions/GetSQLColumnData: Difference between revisions

From Vice City Multiplayer
Jump to navigation Jump to search
Caution icon
This wiki is using an old backup from 2020
Some information may be old/missing
No edit summary
No edit summary
Line 22: Line 22:
FreeSQLQuery( query );
FreeSQLQuery( query );
}</source>
}</source>
== Related Functions ==
{{Scripting/Squirrel/Functions/SQLite Functions}}
[[Category:Scripting/Squirrel/Functions/SQLite _Functions]]

Revision as of 19:01, 30 January 2017

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

Related Functions