2. ASPRunnerPro General questions
  3. Parameter query
This topic is locked

Parameter query

 		8/22/2008 2:39:47 AM
ASPRunnerPro General questions
E
 ehoff author

Hello,
I have created a query in MS access.

This query requires a parameter (a double) to excecute.
When I generate straight forward the code and open the list page it will come up with the message:

__

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/include/commonfunctions.asp, line 1060

___
Is there a way I can ask the user to fill in the parameter or provide the parameter to the url via a post.
Thanks!

Erik
J
 		Jane 8/22/2008

Hi,
unfortunately ASPRunner do not support queries with parameters.

As workaround you can use search or advanced search to enter your parameter or pass parameter through URL and then add it to the SQL query in the List page: Before SQL query event on the Events tab.
E
 		ehoff author 8/22/2008

Jane,
Do you mean I should rewrite my query and put the SQL logic to the advanced query mode?

Is the parameter issue on the wish list for new releases?
regards,

Erik