<participant>
	<insertText location="aboveHTML+50"><![CDATA[<%

var @@cdName@@ = Server.CreateObject ("ADODB.Command");
@@cdName@@.ActiveConnection = MM_@@cname@@_STRING;
@@cdName@@.CommandText = @@sql@@;
<@ loop(@@paramName@@, @@paramType@@, @@paramDirection@@, @@paramSize@@, @@paramValue@@) @>@@cdName@@.Parameters.Append(@@cdName@@.CreateParameter("@@paramName@@", @@paramType@@, @@paramDirection@@, @@paramSize@@, @@paramValue@@));
<@ endloop @>@@cdName@@.CommandType = @@commandtype@@;
@@cdName@@.CommandTimeout = @@commandTimeout@@;
@@cdName@@.Prepared = @@prepared@@;
@@cdName@@.Execute();

%>]]></insertText>
	<searchPatterns whereToSearch="directive">
		<searchPattern paramNames="wholeMatch,cdName" isOptional="false" limitSearch="all"><![CDATA[/(var\s+(\S*)\s*=\s*Server\.CreateObject\("ADODB\.Command"\);(?:[\r\n \t]+\2.*)+[\r\n \t]+(?:var\s+(\S+)\s*=\s*)?\2\.Execute(?:\(\);)?(?:[\r\n \t]+\3_numRows\s*=\s*\S*)?)(?=\r\n|\r|\n|%>)/i]]></searchPattern>
		<searchPattern paramNames="paramName,paramType,paramDirection,paramSize,paramValue" limitSearch="@@wholeMatch@@" isOptional="true" searchType="multiple"><![CDATA[/\S+\.Parameters\.Append\(\s*\S+\.CreateParameter\("(\S+?)"(?:,\s*(\S+?)(?:,\s*(\S+?)(?:,\s*(\S+?)(?:,\s*(\S+?))?)?)?)?\s*\)\);/i]]></searchPattern>
		<searchPattern paramNames="cname" limitSearch="@@wholeMatch@@" isOptional="false"><![CDATA[/\.ActiveConnection\s*=\s*MM_(\S+)_STRING/i]]></searchPattern>
		<searchPattern paramNames="sql" limitSearch="@@wholeMatch@@" isOptional="false"><![CDATA[/\.CommandText\s*=\s*(\S+);/i]]></searchPattern>
		<searchPattern paramNames="commandtype" limitSearch="@@wholeMatch@@" isOptional="false"><![CDATA[/\.CommandType\s*=\s*(\S+);/i]]></searchPattern>
		<searchPattern paramNames="commandTimeout" limitSearch="@@wholeMatch@@" isOptional="false"><![CDATA[/\.CommandTimeout\s*=\s*(\S+);/i]]></searchPattern>
		<searchPattern paramNames="prepared" limitSearch="@@wholeMatch@@" isOptional="false"><![CDATA[/\.Prepared\s*=\s*(\S+);/i]]></searchPattern>
		<searchPattern paramNames="rsName" limitSearch="@@wholeMatch@@" isOptional="true"><![CDATA[/var\s+(\S+)\s*=\s*\S+\.Execute(?:\(\);)?[\r\n \t]+var\s+\1_numRows\s*=\s*\S+/i]]></searchPattern>
	</searchPatterns>
	<quickSearch>Server.CreateObject</quickSearch>
</participant>
