Querry Help
-
I have created a small querry and for some reason my container (datalist) is not reconizing the company name
This is also the first time that i have created a querry with two select statements in the sproc....
Does it make a difference if there is two select statements in a querry?? When populating a datalist?
Not sure if i need to seperate the two statements some kind of way..
Is this ok to use with datalist?
Erik..
ALTER PROCEDURE Get_Information_For_Datalist_Global_
@IDProduct AS INT,
@IDCompany AS INT
AS
SELECT Product.ProductName,
Product.ProductID,Product.ProductImage,
Product.ProductDescription, SprocsTable.*
FROM Product
INNER JOIN
SprocsTable ON Product.ProductID = SprocsTable.ProductID
WHERE Product.ProductID = @IDProduct
SELECT Company.CompanyID, Company.CompanyName
FROM COMPANY
WHERE COMPANY.COMPANYID = @IDCompany
Dam again!
-
This will generate 2 recordsset. In ADO we can use NextRecordset. Refer http://msdn.microsoft.com/library/default.asp?url=/library/en-s/ado270/htm/mdmthnextrecx.asp
I hope this helps
Kindest Regards,Amit Lohia
-
I am getting an error when i try to go to that page
Dam again!
-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthnextrec.asp
if this does not work. Google on nextrecordset
Kindest Regards,Amit Lohia
-
Thank you very much!
Very helpfull!
Eriik....
Dam again!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply