-SQL
The -SQL command tag allows one or more SQL statements to be executed within a compatible data source. Multiple SQL statements are delimited by semi-colons. When performing multiple SQL statements, only the results of the last statement are output in the [Inline] ... [/Inline] tags.
The data source within which the SQL statement should be executed is identified by naming a database using the -Database command tag. The SQL statement to be executed is specified as the parameter of the -SQL command tag.
The -Database parameter is used solely to identify what data source to send the SQL command to. Within the SQL statement you must always specify both the database and table names as in "SELECT * FROM Contacts.People".
The -MaxRecords and -SkipRecords tags apply to the results returned from a SQL statement just as they do for results returned from other database actions. In order to return all the results from a -SQL action use -MaxRecords='all' in the opening [Inline] tag.
Note: -SQL actions can only be performed within [Inline] tags. They cannot be performed through HTML forms or URLs.
- Syntax
- Parameters
[Inline: -SQL='SQL Statement',
-Database='Database_Name',
-MaxRecords='all']
...
[/Inline]
[Inline: -SQL='SQL Statement; 'SQL Statement; SQL Statement',
-Database='Database_Name',
-MaxRecords='all']
...
[/Inline]Examples
To execute a SQL statement:
Use the -SQL command tag in an opening [Inline] tag. The following example returns a list of all available databases using the SHOW DATABASES statement.
[Inline: -Database='Site', -SQL='SHOW DATABASES;']
[Records]
<br>[Loop: (Field_Name: -Count)]
[Field: (Field_Name: Loop_Count)]
[/Loop]
[/Records]
[/Inline]Result:
<br>Contacts
<br>Site
To search a database using a -SQL statement:
The following example finds all records in a database using a SQL statement specified in [Inline] ... [/Inline] tags. Notice that both the database and table name are specified within the SQL statement.
The results are formatted in a table using the [Field_Name] tag to automatically retrieve the field names from the found set for the table column headers.
[Inline: -Database='Site',
-SQL='SELECT * FROM Contacts.People;']
<table>
<tr>[Loop: (Field_Name: -Count)]
<th>[Field_Name: Loop_Count]</th>
[/Loop]</tr>
[Records]
<tr>[Loop: (Field_Name: -Count)]
<td>[Field: (Field_Name: Loop_Count)]</td>
[/Loop]</tr>
[/Records]
</table>
[/Inline]Result:
<table>
<tr>
<th>First_Name</th>
<th>Last_Name</th>
...
</tr>
<tr>
<td>John</td>
<td>Doe</td>
...
</tr>
...
</table>
| Tag Link | -SQL | Category | Action |
|---|---|---|---|
| Type | Command | Data Source | MySQL |
| Support | Preferred | Version | 5.0 |
| Output Type | None | Security | Database |
| Implementation | Internal | Sets | Lasso 6.0, Lasso 5.0 |
Please note that periodically LassoSoft will go through the notes and may incorporate information from them into the documentation. Any submission here gives LassoSoft a non-exclusive license and will be made available in various formats to the Lasso community.
LassoSoft Inc. > Home
©LassoSoft Inc 2015 | Web Development by Treefrog Inc | Privacy | Legal terms and Shipping | Contact LassoSoft