Hi,
I am getting the above error in an asp page. Not sure why?
The error details is given below. I appreciate any insight
to the problem. Thanks.
The code is attached here. Line
24 is the SQL.open line.
Microsoft JET Database Engine (0x80040E0C)
Command text was not set for the command object.
/gwisbrandnewrea dy5/indvgrant2.asp, line 24
CODE:
<%@ Language=VBScri pt %>
<!--#include file="adovbs.in c" -->
<%Response.Buff er = True %>
<HTML>
<HEAD>
<META NAME="GENERATOR " Content="Micros oft Visual Studio 6.0">
</HEAD>
<%
myDSN="Provider =Microsoft.Jet. OLEDB.4.0;" & _
"Data Source=C:\_____ __GWISBRANDNEWR EADY5\GMISDATA. mdb"
set CN=server.creat eobject("ADODB. Connection")
CN.Open myDSN
'cirRS stands for recordset corresponding to the resulting parameterized query
set cirRS=server.cr eateobject("ADO DB.Recordset")
cirRS.ActiveCon nection = CN
Dim sFiscalStaff
sFiscalStaff = Request.QuerySt ring("lstFiscal Staff")
SQL = "SELECT * from GMISExpenseComb o1 where FiscalStaffIntI D = " &
sFiscalStaff
'Response.Write SQL
cirRS.Open
%>
<BODY>
<div ALIGN="CENTER">
<big><big><fo nt COLOR="navy">On-Line Grant Reporting System</font></big></big>
<H4>
<font COLOR="red">Lis ting Of Subgrants</font>
</H4>
</div>
<div align="center">
<%
Response.Write "<table border='1' width='80%' height='1' cellspacing='1' >"
Response.Write "<th>Key</th><th>Subgrant ID</th><th>Title"
%>
<%
do until cirRS.eof
Key = cirRS("IntID")
Subgrant = cirRS("ComboID" )
Title = cirRS("Title")
%>
<tr>
<td align="center">
<div style="cursor:h and"><p align="left"
OnClick="locati on.href='mainre portagain1.asp? GrantID=<%Respo nse.Write Key%>'">
<u><font color="#0000FF" >
<%Response.Writ e Key%></font></u></div></td>
<% 'this writes out the key%>
</td>
<td align='center'>
<font color="#000000" >
<%Response.Writ e Subgrant%>
<td align='left'>
<font color="#000000" >
<%Response.Writ e Title%>
</td>
</tr>
<%
cirRS.MoveNext
loop
%>
<input type="button" value="Log Out" name="btn_LogOu t" >
<input type="button" value="IndvGran t" name="btn_IndSu bgrant">
</BODY>
</HTML>
