Me, AGAIN (hangs head down in shame)
Below is code I am using to select all of the entries where Ticket_ID field is equal to OPEN. This is how I got it done but it comes back with an error.

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/Smc/ticket/view_tickets.asp, line 18



<%
ConnString = "DSN=ticketbackup;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open ConnString,,,adOpenForwardOnly
Set rs = SERVER.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM ticket where type LIKE '" & "%OPEN%" & "' ORDER BY Ticket_ID"
rs.Open strSQL,conn, adOpenStatic

%>

Once again it is probably pretty simple but me being new to this game...well u know what I am saying.

Thank you in advance

Hi there,

Take a look at this FAQ: http://www.adopenstatic.com/faq/80040e10.asp

It deals with 80040e10 errors.

You may want to rename the Type column, as Type is (or at least sounds like) a reserved keyword for Access.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

IMAR YOU ROCK :)

I fixed the previous error, now working on this:



<%
ConnString = "DSN=ticketbackup"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open ConnString,,,adOpenForwardOnly
Set rs = SERVER.CreateObject("ADODB.Recordset")

strSQL = "SELECT Ticket_ID FROM ticket WHERE Ticket_state = 'CLOSE' GROUP BY Ticket_ID ORDER BY Ticket_ID "

rs.Open strSQL,conn, adOpenStatic

%>

UP to heere all is well, after that I simply want to extract the recordset for Ticket_ID selected in the above query. Below is the code including form. It comes back to me with an error:



<form name="openedticket">
  <p><select name="open" size="1">
    <option value="NULL" selected>TICKET ID</option>
<% Do While Not rs.EOF
       Response.Write ("<OPTION value='"& rs("Ticket_ID") & "'>" & rs("Ticket_ID"))
       rs.MoveNext
       Loop
       rs.Close
       Set rs=Nothing
%> </select><input type="submit" value="View by Ticket ID">&nbsp;&nbsp;&nbsp; </p>
</form>
<%
 Set rs = SERVER.CreateObject("ADODB.Recordset")
     strSQL = "SELECT * FROM ticket "

     strST=Request.QueryString("open")
     strSQL = "SELECT * FROM ticket WHERE Ticket_ID = '" & strST & "'"


   response.write(strSQL)
    ' Open Recordset Object
    rs.Open strSQL,conn,adOpenStatic

%>

ELECT * FROM ticket WHERE Ticket_ID = ''

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

I think that I might be getting that error due to the fact that i am performing that operation on Ticket_ID, whihc is set to Autonumber (recordID)

any thought???

I confirmed it, I was getting the error because of the Ticket_ID was is set to Autonumber.

If Ticket_ID is a number (any number, not just AutoNumber), you can't use an apostrophe to enclose the value:

strSQL = "SELECT * FROM ticket WHERE Ticket_ID = " & strST

You may also want to check out this article: http://www.adopenstatic.com/faq/selectstarisbad.asp and find out why SELECT * is bad...

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.