IRISLIB database
MDXCSV Class Reference

This page renders the results of executing a DeepSee MDX statement in csv format. More...

Inheritance diagram for MDXCSV:
Collaboration diagram for MDXCSV:

Static Public Member Functions

_.Library.Status OnPage ()
 Event handler for PAGE event: this is invoked in order to
More...
 
_.Library.Boolean OnPreHTTP ()
 Event handler for PreHTTP event: this is invoked before. More...
 
- Static Public Member Functions inherited from Page
_.Library.Status ConvertParameter (_.Library.String url, _.Library.String name, _.Library.String value)
 You pass this the <parameter>url</parameter> of the page you are going to and a. More...
 
_.Library.Binary Decrypt (_.Library.String data)
 Decrypts the input string using the session.Key value that is unique to. More...
 
_.Library.String Encrypt (_.Library.Binary data)
 Encrypts the input string using the session.Key value that is unique to this. More...
 
_.Library.String EscapeHTML (in)
 This method converts input HTML text into Escaped HTML text.
 
_.Library.String EscapeURL (_.Library.String in, _.Library.String charset)
 This method converts the in input URL string into Escaped URL string. More...
 
_.Library.String HyperEventCall (_.Library.String methodName, _.Library.String args, _.Library.Integer type, _.Library.Boolean mobile)
 This method returns the string that needs to be written to the current. More...
 
_.Library.String HyperEventHead (_.Library.Boolean iframeOnly, _.Library.Boolean strict, _.Library.Boolean optionalBroker)
 This method returns the string that needs to be written to the current. More...
 
 Include (_.Library.String url)
 Include another csp page or file in the output at this point. More...
 
_.Library.String InsertHiddenField (_.Library.String url, _.Library.String name, _.Library.String value, _.Library.String extra)
 Inserts a '<input type="hidden" name="Name" value="Value">' tag into the current document. More...
 
_.Library.String InsertHiddenFields (_.Library.String url, _.Library.String query)
 Return the string containing the hidden form tags. More...
 
_.Library.Boolean IsPrivate ()
 Returns 1 if this page is in fact a private page (see <parameter>PRIVATE</parameter>).
 
_.Library.String Link (_.Library.String link, _.Library.String query, _.Library.Boolean addQ)
 Tranforms the link specified by link into a URL and returns it as a string. More...
 
_.Library.Status OnHTTPHeader (_.Library.Boolean OutputBody)
 Event handler for PAGE event: this is invoked in order to
More...
 
 OnPageError (_.Library.Status sc)
 Event handler for any error that occurs on the page. More...
 
 OnPostHTTP ()
 Event handler for POSTPAGE event: this is invoked after the data. More...
 
_.Library.Status OnPostHyperEvent (_.Library.String class, _.Library.String method)
 Event handler which is invoked after a hyperevent method is called on this page.
 
_.Library.Status OnPreHyperEvent (_.Library.String class, _.Library.String method)
 Event handler which is invoked before a hyperevent method is called on this page. More...
 
_.Library.Status Page (_.Library.Boolean skipheader)
 Process a request to serve a CSPPage. More...
 
_.Library.String QuoteJS (in)
 This method converts input string into quoted JavaScript literal.
 
_.Library.String RewriteURL (_.Library.String url)
 This method will rewrite a URL to use #url()# if needed.
 
 ShowError (_.Library.Status sc)
 Display a <class>Status</class> error code to the CSP Page.
 
 StartTimer (_.Library.String name)
 Used to get performance information on your CSP pages. More...
 
 StopTimer (_.Library.String name)
 Used to time performance information on your CSP pages. More...
 
 ThrowError (_.Library.Status sc)
 Passed a <class>Status</class> code this goes to the error page passing this status code.
 
_.Library.String UnescapeHTML (in)
 This method converts Escaped HTML text into normal HTML text.
 
_.Library.String UnescapeURL (_.Library.String in, _.Library.String charset)
 This method converts the in Escaped URL string back to its original form. More...
 

Static Public Attributes

 CHARSET = None
 This page renders the results of executing a DeepSee MDX statement in csv format.
 
 EXPIRES = None
 Required for IE!
 
