Click here to Skip to main content
16,009,112 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Unable to set ImageUrl Pin
WinSolution27-Aug-08 1:58
WinSolution27-Aug-08 1:58 
GeneralRe: Unable to set ImageUrl Pin
lune1227-Aug-08 2:04
lune1227-Aug-08 2:04 
GeneralRe: Unable to set ImageUrl Pin
WinSolution27-Aug-08 2:13
WinSolution27-Aug-08 2:13 
GeneralRe: Unable to set ImageUrl Pin
lune1227-Aug-08 2:30
lune1227-Aug-08 2:30 
GeneralRe: Unable to set ImageUrl Pin
UD(IA)27-Aug-08 3:46
UD(IA)27-Aug-08 3:46 
QuestionRe: Unable to set ImageUrl Pin
lune1227-Aug-08 4:30
lune1227-Aug-08 4:30 
Questionsave file in javascript Pin
needhi_p27-Aug-08 1:10
needhi_p27-Aug-08 1:10 
AnswerRe: save file in javascript Pin
eyeseetee27-Aug-08 1:28
eyeseetee27-Aug-08 1:28 
AnswerRe: save file in javascript Pin
Manas Bhardwaj27-Aug-08 1:33
professionalManas Bhardwaj27-Aug-08 1:33 
Answersave file in javascript Pin
needhi_p27-Aug-08 18:57
needhi_p27-Aug-08 18:57 
GeneralRe: save file in javascript Pin
The Web Developer27-Aug-08 20:17
The Web Developer27-Aug-08 20:17 
GeneralRe: save file in javascript Pin
needhi_p27-Aug-08 22:33
needhi_p27-Aug-08 22:33 
QuestionIntranet/Internet Authentication in 2.0 Pin
DotNetMan27-Aug-08 0:41
DotNetMan27-Aug-08 0:41 
Questionquerystring Pin
niki_nilu27-Aug-08 0:29
niki_nilu27-Aug-08 0:29 
AnswerRe: querystring Pin
eyeseetee27-Aug-08 0:35
eyeseetee27-Aug-08 0:35 
GeneralRe: querystring Pin
neilmajithia27-Aug-08 4:07
neilmajithia27-Aug-08 4:07 
AnswerRe: querystring Pin
Bardy8527-Aug-08 1:51
Bardy8527-Aug-08 1:51 
GeneralRe: querystring Pin
Manas Bhardwaj27-Aug-08 2:00
professionalManas Bhardwaj27-Aug-08 2:00 
GeneralRe: querystring Pin
niki_nilu27-Aug-08 3:19
niki_nilu27-Aug-08 3:19 
GeneralRe: querystring Pin
The Web Developer27-Aug-08 20:21
The Web Developer27-Aug-08 20:21 
GeneralRe: querystring Pin
niki_nilu27-Aug-08 22:59
niki_nilu27-Aug-08 22:59 
AnswerRe: querystring Pin
D4ever28-Aug-08 9:08
D4ever28-Aug-08 9:08 
Questionneed help with inner join and oount sql server 2005 and asp.net 2005 Pin
VijayVishwakarma27-Aug-08 0:20
VijayVishwakarma27-Aug-08 0:20 
hi,
I m trying to get values from three tables.
1) its has the sale id and product id
2) it has the product details based on id from 1st table,
3) it has the quantity of product being selected by the query.
My problem is I need to check the count of the product based on various sizes and if its more than 0 i need to display available else sold out.

I tried the following query.

if I remove the count it works well to get the details but If I m gonna get the count it throws error.

any suggestion where this query is wrong??


SELECT SaleProduct_tb.ProductId, Product_tb.BasePrice, Product_tb.SalePrice, Product_tb.PName, Product_tb.Image1, COUNT(ProductSizeQty.Quantity)
AS Expr1
FROM SaleProduct_tb INNER JOIN
Product_tb ON SaleProduct_tb.ProductId = Product_tb.ProductId INNER JOIN
ProductSizeQty ON Product_tb.ProductId = ProductSizeQty.ProductId
WHERE (SaleProduct_tb.SaleId = @SaleId) AND (SaleProduct_tb.CatId = @CatId) AND (SaleProduct_tb.SubCatId = @SubCatId) AND
(Product_tb.BrandId = @BrandId) ORDER BY saleProduct_tb.ProductId


after this count is found I will need to check if its more than 0 then the text should be available else not available.

any suggestion. I m using asp.net 2005

Vijay V.

Yash Softech

AnswerRe: need help with inner join and oount sql server 2005 and asp.net 2005 Pin
NeverHeardOfMe27-Aug-08 0:25
NeverHeardOfMe27-Aug-08 0:25 
GeneralRe: need help with inner join and oount sql server 2005 and asp.net 2005 Pin
VijayVishwakarma27-Aug-08 0:49
VijayVishwakarma27-Aug-08 0:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.