Row navigation grid problem?

[Guest_imported]

In the Recodset1_onbeforeopen function, (in my asp file), I use multiple Request.Form("value&quot to get the values posted from my htm file. I store these Request.Form values in values I create using Dim(ie. Dim hi = Request.Form("value&quot). In which I use if statements to check if values are not empty for use in my stored procedure.

Before the asp file is displayed I assign the values using getparameter into a stored procedure, and then I output the results onto a grid! I also enable row navigation and use the =Grid1.anchor[("ssn&quot] method, so that the row is highlighted.

My problem:
The grid displays fine, no problem and the grid.anchor looks good, but;
Everytime I select the anchor from the grid, the page breaks, and an error reveals that setparameter was expecting a value (ie @ssn) in my stored procedure. Is there anway to prevent this error from showing everytime I navigate through a row to select my information?

I tried setting the recordset implementation tab to Preserv in session state, but I get the same error message all the time, expecting a value to be passed to the stored procedure! The weird thing is, it works sometimes, butthen I see that abaove error whenever I set the Recodset to be preserved in session state. Very moody, can anyone explain that?

What can I do to allow me to make selections on the grid, and not have it quit on me with errors? Thank You!

 

[computergeek]

Hi,

Do you set the parm value for your recordset (attached to proc) within the onbeforeopen() event for the recordset? For Example:

Sub rsCompanyGrid_onbeforeopen()
Call rsCompanyGrid.setParameter(1,Session("CompanyId&quot)
End Sub

I am having trouble setting the anchor... what was your exact syntax?
=mygrid.anchor([column1])
=mygrid.anchor("column1&quot
=mygrid.anchor[column1]

Every time I try to display my grid with the anchor NOTHING is display?!

Computergeek