Scripting/Squirrel/Functions/GetSQLNextRow: 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
(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...")
 
m (Cleanup example code)
 
(2 intermediate revisions by one other user not shown)
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 ==


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

Latest revision as of 10:13, 26 April 2019

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 GetSQLNextRow( query )

Arguments

  • Query - A reference to the query that was previously executed.

Example

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 + "'");
  // Store the first name.
  local string = GetSQLColumnData(query, 0);

  // 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 += ".";

  // Return the string containing the aliases. 
  return string;
}

Related Functions