Avatar of bertino12
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.
ASP.NET

Avatar of undefined
Last Comment
bertino12

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
lengreen

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
bertino12

ASKER
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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck