pass a form input as a parameter to an access quer
I've seen a lot of code for VbScript and Ole Db (i'm using odbc) and am still confused!!
Basically I have the following code:
var dbConn = Server.CreateObject("ADODB.Connection");
var dbComm = Server.CreateObject("ADODB.Command");
dbComm.commandtext = "cityQuery";
dbComm.commandtype = adCmdStoredProc;
var objParam = dbComm.CreateParameter("City", adVarChar, adParamInput);
objCommand.Parameters("City") = "London";
dbComm.activeconnection = dbConn;
var rSet = Server.CreateObject("ADODB.Recordset");
I'm looking to return all records whose city value is 'London'
I'm trying to kinda copy VBScript examples but really am coming up against the wall...as i said...this is all pretty new territory to me.
Does anyone have some url's that will go through this on a pretty basic or simple level..
apologies for posting on two different sections...