I get this error at the last line,
80040e21 The requested properties cannot be supported.
Code
objCmd.CommandText = "SELECT * FROM t_keywords WHERE portal_id= [@portalid] ORDER BY keyword_order"
objCmd.CommandType = adCmdText
'Create the parameter and populate it.
Dim objParam
set objParam=Server.CreateObject("ADODB.Parameter")
objParam.Name = "@portalid"
objParam.Type=adVarChar
objParam.Size=25
objParam.Direction=adParamInput
objParam.Value= "disposal"
objCmd.Parameters.Append objParam
'objCmd.Parameters("@productid") = "disposal" 'Return the product with ProductID = 15
'Open and display the Recordset.
objRS.Open objCmd
Does anyone know why?
80040e21 The requested properties cannot be supported.
Code
objCmd.CommandText = "SELECT * FROM t_keywords WHERE portal_id= [@portalid] ORDER BY keyword_order"
objCmd.CommandType = adCmdText
'Create the parameter and populate it.
Dim objParam
set objParam=Server.CreateObject("ADODB.Parameter")
objParam.Name = "@portalid"
objParam.Type=adVarChar
objParam.Size=25
objParam.Direction=adParamInput
objParam.Value= "disposal"
objCmd.Parameters.Append objParam
'objCmd.Parameters("@productid") = "disposal" 'Return the product with ProductID = 15
'Open and display the Recordset.
objRS.Open objCmd
Does anyone know why?