Scripting/Squirrel/Functions/GetSQLNextRow - Revision history

Dracc: Cleanup example code

2019-04-26T10:13:13Z

Cleanup example code

← Older revision		Revision as of 10:13, 26 April 2019
Line 11:		Line 11:

	<source lang="squirrel">		<source lang="squirrel">
	function GetAlias( uniqueid )		function GetAlias(uniqueid) {
	{		// Select all the rows that has the same uniqueid as the entered value.
	local query = QuerySQL(sdb, "SELECT namecolumn FROM tablename WHERE uniqueidcolumn = '" + uniqueid + "'"); // ~~Selects all~~ the ~~rows that has the same uniqueid as the entered value~~.		local query = QuerySQL(sdb, "SELECT namecolumn FROM tablename WHERE uniqueidcolumn = '" + uniqueid + "'");
	local string = GetSQLColumnData(query, 0); ~~// Stores the first name.~~		// Store the first name.
			local string = GetSQLColumnData(query, 0);
	~~while (GetSQLNextRow(query))~~ // ~~Gets~~ the second name when the loop starts and ~~continues~~ getting the next row after that until no rows are left.
	{		// Get the second name when the loop starts and continue getting the next row after that until no rows are left.
			while (GetSQLNextRow(query)) {
	string += ", " + GetSQLColumnData(query, 0);		string += ", " + GetSQLColumnData(query, 0);
	}		}
	string += ".";		string += ".";
	~~return string;~~ // ~~Returns~~ the string containing the aliases.
	}</source>		// Return the string containing the aliases.
			return string;
			}
			</source>

	== Related Functions ==		== Related Functions ==

Thijn at 19:02, 30 January 2017

2017-01-30T19:02:13Z

← Older revision		Revision as of 19:02, 30 January 2017
Line 24:		Line 24:
	return string; // Returns the string containing the aliases.		return string; // Returns the string containing the aliases.
	}</source>		}</source>

	~~== Related Functions ==~~

	~~{{Scripting/Squirrel/Functions/SQLite Functions}}~~

	== Related Functions ==		== Related Functions ==

Thijn at 19:02, 30 January 2017

2017-01-30T19:02:05Z

← Older revision		Revision as of 19:02, 30 January 2017
Line 28:		Line 28:

	{{Scripting/Squirrel/Functions/SQLite Functions}}		{{Scripting/Squirrel/Functions/SQLite Functions}}

			== Related Functions ==

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

VK.Angel.OfDeath: Created page with "Calling GetSQLNextRow switches from the current row in a query to the next row, which allows you to read from that row with GetSQLColumnData. == Syntax ==

function GetS..."

2016-03-10T19:56:59Z

Created page with "Calling GetSQLNextRow switches from the current row in a query to the next row, which allows you to read from that row with GetSQLColumnData. == Syntax == <pre>function GetS..."

New page

Calling GetSQLNextRow switches from the current row in a query to the next row, which allows you to read from that row with GetSQLColumnData.

== Syntax ==

<pre>function GetSQLNextRow( query )</pre>

== Arguments ==
* '''Query''' - A reference to the query that was previously executed.

== Example ==

<source lang="squirrel">
function GetAlias( uniqueid )
{
local query = QuerySQL(sdb, "SELECT namecolumn FROM tablename WHERE uniqueidcolumn = '" + uniqueid + "'"); // Selects all the rows that has the same uniqueid as the entered value.
local string = GetSQLColumnData(query, 0); // Stores the first name.

while (GetSQLNextRow(query)) // Gets the second name when the loop starts and continues getting the next row after that until no rows are left.
{

string += ", " + GetSQLColumnData(query, 0);
}
string += ".";
return string; // Returns the string containing the aliases.
}</source>

== Related Functions ==

{{Scripting/Squirrel/Functions/SQLite Functions}}