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