system.dataset.dataSetToHTML

Description

Formats the contents of a dataset as an HTML page, returning the results as a string. Uses the <table> element to create a data table page.

Syntax

system.dataset.dataSetToHTML(showHeaders, dataset, title)

  • Parameters

boolean showHeaders - If true(1), the HTML table will include a header row.

Dataset dataset - The dataset to export

String title - The title for the HTML page.

  • Returns

String - The HTML page as a string.

  • Scope

All

Code Examples
Code Snippet
#This snippet would run a SQL query against a database, and turn the results into a string containing HTML. It then writes the string to a file on the local hard drive.
results = system.db.runQuery("SELECT * FROM example1 LIMIT 100")
results = system.dataset.toDataSet(results)
html = system.dataset.dataSetToHTML(1, results, "Production Report")
filePath = "C:\\output\\results.html"
system.file.writeFile(filePath, html)