Theme Party Supplies
- Home
- Supplies
Unable to cast object of type 'System.DBNull' to type 'System.String'.
at System.Data.Odbc.OdbcDataReader.GetString(Int32 i)
at Views_Products_V3.GetAllProductImages()
select
P.Category, I.ImageFolder, I.ThumbnailFolder, I.ImageFolder, I.ImageFileName, P.ProductName, T.ThemeName, P.ShortName, P.URLId,P.Price BasePrice, I.Price, P.PriceUnit
from
(select
max(id) id,
P.ProductName
from
imagelibrary I
left join products P on P.PId = I.PId
where
I.Enabled='Y'
group by P.ProductName order by id desc) t
left join imagelibrary I on I.Id = t.Id
left join themes T on T.TId = I.TId
left join products P on P.PId = I.PId
left join productcategories PC on PC.Category = P.Category
where
T.Enabled = 'Y' and I.Enabled = 'Y'
order by PC.OrderNo, P.OrderNo