2.2. SQL Access Methods
An Interchange SQL database can be accessed with the same tags as any of the other databases can. Arbitrary SQL queries can be passed with the [query sql="SQL STATEMENT"] ITL tag.
[query ml=10 more=1 type=list sp="@@MV_PAGE@@" sql=| SELECT sku, description FROM products WHERE somecol BETWEEN '[filter sql][cgi from][/filter]' AND '[filter sql][cgi to][/filter]' AND someothercol = '[filter sql][cgi whatever][/filter]' ORDER BY sku |] [list] sku=[sql-code] - desc=[sql-param description]<br> [/list] [on-match] Something was found<br> [/on-match] [no-match] Nothing was found<br> [/no-match] [more-list] <br>[matches]<br> [/more-list] [/query]
Not the filter for [cgi foo] values, which prevent single quotes (') from destroying the query.