asp_databases thread: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another
Message #1 by "Omaro" <omaro@o...> on Thu, 24 May 2001 05:00:40
|
|
I am getting this 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.
here is my code
Dim SQL
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open("DSNoplusplus")
stringSQL = "SELECT Clients.Zip, DoctorsListing.Doctor_First_Name,"&_
"DoctorsListing.Doctor_Last_Name,DoctorsListing.Office_Name
,"&_
"DoctorsListing.Street_Address, DoctorsListing.City,
DoctorsListing.State,"&_
" DoctorsListing.Zip FROM DoctorsListing INNER JOIN Clients
ON DoctorsListing.Doctor_ID = Clients.Doctor_ID WHERE Clients.Zip = 3000"
Set myRS = Server.CreateObject("ADODB.Recordset")
myRS.Open SQL, conn, adOpenForwardOnly, adLockReadOnly
%>
the last line is the one generating the error any ideas!!
Message #2 by "Ken Schaefer" <ken@a...> on Thu, 24 May 2001 17:16:06 +1000
|
|
www.adOpenStatic.com/faq/800a0bb9.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Omaro" <omaro@o...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, May 24, 2001 5:00 AM
Subject: [asp_databases] Arguments are of the wrong type, are out of
acceptable range, or are in conflict with one another
: I am getting this 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.
:
: here is my code
:
: Dim SQL
: Set conn = Server.CreateObject("ADODB.Connection")
: conn.Open("DSNoplusplus")
:
:
Message #3 by "Charles Feduke" <webmaster@r...> on Thu, 24 May 2001 08:26:33 -0400
|
|
> the last line is the one generating the error any ideas!!
This means that your SQL statement is probably wrong. Examine your Zip
field. It *should* be character/text, not numeric (because some zips can
start with a 0). If that's the case, then it should be surrounded with 's
in your SQL statement: WHERE Clients.Zip = '3000' (30000?).
? Chuck
> -----Original Message-----
> From: Omaro [mailto:omaro@o...]
> Sent: Thursday, May 24, 2001 5:01 AM
> To: ASP Databases
> Subject: [asp_databases] Arguments are of the wrong type, are out of
> acceptable range, or are in conflict with one another
>
>
> I am getting this 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.
>
> here is my code
>
> Dim SQL
> Set conn = Server.CreateObject("ADODB.Connection")
> conn.Open("DSNoplusplus")
>
>
>
>
>
> stringSQL = "SELECT Clients.Zip, DoctorsListing.Doctor_First_Name,"&_
>
> "DoctorsListing.Doctor_Last_Name,DoctorsListing.Office_Name
> ,"&_
> "DoctorsListing.Street_Address, DoctorsListing.City,
> DoctorsListing.State,"&_
> " DoctorsListing.Zip FROM DoctorsListing INNER
> JOIN Clients
> ON DoctorsListing.Doctor_ID = Clients.Doctor_ID WHERE Clients.Zip = 3000"
>
>
>
>
>
> Set myRS = Server.CreateObject("ADODB.Recordset")
> myRS.Open SQL, conn, adOpenForwardOnly, adLockReadOnly
> %>
>
> the last line is the one generating the error any ideas!!
>
>
|
View Cart
