[thelist] ASP error: Too few parameters.

[Herrick, Emma]

Does anyone know what this error means?

Too few parameters. Expected 9. 

I get it on my sql statement which works fine if I run it in access, but not
through ASP. 9 is the number of fields I'm retrieving from 2 tables. Is it
because I'm trying to do an update on one table with 2 tables open? Am I not
allowed to do that in ASP?

I've looked the error up on MS but none of the examples seems to apply to my
issue.

TIA!

Emma