MYSQL_RES.Data

MYSQL_RES.Data — replaces the MYSQL_RES.data field.

Syntax

MYSQL_RES.Data()

Arguments

none

Returns

A two-dimentional array of [row][field_value].

Description

This method for the MYSQL_RES class replaces the field MYSQL_RES.data that would exist in the C API. Gamma needs to construct a two-dimensional array of data where the array is:

data[row][field_value]

That is, the first dimension of the array is the set of rows, and the second dimension of the array is the field values for each row.

[Note]

This is a built-in Gamma method that is similar to but does not exactly does not match the MySQL method MYSQL_RES.Data.

Example

This example is taken from Section 2.2, “Tutorial 2: create_pets.g”

...

  /* Test the MYSQL.query_and_store method. */
  query = mysql.query_and_store ("select name, birth from pets"); 
  pretty_princ("\nQUERY  The .query_and_store method applied ",
		"to the 'name' and 'birth' fields in mypetclass ",
	       "\nreturns this MYSQL_RES istance:\n", query, "\n");
  query_data = query.Data();
  pretty_princ("Its data, recovered using ",
	       "the .Data() method, is:\n", query_data, "\n");
    
...

The output for this section of the code is as follows:

QUERY  The .query_and_store method applied to the 'name' and 'birth' fields in mypetclass 
returns this MYSQL_RES istance:
{MYSQL_RES (current_field . 0) (eof . 1) (field_count . 2)
	   (fields . [{MYSQL_FIELD (decimals . 0) (def) (flags . 1)
				   (length . 20) (max_length . 8) (name . name)
				   (table . pets) (type . 253)} 
		      {MYSQL_FIELD (decimals . 0) (def) (flags . 0) (length . 10)
			    (max_length . 10) (name . birth) (table . pets) (type . 10)}])}
Its data, recovered using the .Data() method, is:
[[Claws 1994-03-17] [Buffy 1989-05-13] [Fang 1990-08-27] 
 [Bowser 1995-08-31] [Chirpy 1998-09-11] [Whistler 1997-12-09] 
 [Slim 1996-04-29] [Petunia 1925-12-25]]