|
|
You're in the
inetserver asp db
group:Can't Figure Out What is Wrong Here
inetserver asp db:
I am using an ASP page to access information in a SQL 2000 database. When I
run the following query: ======================================================== Select Distinct [Judge Name], Caption, Avg ([Total Score] - ([Gross Score]/5)) As AvgDev, ABS(Avg ([Total Score] - ([Gross Score]/5))) As AbsAvgDev, Max ([Total Score] - ([Gross Score]/5)) As MaxDev, Min ([Total Score] - ([Gross Score]/5)) As MinDev From YTD Group By [Judge Name], Caption Order By [Judge Name] myRS.Open strSQL, myConn, adOpenDynamic, adLockOptimistic, adCmdText ============================================================ I get the following error. If I run the query in QA it runs fine? I've experimented with different lock and open options but nothing seems to work =============================================================== Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. =========================================================
Bob;
Thanks for the quick response. I should have seen that need. I downloaded adovbs.inc and extracted the constants I use and put them in my page Wayne [quoted text, click to view] "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:O$fySROGFHA.548@TK2MSFTNGP14.phx.gbl... > Wayne Wengert wrote: > > I am using an ASP page to access information in a SQL 2000 database. > > When I run the following query: > > > > ======================================================== > > Select Distinct [Judge Name], Caption, Avg ([Total Score] - ([Gross > > Score]/5)) As AvgDev, ABS(Avg ([Total Score] - ([Gross Score]/5))) As > > AbsAvgDev, Max ([Total Score] - ([Gross Score]/5)) As MaxDev, Min > > ([Total Score] - ([Gross Score]/5)) As MinDev From YTD Group By > > [Judge Name], Caption Order By [Judge Name] > > > > myRS.Open strSQL, myConn, adOpenDynamic, adLockOptimistic, adCmdText > > > > ============================================================ > > > > I get the following error. If I run the query in QA it runs fine? I've > > experimented with different lock and open options but nothing seems > > to work > > > > =============================================================== > > > > Arguments are of the wrong type, are out of acceptable range, or are > > in conflict with one another. > > > > ========================================================= > This almost always means that the ADO constants (adOpenDynamic, etc.) are > not defined in your page. You could #include the adovbs.inc file in all your > pages, but see here for a better method: > > http://www.aspfaq.com/show.asp?id=2112 > > HTH, > 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. > >
Actually, I had included:
<!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" --> on every page (MDAC directive) but on just this one page I am getting that error so I don't think it is the ado variables. I even tried using the constants (no ado variables) and I still get the error. Any other ideas as to what might cause this? Wayne [quoted text, click to view] "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:u1JdvlOGFHA.3648@TK2MSFTNGP09.phx.gbl... > OK, just be aware that you will need to remember to do that for every page > in which you wish to use the constants. The alternative method of using META > to reference the type library is superior. > > Bob Barrows > Wayne Wengert wrote: > > Bob; > > > > Thanks for the quick response. I should have seen that need. I > > downloaded adovbs.inc and extracted the constants I use and put them > > in my page > > > > Wayne > > > > "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message > > news:O$fySROGFHA.548@TK2MSFTNGP14.phx.gbl... > >> Wayne Wengert wrote: > >>> I am using an ASP page to access information in a SQL 2000 database. > >>> When I run the following query: > >>> > >>> ======================================================== > >>> Select Distinct [Judge Name], Caption, Avg ([Total Score] - ([Gross > >>> Score]/5)) As AvgDev, ABS(Avg ([Total Score] - ([Gross Score]/5))) > >>> As AbsAvgDev, Max ([Total Score] - ([Gross Score]/5)) As MaxDev, Min > >>> ([Total Score] - ([Gross Score]/5)) As MinDev From YTD Group By > >>> [Judge Name], Caption Order By [Judge Name] > >>> > >>> myRS.Open strSQL, myConn, adOpenDynamic, adLockOptimistic, adCmdText > >>> > >>> ============================================================ > >>> > >>> I get the following error. If I run the query in QA it runs fine? > >>> I've experimented with different lock and open options but nothing > >>> seems to work > >>> > >>> =============================================================== > >>> > >>> Arguments are of the wrong type, are out of acceptable range, or are > >>> in conflict with one another. > >>> > >>> ========================================================= > >> This almost always means that the ADO constants (adOpenDynamic, > >> etc.) are not defined in your page. You could #include the > >> adovbs.inc file in all your pages, but see here for a better method: > >> > >> http://www.aspfaq.com/show.asp?id=2112 > >> > >> HTH, > >> 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. > > -- > 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. > >
Bad connection code. I re-coded the connection process and all is well now!
Wayne [quoted text, click to view] "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:u1JdvlOGFHA.3648@TK2MSFTNGP09.phx.gbl... > OK, just be aware that you will need to remember to do that for every page > in which you wish to use the constants. The alternative method of using META > to reference the type library is superior. > > Bob Barrows > Wayne Wengert wrote: > > Bob; > > > > Thanks for the quick response. I should have seen that need. I > > downloaded adovbs.inc and extracted the constants I use and put them > > in my page > > > > Wayne > > > > "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message > > news:O$fySROGFHA.548@TK2MSFTNGP14.phx.gbl... > >> Wayne Wengert wrote: > >>> I am using an ASP page to access information in a SQL 2000 database. > >>> When I run the following query: > >>> > >>> ======================================================== > >>> Select Distinct [Judge Name], Caption, Avg ([Total Score] - ([Gross > >>> Score]/5)) As AvgDev, ABS(Avg ([Total Score] - ([Gross Score]/5))) > >>> As AbsAvgDev, Max ([Total Score] - ([Gross Score]/5)) As MaxDev, Min > >>> ([Total Score] - ([Gross Score]/5)) As MinDev From YTD Group By > >>> [Judge Name], Caption Order By [Judge Name] > >>> > >>> myRS.Open strSQL, myConn, adOpenDynamic, adLockOptimistic, adCmdText > >>> > >>> ============================================================ > >>> > >>> I get the following error. If I run the query in QA it runs fine? > >>> I've experimented with different lock and open options but nothing > >>> seems to work > >>> > >>> =============================================================== > >>> > >>> Arguments are of the wrong type, are out of acceptable range, or are > >>> in conflict with one another. > >>> > >>> ========================================================= > >> This almost always means that the ADO constants (adOpenDynamic, > >> etc.) are not defined in your page. You could #include the > >> adovbs.inc file in all your pages, but see here for a better method: > >> > >> http://www.aspfaq.com/show.asp?id=2112 > >> > >> HTH, > >> 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. > > -- > 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. > >
[quoted text, click to view]
Wayne Wengert wrote: This almost always means that the ADO constants (adOpenDynamic, etc.) are> I am using an ASP page to access information in a SQL 2000 database. > When I run the following query: > > ======================================================== > Select Distinct [Judge Name], Caption, Avg ([Total Score] - ([Gross > Score]/5)) As AvgDev, ABS(Avg ([Total Score] - ([Gross Score]/5))) As > AbsAvgDev, Max ([Total Score] - ([Gross Score]/5)) As MaxDev, Min > ([Total Score] - ([Gross Score]/5)) As MinDev From YTD Group By > [Judge Name], Caption Order By [Judge Name] > > myRS.Open strSQL, myConn, adOpenDynamic, adLockOptimistic, adCmdText > > ============================================================ > > I get the following error. If I run the query in QA it runs fine? I've > experimented with different lock and open options but nothing seems > to work > > =============================================================== > > Arguments are of the wrong type, are out of acceptable range, or are > in conflict with one another. > > ========================================================= not defined in your page. You could #include the adovbs.inc file in all your pages, but see here for a better method: http://www.aspfaq.com/show.asp?id=2112 HTH, 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.
OK, just be aware that you will need to remember to do that for every page
in which you wish to use the constants. The alternative method of using META to reference the type library is superior. Bob Barrows [quoted text, click to view] Wayne Wengert wrote: > Bob; > > Thanks for the quick response. I should have seen that need. I > downloaded adovbs.inc and extracted the constants I use and put them > in my page > > Wayne > > "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message > news:O$fySROGFHA.548@TK2MSFTNGP14.phx.gbl... >> Wayne Wengert wrote: >>> I am using an ASP page to access information in a SQL 2000 database. >>> When I run the following query: >>> >>> ======================================================== >>> Select Distinct [Judge Name], Caption, Avg ([Total Score] - ([Gross >>> Score]/5)) As AvgDev, ABS(Avg ([Total Score] - ([Gross Score]/5))) >>> As AbsAvgDev, Max ([Total Score] - ([Gross Score]/5)) As MaxDev, Min >>> ([Total Score] - ([Gross Score]/5)) As MinDev From YTD Group By >>> [Judge Name], Caption Order By [Judge Name] >>> >>> myRS.Open strSQL, myConn, adOpenDynamic, adLockOptimistic, adCmdText >>> >>> ============================================================ >>> >>> I get the following error. If I run the query in QA it runs fine? >>> I've experimented with different lock and open options but nothing >>> seems to work >>> >>> =============================================================== >>> >>> Arguments are of the wrong type, are out of acceptable range, or are >>> in conflict with one another. >>> >>> ========================================================= >> This almost always means that the ADO constants (adOpenDynamic, >> etc.) are not defined in your page. You could #include the >> adovbs.inc file in all your pages, but see here for a better method: >> >> http://www.aspfaq.com/show.asp?id=2112 >> >> HTH, >> 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. -- 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.
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |