Invokes method methodName
once using values from
running one SELECT
statement.
SELECT
statement which returns the values of the
parameters being sent to the methodName
method.
The value returned by methodName
as invoked
using the values from the database, or null
if the
methodName
's return type is void
.
The parameters of the underlying method can be primitives (e.g. numbers), one-dimensional arrays, but at most one of them can be a two-dimensional array.
The inputQuery
parameter of this method specifies
the SELECT
statement to use in invoking the underlying
method. The columns of the result set returned by the
SELECT
statement correspond to the values of the
parameters being sent to the underlying method as described below.
If methodName
takes only non-array parameters, the
method will be evaluated only for the first row in the
SELECT
result-set. The parameters will match their
corresponding column in the same order -- first column value goes to
the first parameter, second column value goes to the second
parameter etc. The number of columns returned must be equal to or
greater than the number of parameters in methodName
's
declaration.
If methodName
takes both non-array and
one-dimensional array parameters, the method will be evaluated only
for the first row in the SELECT
result-set for the
non-array parameters, and for the entire column values for the
one-dimensional array parameters. The parameters will match their
corresponding column in the same order -- first column values go to
the first parameter, second column values go to the second parameter
etc. The number of columns returned must be equal to or
greater than the number of parameters in methodName
's
declaration.
If methodName
takes (besides non-array and
one-dimensional array parameters) one two-dimensional array
parameter, the values being sent to the two-dimensional array
parameter stretch between the last of the first columns
(corresponding to the first primitive and/or array parameters) and
the first of the last columns (corresponding to the last primitive
and/or array parameters). In this case, this method will assume that
all values returned by the SELECT
statement are being
used. Also note that every column represents a one-dimensional array
element in the two-dimensional array value.
Consider the following example for a fictive underlying method with the following signature:
double BicubicSplinePointwiseEvaluation( double[] tabulationPointsInFirstVariable double[] tabulationPointsInSecondVariable, double[][] function, double interpolationPointFirstCoordinate, double interpolationPointSecondCoordinate)
First two parameters will be assigned to the first two columns
returned by the SELECT
statement and the last two
parameters will be assigned to the last two columns. The third
parameter, which is a two-dimensional array will be assigned to the
remaining columns.
If the underlying method's return type is void
, this
method will return null
.
ADOMediator Class | WebCab.Libraries.Statistics.Correlation.ADO Namespace | ADOMediator.OneSelect Overload List