- Static Public Attributes inherited from Page
 CHARSET = None
 The <CLASS>CSP.Page</CLASS> object serves as an event handler for CSP requests. More...
 
 CONTENTTYPE = None
 Specifies the default content type for the page. More...
 
 CONVERTINPUTSTREAM = None
 Specifies if input request.Content or request.MimeData values are converted from their. More...
 
 CSPFILE = None
 If this page was compiled from a .csp file, then this parameter contains the. More...
 
 CSPSTRICT = None
 The CSPSTRICT parameter is set to 1, if the DOCTYPE indicates that this. More...
 
 CSPURL = None
 This parameter is used to make sure that if multiple. More...
 
 CSPXHTML = None
 The CSPXHTML parameter is set to 1, if the DOCTYPE indicates that this. More...
 
 DOMAIN = None
 The default domain for csp:text, span and div tags. More...
 
 ENCODED = None
 Controls how the query parameters for this page are passed, it can. More...
 
 ERRORPAGE = None
 Specify a custom error page to call if there are any problems with generating this page. More...
 
 EXPIRES = None
 Specified the default value for the response.Expires. More...
 
 NOCHARSETCONVERT = None
 Specifies if we wish to turn off charset conversion for this page. More...
 
 PAGETIMING = None
 If this parameter is true then we automatically record timing statistics of how long it takes to. More...
 
 PRIVATE = None
 Controls the access to the page, it can be set to one of the following:
More...
 
 SECURITYRESOURCE = None
 This is a comma-delimited list of system Resources and associated. More...
 
 TIMINGSLOTS = None
 Used by the timing to decide how many slots a day should be divided up into. More...
 
 UseSession = None
 This parameter controls the CSP session support. More...
 

Static Private Member Functions

_.Library.String EscapeHTML (_.Library.String pValue)
 Format a string value for HTML output. More...
 
_.Library.String FormatNumber (_.Library.String pValue)
 Format a value for output.
 
_.Library.String NumberToColumn (_.Library.String pValue)
 Convert a column number to a letter (A,B,AA).
 
_.Library.Status PrintKPIResults (_.Library.String pKPI, _.Library.String pCaption, _.Library.String pSubCaption)
 Print out the contents of the given KPI.
 
_.Library.Status PrintListingResults (_.SQL.StatementResult pRS, _.Library.String pCaption, _.Library.String pSubCaption, _.Library.List pListingFields, _.Library.String pCubeKey)
 Print out the contents (as Excel-style HTML) of the given SQL ResultSet listing. More...
 
_.Library.Status PrintResults (_.DeepSee.ResultSet pRS, _.Library.String pCaption, _.Library.String pSubCaption)
 Print out the contents (as Excel-style HTML) of the given MDX result set.
 

Detailed Description

This page renders the results of executing a DeepSee MDX statement in csv format.

Member Function Documentation

◆ EscapeHTML()

_.Library.String EscapeHTML ( _.Library.String  pValue)
staticprivate

Format a string value for HTML output.

This means escaping UNICODE characters.

◆ PrintListingResults()

_.Library.Status PrintListingResults ( _.SQL.StatementResult  pRS,
_.Library.String  pCaption,
_.Library.String  pSubCaption,
_.Library.List  pListingFields,
_.Library.String  pCubeKey 
)
staticprivate

Print out the contents (as Excel-style HTML) of the given SQL ResultSet listing.

pListingFields is option list of fields to display.

◆ OnPage()

_.Library.Status OnPage ( )
static

Event handler for PAGE event: this is invoked in order to

generate the content of a csp page.

Reimplemented from Page.

◆ OnPreHTTP()

_.Library.Boolean OnPreHTTP ( )
static

Event handler for PreHTTP event: this is invoked before.

the HTTP headers for a CSP page have been sent. All changes to the <class>CSP.Response</class> class, such as adding cookies, HTTP headers, setting the content type etc. must be made from within the OnPreHTTP() method. Also changes to the state of the CSP application such as changing session.EndSession or session.AppTimeout must be made within the OnPreHTTP() method. It is prefered that changes to session.Preserve are also made in the OnPreHTTP() method as this is more efficient, although it is supported in any section of the page. Return 0 to prevent <method>OnPage</method> from being called.

Reimplemented from Page.