<div>
Line 12 has the text &quot;(Line 13)&quot; in it...is that a copy/paste error or the source code?<br />
<br />
Line 12 should say:<br />
Set rsIndex = rsIndex_cmd.Execute<br />

</div>


Line 12 has the text "(Line 13)" in it...is that a copy/paste error or the source code?

Line 12 should say:
Set rsIndex = rsIndex_cmd.Execute


<div>
Hi,<br />
<br />
I have added this to indicate that this is line 13. &nbsp;this is not in my code<br />
<br />
Cheers Geoff
</div>


Hi,

I have added this to indicate that this is line 13.  this is not in my code

Cheers Geoff

<div>
Thanks for that, I was being dumb.<br />
Yes index was a reserved word
</div>


Thanks for that, I was being dumb.
Yes index was a reserved word

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I get this error message on my ASP web page. &nbsp;<br />
<br />
Any ideas <br />
Cheers Geoff<br />
<br />
Microsoft OLE DB Provider for SQL Server error '80040e14' <br />
<br />
Incorrect syntax near 'index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax. <br />
<br />
/index.asp, line 13 <br />
<br />
<br />
<br />
<br />

<pre><code id="code-318874">&lt;!--#include file=&quot;Connections/dboMTT_cs.asp&quot; --&gt;
&lt;%
Dim rsIndex
Dim rsIndex_cmd
Dim rsIndex_numRows 
Set rsIndex_cmd = Server.CreateObject (&quot;ADODB.Command&quot;)
rsIndex_cmd.ActiveConnection = MM_dboMTT_cs_STRING
rsIndex_cmd.CommandText = &quot;SELECT heading, [date], contentmain, photocaption, photocredit, photolink, readmore FROM dbo.index&quot; 
rsIndex_cmd.Prepared = true 
Set rsIndex = rsIndex_cmd.Execute (line 13)
rsIndex_numRows = 0
%&gt;
</code></pre>
</div>
</div>


Hi,

I get this error message on my ASP web page.  

Any ideas 
Cheers Geoff

Microsoft OLE DB Provider for SQL Server error '80040e14' 

Incorrect syntax near 'index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax. 

/index.asp, line 13 





ASP Error - Microsoft OLE DB Provider for SQL Server error '80040e14'

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.