Thread: Query Help

If you run the first query, you will get the result as '65195' If you run the second query, you will get the same result. What I need to do is, if 65195 exists in both the tables (productblocking and productallowlist), the query should return no result. If it just exists in productblocking table, it should return the result. How to do this?

SELECT p.productid
FROM product p
JOIN productblocking pb ON p.productid=pb.productid
WHERE customerlevelid='5' and p.productid = '65195'

SELECT p.productid
FROM product p
JOIN productallowlist pa ON p.productid=pa.productid
WHERE customerlevelid='5' and p.productid = '65195' and customerid='62030'

You could use the NOT IN keyword.

I tried but didn't work.

Try this :-


SELECT productid FROM productallowlist where productid NOT IN (select productid from product where customerlevelid='5' and p.productid = '65195' and customerid='62030');


TTFN

BFG

No, it didn't work.

I need help here. There is a query statement in one of the .cs pages.

ds = db.GetData("select ImageForDisplay from productblocking where productid=" + ProductID + " and customerlevelid=" + CustomerLevelID);

I need to change this query to

select ImageForDisplay from productblocking
where productid=" + ProductID + " and customerlevelid=" + CustomerLevelID
UNION
select ImageForDisplay from categoryblock
where categoryid=" + CategoryID + " and customerlevelid=" + CustomerLevelID

how can I do this? When I try to change, I get an error.

How can I call the data from a column in a table to a .cs file? Here is what I tried but it compiles without any errors but when I set breakpoints, categoryDiscount is not getting the data. How can i fix this?


int categoryDiscount = 0;
DataRow[] drCatDiscount = dsProducts.Tables[1].Select("productid=" + pdId);
if (drCatDiscount.Length > 0)
categoryDiscount = DB.RowFieldInt(drCatDiscount[0], "discountpercent");

If such isn't getting any data I'd recommend trying to definitively determine if the data for which you're looking contains that data you expect. If there are no rows resulting from your .Select such might explain the behavior you're seeing.

Dusty
ASPDotNetStorefront Staff