ADODB.Recordset (0x800A0CC1)

crmpicco · November 16th, 2005, 08:37 AM

Code:

            
set rsAddAgent = con.execute("INSERT INTO `net_company` (agencyid, companyid, apicorp_id, apiusername, password, ip, port, agencyoffice) "_
&"VALUES('" & UCase(Trim(agencyid)) & "','" & UCase(Trim(consolidatorid)) & "','" & Trim(rsConDetails("apicorp_id")) & "',"_
&"'" & Trim(rsConDetails("apiusername")) & "','" & Trim(rsConDetails("password")) & "','" & Trim(rsConDetails("ip")) & "','20002',"_
&"'" & Trim(rsConDetails("agencyofficeid")) & "')", adCmdText)

Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
asp/admin/companies/add_companies2.asp, line 605

I keep getting this error on this lines??

Cant spot it?

Picco

www.crmpicco.co.uk

ChrisScott · November 16th, 2005, 09:44 AM

Looks like one of the fields in rsConDetails you are trying to access does not exist.

As you are inserting an "agencyofficeid" field into an "agencyoffice" field, should it also be "agencyoffice".

If not, just try Response.Write'ing each of the rsConDetails fields out, that should pinpoint it.

crmpicco · November 16th, 2005, 10:28 AM

thank chris, i found the error. thats what it was, i thought it would still insert into the db though - but it just threw an error instead.

www.crmpicco.co.uk