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. |
Ratings | Utility | Consistency | Documentation | Examples | Tests | Videos | Overall | Rank |
All time: | 75% | 75% | 58% | 75% | - | - | 58% | 1431 |
Month: | Not yet rated by the users |
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 |