Permits you to write the SELECT portion of your query:
rigDbSelect "title,content,date" put rigDbGet("mytable") into tQuery -- Produces: SELECT title, content, date FROM mytable
Note: If you are selecting all (*) from a table you do not need to use this handler. When omitted, revIgniter assumes you wish to SELECT *
rigDbSelect accepts an optional second parameter. If you set it to FALSE, revIgniter will not try to protect your field or table names with backticks. This is useful if you need a compound select statement.
rigDbSelect "SELECT SUM(payments.amount) FROM payments WHERE payments.invoice_id=4) AS amount_paid", FALSE put rigDbGet("mytable") into tQuery