Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    May 2005
    Posts
    215
    Thanks
    14
    Thanked 0 Times in 0 Posts

    Can someone verify this line of code?

    Hello all. I have a line of code that is giving me an error, although the results are still working fine.

    Here is the error:

    Code:
    ADODB.Command error '800a0bb9' 
    
    Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. 
    
    /rpts/pm/pm_bl_gen.asp, line 28


    Code:
    "SELECT Count (*) AS Total_Gen FROM tbl_wo WHERE (tbl_wo.RequestDate Between #10/1/" & cFY3 & "# And #10/31/" & cFY3 & "#) AND (tbl_wo.WoType = 'PMBC')"
    I know is has something to do with the concantenation of the MM/DD/ with the variable of the year, but I am confused on the correction.

    BTW, this is an Access DB.

    Thanks in advance,

    Parallon

  • #2
    Regular Coder
    Join Date
    Nov 2002
    Posts
    122
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I have to say, everytime i've come across that error, it's becuase I've forgotten to include my adovbs.inc file or my conn.open was pointing to the wrong strSQL, etc...

    Otherwise, break up your query, search for 1 thing, then 2 and keep going until you find the error.

    Good luck

  • #3
    Regular Coder
    Join Date
    May 2005
    Posts
    215
    Thanks
    14
    Thanked 0 Times in 0 Posts
    You know, you were right. See, this file was an <!--Include--> file, and the parent document is the one that had the connection string. So, I was testing just by going directly to this page. Although, it now let me know that I do have a syntax issue with my dates. ;o)

    Thank you so much for your insight.

    Parallon

  • #4
    Regular Coder
    Join Date
    Nov 2002
    Posts
    122
    Thanks
    1
    Thanked 0 Times in 0 Posts
    No problem, done it many times myself.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •