Error Type:ADODB.Recordset (0x800A0CC1) -URGENT

[dotnetdev1]

Hi Friends,
Wen I am rying to run my asp application.... i am ending up with this following error...

Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/assistdev/INCLUDES/GEN_INCLUDES/DSB_EN_HHSTU_cr tAP_HHSTU_001.a sp, line 92

and the code on line 92 is...

m_strDSBMealPla n = m_rstGroupRepea tData.Fields("M ealPlan").Value


please help me ASAP...THANKS

[idsanjeev]

Hi dotnetdev1
check your select statements fields thats you wants to display from table is in your table.
query not found your fields in table
thanks

[dotnetdev1]

Hi Sanjeev...Thank you very much for the reply...It will be great if you can tell me how can I check the fileds whether they are in my table...because I have added a columnn but not sure if it is correct or wrong...Please guide me in this

Thanks

[idsanjeev]

Hi dotnetdev1
You can easily check your table the column is added or not write code in sql editor

desc tablename

or

select *from tablename;

Thanks
jha