ASP/SQL error message

[Micromanaged]

Getting the following error message:

Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/safedevelopment/Credit/FairIsaac.asp, line 20

From this code:
Set cn = Session("cnn")
Set rstPhones = Server.CreateObject("ADODB.Recordset")

'CID = Session("CID")
'SID = Session("SID")

if ID > -1 then
set SQL= cn.Execute("SELECT Customers.[Company Name],
Customers.[Address Line 1], " & _
"Customers.[Address Line 2], Customers.City, Customers.State,
Customers.Zip, " & _
"Customers.[Company Phone],Customers.[Business Structure]FROM Customers
INNER JOIN Schedule on " & _
"Customers.[ID]=Schedule.[customer id]")

rstPhones.Open SQL, cn, adOpenDynamic, , adCmdText
end if

Ideas? Pointers? Tips? on what I am doing wrong would be appreciated.

Thanks in advance.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Mike]

VB script doesn't know what VB constants are, so it doesn't know what
'adOpenDynamic' is supposed to mean.
make an #include to 'adovbs.inc' or use the number constant instead of the
variable.
"Micromanaged" <no*****@nospam.org> wrote in message
news:OX**************@TK2MSFTNGP11.phx.gbl...

Getting the following error message:

Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/safedevelopment/Credit/FairIsaac.asp, line 20

From this code:
Set cn = Session("cnn")
Set rstPhones = Server.CreateObject("ADODB.Recordset")

'CID = Session("CID")
'SID = Session("SID")

if ID > -1 then
set SQL= cn.Execute("SELECT Customers.[Company Name],
Customers.[Address Line 1], " & _
"Customers.[Address Line 2], Customers.City, Customers.State,
Customers.Zip, " & _
"Customers.[Company Phone],Customers.[Business Structure]FROM Customers
INNER JOIN Schedule on " & _
"Customers.[ID]=Schedule.[customer id]")

rstPhones.Open SQL, cn, adOpenDynamic, , adCmdText
end if

Ideas? Pointers? Tips? on what I am doing wrong would be appreciated.

Thanks in advance.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bob Barrows [MVP]]

Micromanaged wrote:

Getting the following error message:

Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are
in conflict with one another.
/safedevelopment/Credit/FairIsaac.asp, line 20

..
http://www.aspfaq.com/show.asp?id=2112

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Aaron [SQL Server MVP]]

> set SQL= cn.Execute("...

Here you have a recordset object

rstPhones.Open SQL, cn, adOpenDynamic, , adCmdText

The open statement doesn't expect a recordset object where you've placed it.
Replace the two above lines with:

set rstPhones = cn.Execute("...

And drop the Server.CreateObject("ADODB.Recordset") line.