|
XmlPackage Exception: Exception=Error in XmlPackage(.RunSql), Package=[XmlPackages/csssecgridwithprices.xslt], Msg=[Exception=Implicit conversion from data type money to char is not allowed. Use the CONVERT function to run this query.
Implicit conversion from data type money to char is not allowed. Use the CONVERT function to run this query.
Implicit conversion from data type money to char is not allowed. Use the CONVERT function to run this query.], Sql=[
aspdnsf_PageQuery '
select top 1000 a.ProductID,a.Name,b.sectionid,
(select max(isnull(saleprice,price)) from productvariant c where c.productid = a.productid) as price,
cast(a.distributorid as varchar(100)) + isNull(cast(a.relateddocuments as varchar(100)),0) as nopic ,
a.producttypeid
from product a,productsection b
where a.ProductID = b.ProductID
and a.published = 1
and a.deleted = 0
and b.sectionid =8
order by a.producttypeid
', 'producttypeid', 1, 36, 0
]
|
|
