Click here to Skip to main content
15,560,073 members

Comments by Mitesh Prajapati14 (Top 5 by date)

Mitesh Prajapati14 13-Dec-14 2:01am View    
You need to store cart products into session. when user will logged in then you need to save that session object values into database with customer id.
Mitesh Prajapati14 13-Nov-14 2:06am View    
As per your stored procedure, you can define like this:

DECLARE @isInfo INT

SELECT @isInfo = f.IsNFO FROM FAInvStatic Where <<your where condition>>

IF ISNULL(@isInfo, 0) = 1
BEGIN
<<your condition here>>
END
ELSE
BEGIN
<<your condition here>>
END
Mitesh Prajapati14 13-Nov-14 1:43am View    
Can you post your stored procedure here? so we can give you best solution
Mitesh Prajapati14 12-Nov-14 1:51am View    
first check your image path on webserver. may be your image path is wrong.
Mitesh Prajapati14 12-Nov-14 1:02am View    
As per your code you need to pass record primary key in where condition. so it will not update all the record in db.

Current query will update all status where status='N'

your new query should be like this :
"update tbldata set status='Y' where status='N' and id=@id"