Hi all! up to now, whenver Ive needed a recordset ive been creating it through the dmx application panel, which drops the sql in the code, however i am now needing to create some fairly complicated queries and I would rather create them as stored queries in access and then call them through asp.

I have managed to get a simple stored query to run through dmx's 'add recordset' but I have not managed to get a parameterised query to run. I end up with the error "Too few parameters. Expected 1". I would really like still to be able to add the recordset through dmx's 'add recordset' in the application panel.

Any help would be massively appreciated.