Hello,
    I'm having some trouble getting a SQL Query to work. It seems pretty basic so I'm not sure what the problem is. The error message I'm receiving is Microsoft JET Database Engine error '80040e10' No value given for one or more required parameters. /boe/index.asp, line 178. Line 178 is the set rs=db.execute(qs4) line. Any help would be hot. The code is below.


set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data_file_path"

qs4="Select heading, link, description, picture From tblboe Where category=agenda Order by priority, description;"

Response.Write("Sql String = " & qs4 & "<Br>")

set rs=server.createObject("adodb.recordset")
set rs=db.execute(qs4)

I figured it out. In the following code I needed to add delimeters around the Where clause. (Where category='agenda')

qs="Select heading, link, description, picture From tblboe Where category='agenda' Order by priority, description;"