mysql-native v1.2.0

API Reference Home: [This Version] [Latest Version] [Other Versions]

Function queryRowTuple

Execute a one-off SQL SELECT command where you only want the first Row, and place result values into a set of D variables.


					
			void queryRowTuple(T...)
			(
			

			  Connection conn,
			

			  string sql,
			

			  ref T args
			

			);

This method will throw if any column type is incompatible with the corresponding D variable.

Unlike the other query functions, queryRowTuple will throw MYX if the result set is empty (and thus the reference variables passed in cannot be filled).

If the SQL command does not produce a result set (such as INSERT/CREATE/etc), then MYXNoResultRecieved will be thrown. Use exec instead for such commands.

Use this method when you are not going to be using the same command repeatedly and you are CERTAIN all the data you're sending is properly escaped. Otherwise consider using Prepared.

Type Mappings

See the MySQL/D Type Mappings tables

Parameters

Name	Description
conn	An open Connection to the database.
sql	The SQL command to be run.
args	The variables, taken by reference, to receive the values.

Parameters

Name	Description
args	A tuple of D variables to receive the results.