Scripting/Squirrel/Functions/GetSQLColumnData - Revision history

NicusorN5 at 08:00, 20 July 2019

2019-07-20T08:00:58Z

← Older revision		Revision as of 08:00, 20 July 2019
Line 15:		Line 15:
	== Example ==		== Example ==

	<source lang=~~squirrel~~>local db = ConnectSQL( "db.db" );		<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 ) {

Thijn at 19:01, 30 January 2017

2017-01-30T19:01:52Z

← Older revision		Revision as of 19:01, 30 January 2017
Line 22:		Line 22:
	FreeSQLQuery( query );		FreeSQLQuery( query );
	}</source>		}</source>

			== Related Functions ==

			{{Scripting/Squirrel/Functions/SQLite Functions}}
			[[Category:Scripting/Squirrel/Functions/SQLite _Functions]]

Ysc3839 at 10:37, 11 March 2016

2016-03-11T10:37:56Z

← Older revision		Revision as of 10:37, 11 March 2016
Line 19:		Line 19:
	if ( query ) {		if ( query ) {
	local data = GetSQLColumnData( query, 0 );		local data = GetSQLColumnData( query, 0 );
	if( data ) print( "KAKAN has " + e + "$" );		if( data ) print( "KAKAN has " + data + "$" );
	FreeSQLQuery( query );		FreeSQLQuery( query );
	}</source>		}</source>

Ysc3839 at 10:35, 11 March 2016

2016-03-11T10:35:52Z

← Older revision		Revision as of 10:35, 11 March 2016
Line 15:		Line 15:
	== Example ==		== Example ==

	<~~pre~~>local c = ConnectSQL("db.db");		<source lang=squirrel>local db = ConnectSQL( "db.db" );
	local d = QuerySQL(c,"SELECT Cash FROM Accounts WHERE Name='KAKAN'")~~, e~~ = GetSQLColumnData( d, 0 );		local query = QuerySQL( db, "SELECT Cash FROM Accounts WHERE Name='KAKAN'" );
	if( e ) print( "KAKAN has " + e + "$" );		if ( query ) {
	</~~pre~~>		local data = GetSQLColumnData( query, 0 );
			if( data ) print( "KAKAN has " + e + "$" );
			FreeSQLQuery( query );
			}</source>

KAKAN: Created page with "Get a result row as a string. == Syntax ==

GetSQLColumnData( query, columnNumber )

== Arguments == * '''query''' - Name of the previously executed query. * ''..."

2016-03-05T08:35:38Z

Created page with "Get a result row as a string. == Syntax == <pre>GetSQLColumnData( query, columnNumber )</pre> == Arguments == * '''query''' - Name of the previously executed query. * ''..."

New page

Get a result row as a string.

== Syntax ==

<pre>GetSQLColumnData( query, columnNumber )</pre>

== 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 ==

<pre>local c = ConnectSQL("db.db");
local d = QuerySQL(c,"SELECT Cash FROM Accounts WHERE Name='KAKAN'"), e = GetSQLColumnData( d, 0 );
if( e ) print( "KAKAN has " + e + "$" );
</pre>