All pastes #184744 Raw Edit

Untitled

public text v1 · immutable
#184744 ·published 2006-09-28 06:47 UTC
rendered paste body
	function run_proc(byref cmd, proc_name, exec_type)
		dim bool, member, param
		
		bool = true
		cmd.parameters.refresh
		
		for member in cmd.parameters
			param = cmd.parameters(member)
			if not isempty( request( replace("@", "", member) ) ) then
				cmd.parameters(member) = request( replace("@", "", member) )
			end if
		next
		
		cmd.execute , , exec_type
		
		run_proc = bool
	end function

	dim proc_success
	
	proc_success = run_proc(adoCmd, "sp_myProc", adExecuteNoRecords)