Hi,
I'm trying to get something to work. I have a Union query that I've already placed in a view and then made the view the datasource. I need to know if there is a way to pass a varable into the view using ASP Runner 4.1.
Here's the view:
SELECT dbo.imProduct.ProductID, dbo.imProduct.ExtendedCore, dbo.ApplyMarkup(dbo.imCaseGoods.NetPrice, ) AS Net, dbo.imProduct.ProductName,
dbo.imProduct.WSpecies, dbo.imProduct.OutsideDimensionString, dbo.imProduct.PriceListNarrative
FROM dbo.imProduct INNER JOIN
dbo.imCaseGoods ON dbo.imProduct.ProductID = dbo.imCaseGoods.ProductID
WHERE (dbo.imProduct.Status = 'A')
UNION
SELECT imProduct_1.ProductID, imProduct_1.ExtendedCore, CAST(dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGradeA, [color=#FF0000]1) AS money) AS Net,
imProduct_1.ProductName, imProduct_1.WSpecies, imProduct_1.OutsideDimensionString, imProduct_1.PriceListNarrative
FROM dbo.imProduct AS imProduct_1 INNER JOIN
dbo.imUphCase ON imProduct_1.ProductID = dbo.imUphCase.ProductID
WHERE (imProduct_1.Status = 'A')
In this view where you can see the bold/red "1" is where I need to change the variable. Is this possible in ASP Runner?
Thanks,
Corinne