ph_sql PowerHome formula function
Description
Executes a SQL statement against the PowerHome database and return the resultset as a string.
Syntax
ph_sql ( type, sql )
| Argument |
Description |
|
type
|
Integer. The format in which you want the data returned. 0 for tab separated columns with cr/lf separated lines, 1 for comma separated columns and rows, 2 for XML data, and 3 for HTML table.
|
|
sql
|
String. A string containing the SQL select statement to run.
|
Return value
String. Returns the data formatted based upon the type parameter.