Element RECORDCOUNT is undefined

[rajva]

I'm getting the above error message when using <cfif Get_User_Vendors.RecordCount GT "0">. This has been working for more than 2 years but started giving this error since few days, it is weird. This error is coming if the stored procedure returns no records. If there are some records it is not giving any error. I'm using sql server 2000 database. I've attached the sample code. Any solution is appreciated.

[Daverms]

Hi,

Put your statements like this,

[rajva]

Thanks Daverms. It works. I'm not sure why it is behaving only for the last few days. Onceagain thanks for your timely help.