Get 'Too few parameters' errors sometimes

[Rally2002]

Hi!

Sometimes I get an "Too few parameters" error when trying to access an database. I have read in this forum that other users have experienced this too. However, I only get this error about 1 out of 10 times. When the error occurs, it sufficient to reload the page and the error goes away.

I don't think there is any problem with the SQL statement since a reload will fix the problem. Could there be some timing issues when the web servers access the database?

/Rally2002

 

[harmmeijer]

Are you sure you're not using session variables to generate the sql query.
I suggest response.writing the sql query to the html page and when the error occures running it in the sql query analyzer.