Adobe 38040334 API Reference - Page 71
MMDB.getSPParamsAsString
UPC - 883919090467
View all Adobe 38040334 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 71 highlights
DREAMWEAVER CS3 66 API Reference • 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 procedure. Returns An array of parameter objects, each specifying the following set of properties: Property name name datatype direction Description Name of the parameter (for example, @@lolimit) Datatype of the parameter (for example, smallmoney) Direction of the parameter: 1-The parameter is used for input only. 2-The parameter is used for output only. In this case, you pass the parameter by reference and the method places a value in it. You can use the value after the method returns. 3- The parameter is used for both input and output. 4- The parameter holds a return value. Example The following example retrieves the parameter objects for the specified procedure and creates a tooltip for each object using its properties. var paramNameObjs = MMDB.getSPParameters(connName,procName); for (i = 0; i < paramNameObjs.length; i++) { var paramObj = paramNameObjs[i]; var tooltiptext = paramObj.datatype; tooltiptext+=" "; tooltiptext+=GetDirString(paramObj.directiontype); } MMDB.getSPParamsAsString() Availability Dreamweaver UltraDev 1. Description This function gets a comma-delimited string that contains the list of parameters that the stored procedure takes. Arguments connName, procName • 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.