Hide If Empty question

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Hide If Empty question

    Hi,

    Is it possible to apply a "hide if empty" behaviour to code held above the
    <head> tag?

    My code is:
    <%
    Select Case rsRecordset.Fields.Item("exitcode")
    Case "C"
    ExitCode = "Claimed"
    Case "H"
    ExitCode = "Re-Homed"
    End Select
    %>

    When the Recordset is empty, I am getting an "Exception Occured" error
    message.
    When I try to add a standard Hide If Empty behaviour, DW is asking me to
    select something from the page.

    I basically don't want this code to display if the Recordset is empty.
    Thanks.

    nath.


    Nathon Jones Guest

  2. Similar Questions and Discussions

    1. popup menus won't hide - PVII show/hide layers behaviour
      I've used the 'Auto show/hide by PVII" behaviour to create some popup menus for the navigation which make use of divs which appear and disappear....
    2. #26380 [Opn]: empty($SimpleXMLObject) doesn't return true when empty
      ID: 26380 User updated by: bart at mediawave dot nl -Summary: Find out whether an object is empty Reported By: bart...
    3. #25885 [Opn->Csd]: mail() causes apache2 to crash when message is empty, and headers is non-empty
      ID: 25885 Updated by: sniper@php.net Reported By: ben at krackeler dot com -Status: Open +Status: ...
    4. #25885 [NEW]: mail() causes apache2 to crash when message is empty, and headers is non-empty
      From: ben at krackeler dot com Operating system: WinXP PHP version: 4.3.3 PHP Bug Type: Mail related Bug description: ...
    5. Checking for Empty Dataset -- Simple Question
      Can anyone tell me how to check and see if a dataset is empty? I am writing a search function that returns a dataset and binds it to a datagrid....
  3. #2

    Default Re: Hide If Empty question

    On 26 Apr 2005 in macromedia.dreamweaver.appdev, Nathon Jones wrote:
    > I basically don't want this code to display if the Recordset is empty.
    I'm not positive how to check for an empty record in VBScript, but this
    should do:
    <%
    IF rsRecordset.Fields.Item("exitcode") THEN
    Select Case rsRecordset.Fields.Item("exitcode")
    Case "C"
    ExitCode = "Claimed"
    Case "H"
    ExitCode = "Re-Homed"
    End Select
    END IF
    %>

    You may have to tinker with the condition in the IF statement.

    --
    Joe Makowiec
    [url]http://makowiec.net/[/url]
    Email: [url]http://makowiec.net/email.php[/url]
    Joe Makowiec Guest

  4. #3

    Default Re: Hide If Empty question

    To check for an empty recordset, use this code (ASP VBScript):

    If Not rsRecordset.EOF And Not rsRecordset.EOF Then

    ' Recordset is NOT empty - your code here

    Else
    ' Recordset IS empty

    End If

    HTH
    Rob
    [url]http://robgt.com/[/url]
    Tutorials: [url]http://robgt.com/tutorials/index.asp[/url]
    Extensions: [url]http://robgt.com/products/index.asp[/url]


    RobGT Guest

  5. #4

    Default Re: Hide If Empty question

    Thanks people.

    Sorted it out myself though. I just dropped my code...
    <%
    Select Case rsRecordset.Fields.Item("exitcode")
    Case "C"
    ExitCode = "Claimed"
    Case "H"
    ExitCode = "Re-Homed"
    End Select
    %>

    ....into my page, rather than above the head. I basically just dropped it
    into my Hide If Not Empty section.
    For some reason, I assumed that I wouldn't be able to do this! D'oh!

    Nath.

    "Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
    news:d4l7pv$41d$1@forums.macromedia.com...
    > Hi,
    >
    > Is it possible to apply a "hide if empty" behaviour to code held above the
    > <head> tag?
    >
    > My code is:
    > <%
    > Select Case rsRecordset.Fields.Item("exitcode")
    > Case "C"
    > ExitCode = "Claimed"
    > Case "H"
    > ExitCode = "Re-Homed"
    > End Select
    > %>
    >
    > When the Recordset is empty, I am getting an "Exception Occured" error
    > message.
    > When I try to add a standard Hide If Empty behaviour, DW is asking me to
    > select something from the page.
    >
    > I basically don't want this code to display if the Recordset is empty.
    > Thanks.
    >
    > nath.
    >

    Nathon Jones Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139