[show_mySQLvars]

Description

Link: [show_mySQLvars]
Author: Alex Pilson
Category: Database
Version: 8.x
License: Public Domain
Posted: Nov. 29, 2005
Updated: Nov. 29, 2005
More by this author...
Utiltity to view your MySQL system variables.

Parameters

-db string, required Database required.

Sample Usage

show_mySQLvars(-db='databaseName');

// databaseName needs to be a valid enabled database under a valid enabled datasource connector.

Source Code

Click the "Download" button below to retrieve a copy of this tag, including the complete documentation and sample usage shown on this page. Place the downloaded ".inc" file in your LassoStartup folder, restart Lasso, and you can begin using this tag immediately.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
define_tag(
	'mySQLvars',
	-nameSpace='show_',
	
	-required='db',
	-type='string',
	-privileged);
	
	local('output' = '<table>');
	
	inline(
	-database=#db, 
	-username=(client_username),
	-password=(client_password),
	-maxrecords='all',
	-sql="SHOW VARIABLES;");
	

	Iterate(Records_Array, local('record'));
		#output += ('<tr><td>' +#record->(Join: '</td><td>')+ '</td></tr>');
	/Iterate;
	
	/inline;
	
	#output += '</table>';
	return(@#output);
	
/define_tag;

 

Comments

none

Registered users can add comments.
Email:


Password:


Not a member? Sign up.
Forgot your password?

Newest

  1. [Phone]
  2. [parse_csv]
  3. [xirr]
  4. [pk_autoversion]
  5. [pk_blackorwhitefromhex]
  6. [integer-asStringOrd]
  7. [trim(9)]
  8. [amtac_fileuploads]
  9. [encode_sqlfull]
  10. [AuthorizeNet_AIM_9]

Most Popular

  1. [xml_tree]
  2. [lp__library]
  3. [AuthorizeNet_AIM]
  4. [lp_client_browser]
  5. [calendar_grid]
  6. [results_navigation]
  7. [twitter]
  8. [akismet]
  9. [lp_client_isBot]
  10. [client_params]

Support tagSwap.net

Your contribution will help support the hosting, maintenance, and improvement of tagSwap.net.