update db in sqlserver

[gubendran]

Hi gurus,

I have a table, which i want to view and edit when i click on myprofile link. but i am getting error like adofields error '800a0cc1' . but i am matching with that combo box such <option><%=rs("country")%> </option>. in this some text fields are displaying values properly.

can you help me?

[vishu_gupt]

Originally posted by gubendran
Hi gurus,

I have a table, which i want to view and edit when i click on myprofile link. but i am getting error like adofields error '800a0cc1' . but i am matching with that combo box such <option><%=rs("country")%> </option>. in this some text fields are displaying values properly.

can you help me?

Hi,
According to the problem notes youhave specified above, it seems that you are getting the following error:
"ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application". May be you are using a wrong field name which is not there in table or in the selection list of the query.
If this is not the case, Please give me more details about the problem.

Vishal