Just append the parameter values with the query name from the front end.
For example, say a query in access has the pattern:catId = [categoryId].
It indicates that categoryId has to be supplied to this query.
From the front end, you can use:strQuery = ” qry_name ‘ ” & numCategoryID & “‘”
//VB.Net/ASP platform
ASP Code:
Dim numCategoryIDnumCategoryID = Request.Form("CategoryID")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/cats.mdb")
Set objRS = Server.CreateObject("ADODB.Recordset")
strQuery = "qry_name ' " & numCategoryID & "'"
objRS.Open strQuery, objConn, 0, 4
From: http://sitestree.com/?p=5216
Categories:2
Tags:
Post Data:2007-01-11 23:23:02
Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a>
In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
<a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
