Skip to main content

Posts

Showing posts from May, 2012

Redirecting output from MySQL queries to a file

Use the   --tee   MySQL command. Login to MySQL with this command: mysql --user=root --password=root --tee= c:\mysqloutput.txt -h hostname By using the  --tee  option when invoking MySQL from a command prompt, statements and output can be logged. All the data displayed on the screen is appended to file referenced in the command, in this example - c:\mysqloutput.txt More advanced usage, mysql -u root -p --tee=batch5output.txt  --line-numbers -vvv --skip-column-names comments: -vvv (output the sql scripts as well) Also, execute notee at  any time you don't want output the following contents and execute tee when you want output log again. Cheers.

T-SQL: return multiple sets of output with Store Procedure and access from coldfusion

Sample query for return multiple type of output from Store Procedure - proved to be a solution  USE [EdPlan_DEV] if OBJECT_ID('EdPlanAdm.sxuSearchSampleProc') is not null drop proc EdPlanAdm.sxuSearchSampleProc go CREATE PROCEDURE [EdPlanAdm].[sxuSearchSampleProc] @filter Nvarchar(1024), @myoutput int output AS BEGIN -- start of block 2: will return the count of the result -- DECLARE @count_sql Nvarchar(1024); set @count_sql = N'select @myoutput = count(*) from dbo.sysobjects where id in ( ' + @filter + ');' -- output count of matched data exec sp_executesql @count_sql,N'@myoutput int OUTPUT',@myoutput output; select * from dbo.sysobjects ; END GO ColdFusion Codes cfstoredproc procedure="edplanadm.sxuSearchSampleProc" datasource="#sDataSource#" returnCode = "YES"> <cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" dbvarname="filter" value="3,5,7"> <cfproc