How can I substitute data passed via a hidden form field from another page
into an array? I can't seem to make it happen.
I'm taking a dynamic SQL string composed on one page and substituting the SQL
string into an array that sets up a recordset connection on another page. So
I have a hidden form with a <% =strSQL %> value given the an action that names
the result page.
On the result page, I declare the var strSQL = Request.Form("searchSQL").
Then I try substituting this variable into the array, which goes something
like this: new Recordset("RSsearch", "dsn", "userID", "password", strSQL,
etc.).
The SQL string appears, when I write it to the search page, to be okay, but
it's not passing properly into the array. I just get an error message
referring to the support scripts, and the support script cited is the one that
opens the recordset.
Help? Ideas?