[IndexOutOfRangeException: SearchTerm]
System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +2158731
System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +141
NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name) +57
NHibernate.Persister.Entity.AbstractEntityPersister.Hydrate(IDataReader rs, Object id, Object obj, ILoadable rootLoadable, String[][] suffixedPropertyColumns, Boolean allProperties, ISessionImplementor session) +1340
NHibernate.Loader.Loader.LoadFromResultSet(IDataReader rs, Int32 i, Object obj, String instanceClass, EntityKey key, String rowIdAlias, LockMode lockMode, ILoadable rootPersister, ISessionImplementor session) +533
NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, String rowIdAlias, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session) +245
NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session) +631
NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies) +405
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +1346
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +217
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +160
[GenericADOException: could not execute query
[ select top 6 t.* from csc_product t inner join csc_ProductPrice pp on pp.ProductID=t.ProductID where pp.PriceGroupID=@p0 AND t.productcode in (select p.productcode from csc_Product p inner join csc_ProductParent cs on cs.ProductID=p.ProductID inner join csc_CategoryRelation cr on cr.CategoryID=cs.CategoryID where p.Status & 2 = 0 and ((cs.CategoryID=@p1 AND cr.SeniorityID='00000000-0000-0000-0000-000000000000') OR cr.SeniorityID=@p1)) order by t.DisplayOrder DESC, t.ProductCode ASC ]
Name:CategoryID - Value:4d934c65-d504-49a4-9b98-41d6a30ea281 Name:PriceGroupID - Value:eb06341f-3602-4054-b38a-d5bf676baebc
[SQL: select top 6 t.* from csc_product t inner join csc_ProductPrice pp on pp.ProductID=t.ProductID where pp.PriceGroupID=@p0 AND t.productcode in (select p.productcode from csc_Product p inner join csc_ProductParent cs on cs.ProductID=p.ProductID inner join csc_CategoryRelation cr on cr.CategoryID=cs.CategoryID where p.Status & 2 = 0 and ((cs.CategoryID=@p1 AND cr.SeniorityID='00000000-0000-0000-0000-000000000000') OR cr.SeniorityID=@p1)) order by t.DisplayOrder DESC, t.ProductCode ASC]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +497
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +23
NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) +265
NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) +177
NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) +177
NHibernate.Impl.SqlQueryImpl.List() +213
CyberEcom.CSC.Business.ProductManager.GetProducts(Category category, Boolean includeSubCategories, IList`1 displayValues, PriceRange range, SiteUser user, Manufacturer manufacturer, ProductOrderBy orderBy, Int32 pageIndex, Int32 pageSize, Int32 maxResult, Int32& count, Nullable`1 includeHidden) in D:\CyberStore\Sybott.ESW\src\CyberEcom.CSC.Business\Product\ProductManager.cs:3701
Controls_Product_ProductInCategory.Page_Load(Object sender, EventArgs e) +1568
System.Web.UI.Control.OnLoad(EventArgs e) +108
System.Web.UI.Control.LoadRecursive() +90
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Control.LoadRecursive() +185
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533
|