Trouble with SQL statement
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>")