The QueryToTable class exposes an Execute method, which expects an ADO connection string and a SQL query expression. These are the same arguments you'd pass to the Open method of an ADO recordset. After the component executes the query, you can invoke its Gen-erateTable method, which displays the query results as an HTML table. In this case, column headers are derived from the field names, which isn't always desirable. Besides, you might want to exclude a few fields from the query or modify the font attributes for a given column.
All arguments are optional, except the first.
By default, all data is aligned to the top left. The GenerateTable method outputs whatever you passed to the PrefixTag just before sending the field's value to the client. Similarly, the method outputs the PostfixTag's contents immediately after sending the field's value. These two arguments give you fine control over formatting the text in the column, provided you're familiar with the most common HTML tags. Remember that a VB-authored ASP component doesn't suffer from the limitations of a script language.