A
Arpan
A MS-Access database has the following Query:
PARAMETERS [CName1] Text (255), [Company1] Text (255), [NoteNo1] Text
(255);
SELECT IIf(IsNull([Quantity]),"0",[Quantity]) AS MyQuantity
FROM MyTable
WHERE CName=[CName1] And Company=[Company1] And NoteNo=[NoteNo1];
When I run the above query, I am prompted to enter a value for the 3
input parameters - CName1, Company1 & NoteNo1 - & accordingly, the
Query retrieves the appropriate 'Quantity' record.
I want to invoke the above Query from a ASP.NET page & return the
resultset (which will be just the 'Quantity' record) to the ASP.NET
page. Depending upon whether the Query returns 0 or any number greater
than 0, I want to execute different functions in the ASP.NET page.
Is there any way by which I can make the Query return the 'Quantity'
record to the ASP.NET page?
PARAMETERS [CName1] Text (255), [Company1] Text (255), [NoteNo1] Text
(255);
SELECT IIf(IsNull([Quantity]),"0",[Quantity]) AS MyQuantity
FROM MyTable
WHERE CName=[CName1] And Company=[Company1] And NoteNo=[NoteNo1];
When I run the above query, I am prompted to enter a value for the 3
input parameters - CName1, Company1 & NoteNo1 - & accordingly, the
Query retrieves the appropriate 'Quantity' record.
I want to invoke the above Query from a ASP.NET page & return the
resultset (which will be just the 'Quantity' record) to the ASP.NET
page. Depending upon whether the Query returns 0 or any number greater
than 0, I want to execute different functions in the ASP.NET page.
Is there any way by which I can make the Query return the 'Quantity'
record to the ASP.NET page?