Lasso Soft Inc. > Home

[show_mySQLvars]

Linkshow_mySQLvars
AuthorAlex Pilson
CategoryDatabase
Version8.x
LicensePublic Domain
Posted29 Nov 2005
Updated29 Nov 2005
More by this author...

Description

Utiltity to view your MySQL system variables.

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.

define_tag(
	'mySQLvars',
	-nameSpace='show_',
	
	-required='db',
	-type='string',
	-privileged);
	
	local('output' = '');
	
	inline(
	-database=#db, 
	-username=(client_username),
	-password=(client_password),
	-maxrecords='all',
	-sql="SHOW VARIABLES;");
	

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

Comments

No comments

Please log in to comment

Subscribe to the LassoTalk mail list

LassoSoft Inc. > Home

 

 

©LassoSoft Inc 2015 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft