Classes of Toby Allen
| Recommend this page to a friend! |
| All class groups | > | All authors | > | Classes of Toby Allen (1) | > | Mission progress status | > | Reputation |
|
|
|||||||||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
| ||||
| This class can generate a large range of SQL SELECT queries from a submitted form. It provides means to generate simple queries on one field on a table, joins, selection of fields to be returned, aliasing of fields (eg. SUM(Price) AS Total), ORDER BY, even multiple queries from one form. Comes with a basic demo file, which I hope to update in time. GROUP BY and HAVING are also provided, but not entirely reliable. Demo file provides overview of creating forms necessary to generate results. |
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
