Application.ShowHyperlinkParameters Method
| SharePoint Designer Developer Reference |
Displays the Hyperlink Parameter dialog box and returns a String that represents the hyperlink plus the parameters, separated by a question mark.
Syntax
expression.ShowHyperlinkParameters(bstrPath, bstrQuery, bstrColumns, bstrColTypes)
expression Required. A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| bstrPath | Required | String | Specifies the Web address for the hyperlink. |
| bstrQuery | Required | String | Specifies the query string to pass when opening the linked page. |
| bstrColumns | Required | String | Specifies a comma-delimited String that contains the names of the database columns that are available for use in the URL. |
| bstrColTypes | Required | String | Specifies a comma-delimited String that represents the data type values of the database columns. |
Return Value
String
Remarks
The values for the bstrColTypes parameter include the following.
| Data type | Value | Description |
|---|---|---|
| adArray | 819 | When combined with another data type, indicates an array of the other data type. |
| adBigInt | 20 | Indicates an 8-byte signed integer. |
| adBinary | 128 | Indicates a binary value. |
| adBoolean | 11 | Indicates a Boolean value. |
| adBSTR | 8 | Indicates a null-terminated character string. |
| adChapter | 136 | Indicates a 4-byte chapter value that identifies rows in a child row set. |
| adChar | 129 | Indicates a string value. |
| adCurrency | 6 | Indicates a currency value. A currency value is a fixed-point number with four digits to the right of the decimal point and is stored in an eight-byte signed integer. |
| adDate | 7 | Indicates a date value. A date value is stored as a double; the integer portion is the number of days since December 30, 1899, and the fractional portion is the fraction of a day. |
| adDBDate | 133 | Indicates a date value (yyyymmdd). |
| adDBTime | 134 | Indicates a time value (hhmmss). |
| adDBTimeStamp | 135 | Indicates a date/time stamp (yyyymmddhhmmss plus a fraction in billionths). |
| adDecimal | 14 | Indicates an exact numeric value with a fixed precision and scale. |
| adDouble | 5 | Indicates a double-precision floating-point value. |
| adEmpty | 0 | Indicates no value. |
| adError | 10 | Indicates a 32-bit error code. |
| adFileTime | 64 | Indicates a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601. |
| adGUID | 72 | Indicates a globally unique identifier (GUID). |
| adIDispatch | 9 | Indicates a pointer to an IDispatch interface on a COM object. (ADO does not currently support this data type. Usage may cause unpredictable results.) |
| adInteger | 3 | Indicates a 4-byte signed integer. |
| adIUnknown | 13 | Indicates a pointer to an IUknown interface on a COM object. (ADO does not currently support this data type. Usage may cause unpredictable results.) |
| adLongVarBinary | 205 | Indicates a long binary value. |
| adLongVarChar | 201 | Indicates a long string value. |
| adLongVarWChar | 203 | Indicates a long null-terminated Unicode value. |
| adNumeric | 131 | Indicates an exact numeric value with a fixed precision and scale. |
| adPropVariant | 138 | Indicates an Automation PROPVARIANT. |
| adSingle | 4 | Indicates a single-precision floating point. |
| adSmallInt | 2 | Indicates a 2-byte signed integer. |
| adTinyInt | 16 | Indicates a 1-byte signed integer. |
| adUnsignedBigInt | 21 | Indicates an 8-byte unsigned integer. |
| adUnsignedInt | 19 | Indicates a 4-byte unsigned integer. |
| adUnsignedSmallInt | 18 | Indicates a 2-byte unsigned integer. |
| adUnsignedTinyInt | 17 | Indicates a 1-byte unsigned integer. |
| adUserDefined | 132 | Indicates a user-defined variable. |
| adVarBinary | 204 | Indicates a binary value. |
| adVarChar | 200 | Indicates a string value. |
| adVariant | 12 | Indicates an Automation Variant. (ADO does not currently support this data type. Usage may cause unpredictable results.) |
| adVarNumeric | 139 | Indicates a numeric value. |
| adVarWChar | 202 | Indicates a null-terminated Unicode character string. |
| adWChar | 130 | Indicates a null-terminated Unicode character string. |
For more information on ActiveX data types, see ActiveX Data Object (ADO) on the Microsoft Developer Network (MSDN) Web site.
See Also