Link to home
Create AccountLog in
Avatar of bertino12

asked on

ASP command text problem

I have this code:

sql = "select * from dms_documents dd, dms_law_docs dld where dd.doc_id = " & doc_id & " and dd.doc_id = dld.doc_id and published = 1"

Set oCmd = Server.CreateObject("ADODB.Command")
With oCmd
      .ActiveConnection = conn
                .CommandType = adCmdText
      .CommandText = sql
      .Parameters.Append .CreateParameter("chamber_id", adChar)
      .Parameters.Append .CreateParameter("sortcode", adVarChar)
      .Parameters.Append .CreateParameter("folder_id", adVarChar)
end with
Set rst = oCmd.Execute
Set oCmd = Nothing

Im getting this error:
Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/lss/lss.asp, line 117

Line 117 is this:      .CommandType = adCmdText

I have tried all the other parameters and they didnt work.
Avatar of lengreen

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of bertino12


Giving me a new error, but now on line 119
 .Parameters.Append .CreateParameter("chamber_id", adChar)

Error Type:
ADODB.Parameters (0x800A0E7C)
Parameter object is improperly defined. Inconsistent or incomplete information was provided.
/lss/lss.asp, line 119

In the oracle database here is the data types

chamber_id   char(1)
sortcode        varchar2(1000)
folder_id        number