Home » Adobe Manuals » Computer Software » Adobe 38040334 » Manual Viewer

Adobe 38040334 API Reference - Page 74

Availability, Description, Arguments, Returns, Example, Dreamweaver UltraDev 1.

UPC - 883919090467

Add to My Manuals
Save this manual to your list of manuals

Page 74 highlights

DREAMWEAVER CS3 69 API Reference MMDB.showSPResultset() Availability Dreamweaver UltraDev 1. Description This function displays a dialog box that contains the results of executing the specified stored procedure. The dialog box displays a tabular grid in which the header provides column information that describes the result set. If the connection string or the stored procedure is invalid, an error appears. This function validates the stored procedure. Arguments connName, procName, paramValuesArray • The connName argument 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. • The procName argument is the name of the stored procedure to execute. • The paramValuesArrayargument 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 This function returns an error if the SQL statement or the connection string is invalid; otherwise, it returns nothing. 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 This function displays a dialog box that contains the result set of the specified stored procedure. The dialog box displays a tabular grid in which the header provides column information that describes the result set. If the connection string or the stored procedure is invalid, an error appears. This function validates the stored procedure. This function differs from the MMDB.showSPResultset() function 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 • The connName argument 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. • The procName argument is the name of the stored procedure that returns the result set when it executes. • The paramNameArray argument is an array that contains a list of parameter names. You can use the MMDB.getSP- ParamsAsString() function to get the parameters of the stored procedure.

Section	Page
Contents	3
Chapter 1: Introduction	6
Background	7
Extending Dreamweaver	7
Additional resources for extension writers	7
New functions in Dreamweaver CS3	7
Removed functions	9
Errata	10
Conventions used in this guide	10
Chapter 2: The file I/O API	11
Accessing configuration folders	11
The file I/O API	11
Chapter 3: The HTTP API	20
How the HTTP API works	20
The HTTP API	21
Chapter 4: The Design Notes API	27
How Design Notes work	27
The Design Notes JavaScript API	28
The Design Notes C API	32
Chapter 5: Fireworks integration	39
The FWLaunch API	39
Chapter 6: Flash integration	46
How Flash elements work	46
Inserting Flash elements	46
The Flash Objects API	47
Chapter 7: The database API	51
How database API functions work	51
Database connection functions	52
Database access functions	64
Chapter 8: The database connectivity API	76
How to develop a new connection type	76
The Connection API	78
The generated include file	80
The definition file for your connection type	82
Chapter 9: The JavaBeans API	84
The JavaBeans API	84
Chapter 10: The source control integration API	89
How source control integration with Dreamweaver works	90
Adding source control system functionality	90
The source control integration API required functions	90
The source control integration API optional functions	96
Enablers	104
Chapter 11: Application	109
External application functions	109
Global application functions	117
Bridge communication functions	122
Chapter 12: Workspace	124
History functions	124
Insert object functions	132
Keyboard functions	135
Menu functions	141
Results window functions	143
Toggle functions	154
Toolbar functions	173
Window functions	178
Code collapse functions	188
Code view toolbar functions	194
Chapter 13: Site	198
Report functions	198
Site functions	199
Chapter 14: Document	232
Conversion functions	232
Command functions	233
File manipulation functions	235
Global document functions	249
Path functions	258
Selection functions	260
String manipulation functions	267
Translation functions	270
XSLT functions	272
Chapter 15: Page content	275
Assets panel functions	275
Behavior functions	285
Clipboard functions	293
Library and template functions	298
Snippets panel functions	303
Spry widget editing functions	306
Inserting Spry widgets functions	308
Browser compatibility check functions	311
Chapter 16: Dynamic documents	319
Server components functions	319
Data source functions	320
Extension Data Manager functions	321
Live data functions	324
Server behavior functions	328
Server model functions	330
Chapter 17: Design	337
CSS layout functions	337
Frame and frameset functions	356
Layer and image map functions	358
Layout environment functions	360
Layout view functions	365
Zoom functions	374
Guide functions and properties	377
Table editing functions	384
Chapter 18: Code	393
Code functions	393
Find and replace functions	397
General editing functions	402
Print function	417
Quick Tag Editor functions	418
Code view functions	420
Tag editor and tag library functions	436
Chapter 19: Enablers	440
Enabler functions	440

Match case Limit results 1 per page

DREAMWEAVER CS3

API Reference

MMDB.showSPResultset()

Availability

Dreamweaver UltraDev 1.

Description

This function displays a dialog box that contains the results of executing the specified stored procedure. The dialog

box displays a tabular grid in which the header provides column information that describes the result set. If the

connection string or the stored procedure is invalid, an error appears. This function validates the stored procedure.

Arguments

connName, procName, paramValuesArray

•

The

connName

argument 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.

•

The

procName

argument is the name of the stored procedure to execute.

•

The

paramValuesArrayargument

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.getSPParam-

sAsString()

function to get the parameters of the stored procedure.

Returns

This function returns an error if the SQL statement or the connection string is invalid; otherwise, it returns nothing.

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

This function displays a dialog box that contains the result set of the specified stored procedure. The dialog box

displays a tabular grid in which the header provides column information that describes the result set. If the

connection string or the stored procedure is invalid, an error appears. This function validates the stored procedure.

This function differs from the

MMDB.showSPResultset()

function 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

•

The

connName

argument 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.

•

The

procName

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

•

The

paramNameArray

argument is an array that contains a list of parameter names. You can use the

MMDB.getSP-

ParamsAsString()

function to get the parameters of the stored procedure.