Foteorpongers
New Member
I'm trying to convert a SQL Server 2008 R2 Express query in ASP-Classic that is not parameterized so I did the following (see code below) but I keep getting an error saying: \[quote\] Object doesn't support this property or method: 'Parameters'\[/quote\]Can someone please tell me what am I doing wrong!Thanks!\[code\]<%' OPEN DATABASEdim objConn, objRS, objTRS, objUnitdim strConnectionset objConn = Server.CreateObject("ADODB.Connection")objConn.ConnectionString = "Driver={SQL Server};Server=MSSQLSrv;Database=DbTest;UID=blablabala;PWD=blablabala"objConn.Open strConnectionset objRS = Server.CreateObject("ADODB.Recordset")set objRS.ActiveConnection = objConnstrQuery = "SELECT USERNAME,PASSWORD from CUSTOMERS where EMAIL=?"objRS.Parameters(0) = Request.QueryString("email")objRS.Open strQuery%>\[/code\]