+ Post New Thread
Results 1 to 7 of 7
Web Development Thread, error '800a005e' Invalid use of Null: in Coding and Web Development; I am having an issue where I am getting a error '800a005e' Invalid use of Null: Here is the error ...
  1. #1

    Join Date
    May 2014
    Posts
    3
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    error '800a005e' Invalid use of Null:

    I am having an issue where I am getting a error '800a005e' Invalid use of Null:

    Here is the error and line:

    Code:
    <p>Microsoft VBScript runtime </font> <font face="Arial" size=2>error '800a005e'</font>
    <p>
    <font face="Arial" size=2>Invalid use of Null: 'CStr'</font>
    <p>
    <font face="Arial" size=2>/acdb2/reportsSettings.asp</font><font face="Arial" size=2>, line 341</font>
    
    _____
    
    Line 341:
    
    <option value="<%=(schedDates.Fields.Item("schedDate").Value)%>" <%If (Not isNull((current.Fields.Item("schedDateCurrent").Value))) Then If (CStr(schedDates.Fields.Item("schedDate").Value) = CStr((current.Fields.Item("schedDateCurrent").Value))) Then Response.Write("selected=""selected""") : Response.Write("")%> ><%=(schedDates.Fields.Item("schedDate").Value)%></option>

    Please let me know if more code is needed.

    I am new to this and urgent that I get it working. Any help is greatly appreciated.

    Thank you.

  2. #2
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    965
    Thank Post
    58
    Thanked 163 Times in 115 Posts
    Rep Power
    67
    This could be that one of your find items it not finding the field.

    If the return of find item is null you can't do .value. It would throw the error your getting

  3. Thanks to penfold_99 from:

    GFoster (27th May 2014)

  4. #3

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    168
    Try isEmpty or isBlank on the date field instead of isNull

  5. Thanks to CESIL from:

    GFoster (27th May 2014)

  6. #4

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    9,769
    Thank Post
    1,813
    Thanked 2,228 Times in 1,645 Posts
    Rep Power
    801
    Mrs Gove, aka Times and Mail columnist Sarah Vine, is clearly feeling the pressure of people's loathing for her husband. (Michael Gove's children are traumatised by 'hate' aimed at their father - Telegraph)

    However, I think she misunderstands. It's not just socialists who dislike Michael Gove. I think he has upset quite a few of his own cabinet members.
    I used to believe that socialists were nice but misguided. Now I know that they are not nice at all.
    Last edited by elsiegee40; 27th May 2014 at 09:16 AM.

  7. #5


    Join Date
    Feb 2007
    Location
    51.403651, -0.515458
    Posts
    9,069
    Thank Post
    232
    Thanked 2,719 Times in 2,007 Posts
    Rep Power
    797
    Quote Originally Posted by elsiegee40 View Post
    It's not just socialists who dislike Michael Gove.
    Wrong thread?

  8. #6

    Join Date
    May 2014
    Posts
    3
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by CESIL View Post
    Try isEmpty or isBlank on the date field instead of isNull
    Thank you, but that did not work.

    The way it is supposed to work, is that every semester a new term date is created and the list of term dates is updated.
    There are 3 drop down menu's that someone can use to change to different dates to do different reports, (transcripts in this case), along with an update button and a back to main button.

    A new date was added for the new term only showing the first drop down and is no longer displaying the other drop downs, update button or back to main button.

    I suspect that when the new date was added, it broke it somehow, as it had worked before.

    Thanks again.

  9. #7

    Join Date
    May 2014
    Posts
    3
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    The issue has been resolved.

    By placing an
    & ""
    before the end of the CStr function



    Code:
    Then If (CStr(schedDates.Fields.Item("schedDate").Value & "") = CStr((current.Fields.Item("schedDateCurrent").Value & "")))
    Thank you all for your replies.
    Last edited by GFoster; 27th May 2014 at 11:38 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 3
    Last Post: 7th May 2013, 08:29 AM
  2. use of pupil images on website
    By adamyoung in forum School ICT Policies
    Replies: 4
    Last Post: 17th October 2005, 11:08 AM
  3. Restricting the use of removeable storage - do you?
    By tarquel in forum School ICT Policies
    Replies: 16
    Last Post: 10th July 2005, 04:13 PM
  4. Use of domain password (& staff AUP, etc.) ;)
    By mark in forum School ICT Policies
    Replies: 22
    Last Post: 29th June 2005, 02:36 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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