queryRowTuple

Execute an SQL SELECT command or prepared statement where you only want the first mysql.result.Row, and place result values into a set of D variables.

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

Unlike the other query functions, queryRowTuple will throw mysql.exceptions.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 mysql.exceptions.MYXNoResultRecieved will be thrown. Use exec instead for such commands.

Only use the const(char[]) sql overload 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 overload that takes a Prepared.

More...
  1. void queryRowTuple(Connection conn, const(char[]) sql, T args)
    void
    queryRowTuple
    (
    T...
    )
    (,
    const(char[]) sql
    ,
    ref T args
    )
  2. void queryRowTuple(Connection conn, Prepared prepared, T args)
  3. void queryRowTuple(Connection conn, BackwardCompatPrepared prepared, T args)

Parameters

conn Connection

An open mysql.connection.Connection to the database.

sql const(char[])

The SQL command to be run.

args T

The variables, taken by reference, to receive the values.

Detailed Description

Type Mappings

$(TYPE_MAPPINGS)

Meta