MACROMEDIA DREAMWEAVER 8-DREAMWEAVER API Spécifications télécharger pdf (Page 334)

100

101

Chapter 27334

MMDB.showSPResultset()

Availability

Dreamweaver UltraDev 1

Description

Displays a dialog box that has the results of executing the specified stored procedure. The dialog

box displays a tabular grid where the header shows the column information and data of the result

set that is generated by the executed stored procedure. If the connection string or the stored

procedure is invalid, an error appears. You can use this function to verify the validity of the stored

procedure.

Arguments

connName, procName, paramValuesArray

• connName is a connection name that is specified in the Connection Manager. It identifies the

connection string that Dreamweaver should use to make a database connection to a live data

source.

• procName is the name of the stored procedure to execute.

• paramValuesArray is an array that contains a list of design-time parameter test values. Specify

the parameter values in the order in which the stored procedure expects them. You can use the

MMDB.getSPParamsAsString() function to get the parameters of the stored procedure.

Returns

Nothing. This function returns an error if the SQL statement or the connection string is invalid.

Example

The following code displays the results of the executed stored procedure:

var paramValueArray = new Array("2/1/2000", "50000")

MMDB.showSPResultset("EmpDB", "getNewEmployeesMakingAtLeast", ¬

paramValueArray)

MMDB.showSPResultsetNamedParams()

Availability

Dreamweaver UltraDev 1

Description

Displays a dialog box that has the results of executing the specified stored procedure. The dialog

box displays a tabular grid where the header shows the column information and data of the result

set that is generated by the executed stored procedure. If the connection string or the stored

procedure is invalid, an error appears. You can use this function to verify the validity of the stored

procedure. This function differs from

MMDB.showSPResultset() because you can specify the

parameter values by name instead of the order in which the stored procedure expects them.

Arguments

connName, procName, paramNameArray, paramValuesArray

• connName is a connection name that is specified in the Connection Manager. It identifies

the connection string that Dreamweaver should use to make a database connection to a

live data source.

• procName is the name of the stored procedure that returns the result set when it executes.

1 2 ... 329 330 331 332 333 334 335 336 337 338 339 ... 691 692

Commentaires sur ces manuels

Pas de commentaire

MACROMEDIA DREAMWEAVER 8-DREAMWEAVER API Spécifications Page 334

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel MACROMEDIA DREAMWEAVER 8-DREAMWEAVER API