Hi all.

EDIT: Sorry for the spelling error in the thread title. I must be showing off my wonderful typing skills.


Its been awhile since I was here last. I am having a problem with a simple statment to call records from a MS Access database. I get the error:


Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /pages/general_page/default.asp, line 14

(line 14 is gonna be this line: Rs.Open sql, Conn )


I have looked this error up on MS, and they seem to think that one of my database columns don't match. I have checked, doublechecked, and triplechecked, and this is not the case. Any ideas?

 
<% 
Dim Conn
Dim Rs
Dim sql
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.Recordset")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/pathtomydatabase/database.mdb")
sql= "SELECT * FROM custompages WHERE 'custompageurl'="& Request.QueryString("custompageurl") &"" 
Rs.Open sql, Conn 
%>
 
<% Response.Write ("<h3>" & Rs("title") & "</h3>") %>
<% Response.Write ("<p>" & Rs("content") & "</p>") %>
<% Rs.MoveNext %>
<%
Loop 
Rs.Close
Set Rs = Nothing
Set Conn = Nothing
%>

Thanks.

try;

sql= "SELECT * FROM custompages WHERE 'custompageurl' = '"& Request.QueryString("custompageurl") &"' ;"

two debug checks;
response.write out the value of sql to see if it is what you would expect response.write the value of the querystring to ensure that it has a value and/or test for a value before calling the routine.

Follow Hirst's advice. In particular, Response.Write(some debug info here) is an invaluable tool. Since you can't debug old school ASP code, this is the best tool in our box for figuring out what went wrong.

When MS Access throws the "Too few paremeters - expected x" error, it means that it doesn't understand something in your query, and has decided to make that a parameter. Which is a pretty good guess on its part, but not always right. For example ( and try this with me ), if you set up a query that says "SELECT * FROM custompages WHERE custompageurl = someURL" and then execute the query, before it actually runs, it will give you a dialog box asking for a value for someURL. Then it will run the query using that value. Only, dialog boxes don't work on the web, so instead it throws an error if there's a parameter it doesn't have a value for. If you drop in your query string, it's going to see it as an unknown field, and assume it's a parameter.

Next, I think there's a mistake in your SQL and carried over into Chris's example. If custompageurl is a field in your talbe, you don't want single quotes ( ' ) around it.

Sorry for taking so long to get back. I was on vacation.


sql= "SELECT * FROM custompages WHERE 'custompageurl' = '"& Request.QueryString("custompageurl") &"' ;" worked perfectly

Thank you all.