Item cannot be found in the collection corresponding to the requested name or ordinal.
- From: anthonybrough@xxxxxxxxxxxxxx
- Date: 27 Sep 2006 15:07:19 -0700
I am trying to get a value from a RETURNING statement on an Oracle
database and write the result on the same ASP page, but I am getting
the error:
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested
name or ordinal.
<<<>
This the code that I am using,
conn.beginTrans
sql = "INSERT INTO tbltest(REGID) Values (tbltest_SEQ.nextval )"
conn.execute SQL
sql = "Insert into tblreg_Account (REGID, Account1) Values
(tbltest_SEQ.currval, '" &strAccount &"')RETURNING REGID into
:return_REGID "
set r = conn.execute (sql)
response.write r.fields("return_REGID").value
conn.commitTrans
If I leave out :
set r = conn.execute (sql)
response.write r.fields("return_REGID").value
the code executes no problem.
I would be grateful of any pointers in how to resolve.
Regards
Tony
.
- Follow-Ups:
- Re: Item cannot be found in the collection corresponding to the requested name or ordinal.
- From: Bob Barrows [MVP]
- Re: Item cannot be found in the collection corresponding to the requested name or ordinal.
- Prev by Date: RE: Creating dbf table using ADO Recordset open method
- Next by Date: Re: Item cannot be found in the collection corresponding to the requested name or ordinal.
- Previous by thread: RE: Creating dbf table using ADO Recordset open method
- Next by thread: Re: Item cannot be found in the collection corresponding to the requested name or ordinal.
- Index(es):
Relevant Pages
|
