<div>
this is my script:<br />
<br />
set rs = server.createobject(&quot;ADODB<wbr />.Recordset<wbr />&quot;)<br />
if choose = &quot;exact&quot; then<br />
sql=&quot;Select * from OMS_Search where keyword like '%&quot;&amp; search1 &amp;&quot;%' order by OMS_No asc&quot;<br />
elseif choose = &quot;all&quot; then<br />
sql=&quot;Select * from OMS_Search where keyword like '%&quot;&amp; search1 &amp;&quot;%' order by OMS_No asc&quot;<br />
elseif choose = &quot;any&quot; then<br />
sql=&quot;Select * from OMS_Search where keyword like '%&quot;&amp; search1 &amp;&quot;%' order by OMS_No asc&quot;<br />
end if<br />
rs.Open sql, conn,3,3
</div>


this is my script:

set rs = server.createobject("ADODB.Recordset")
if choose = "exact" then
sql="Select * from OMS_Search where keyword like '%"& search1 &"%' order by OMS_No asc"
elseif choose = "all" then
sql="Select * from OMS_Search where keyword like '%"& search1 &"%' order by OMS_No asc"
elseif choose = "any" then
sql="Select * from OMS_Search where keyword like '%"& search1 &"%' order by OMS_No asc"
end if
rs.Open sql, conn,3,3

<div>
<div class="content wysiwyg-content">
Good day!...<br />
<br />
i am doing a search engine and this is the error..What's the meaning of this?<br />
<br />
<br />
Error Type:<br />
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)<br />
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.<br />
<br />
<br />
thanks in advance..
</div>
</div>


Good day!...

i am doing a search engine and this is the error..What's the meaning of this?


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a worktable row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.


thanks in advance..

robust plan hint?

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.