ADO could not find the object

ROHO · Mar 1, 2002

<HTML>
<BODY>
<%
S_ID=REQUEST.FORM("STAFF_ID&quot

CH=REQUEST.FORM("CHARGES&quot

P_ID=REQUEST.FORM("PATIENT_ID&quot

TYPE_TEST=REQUEST.FORM("TYPE_TEST&quot

RESULT_TEST=REQUEST.FORM("RESULT_TEST&quot

REMARKS=REQUEST.FORM("REMARKS&quot

SET rs=server.createobject("adodb.recordset&quot

rs.locktype=2
rs.cursortype=3
rs.open "select * from x_ray","dsn=teledata"
rs.movelast

rs.addnew

rs("STAFF_ID&quot

=S_ID
rs("CHARGES&quot

=CH
rs("PATIENT_ID&quot

=P_ID
rs("TYPE_TEST&quot

=TYPE_TEST
rs("RESULT_TEST&quot

=RESULT_TEST
rs("REMARKS&quot

=REMARKS

rs.update
rs.close
%>
I HAVE WRITTEN THIS CODE AND IT IS GIVING ME ERRORS ADODB.Fields error '800a0cc1'

ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application.

/xray_rep.asp, line 20
uptill my info it seems to be alright

cmmrfrds · Mar 1, 2002

Do these table field names match up with the names in your table.
rs("STAFF_ID&quot

=S_ID
rs("CHARGES&quot

=CH
rs("PATIENT_ID&quot

=P_ID
rs("TYPE_TEST&quot

=TYPE_TEST
rs("RESULT_TEST&quot

=RESULT_TEST
rs("REMARKS&quot

=REMARKS

You don't mention the backend database, the names maybe case sensitive.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

ADO could not find the object

ROHO

Programmer

cmmrfrds

Programmer

Similar threads

Part and Inventory Search

Sponsor