hey everybody, i got a quite interesting problem :(

the error message is the following:

--

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

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

--



as i started to look around the net, using search engines all answers 

to this error I found were in connection with INSERT sql commands.

in my case, i just use a dinamic sql select statement: the user 

selects, which field(s) he wanna see, and I put together the sql 

statement in Javascript and store it in a hidden form field 

named "heading", which I pass on to the display.asp file to make the 

table.

the problem is that there is on category, which includes 5-6 fields 

from the table and they have the same "order" number. so, when i wanna 

loop thrpough them, it sucks :(

here is the code extract:

--------------------

	MYSQL = Request.Form("heading")

	rs.Open MYSQL, dc, 1, 3    'opens the database

	

	Dim a

	a=0

	

	Do While (Not rs.EOF)



	 if rs("order") = 22 then

	  Do While (rs("order") = 22)

			a = a + 1

	  rs.MoveNext

	  Loop

%>

	<td>Systems to be integrated</td>

<%else%>

	<td><%=rs("Description")%></td>

<%  

	end if

	rs.MoveNext  

	Loop  

%>

--------------------------



anybody any ideas why it sux?



 peter

www.adopenstatic.com/faq/80040e10.asp



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Zsoldos Péter" <paz@c...>

Subject: [asp_databases] 80040e10 error





: hey everybody, i got a quite interesting problem :(

: the error message is the following:

: --

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

: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 8

: --

:

: as i started to look around the net, using search engines all answers

: to this error I found were in connection with INSERT sql commands.

: in my case, i just use a dinamic sql select statement: the user

: selects, which field(s) he wanna see, and I put together the sql

: statement in Javascript and store it in a hidden form field

: named "heading", which I pass on to the display.asp file to make the

: table.

: the problem is that there is on category, which includes 5-6 fields

: from the table and they have the same "order" number. so, when i wanna

: loop thrpough them, it sucks :(

: here is the code extract: