DWMX adding two Recordset.Close()? (ASP, VBScript)

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

  1. #1

    Default DWMX adding two Recordset.Close()? (ASP, VBScript)

    Hi,

    In connection with my other post about a strange Dim line being added to my
    Connections.asp file...I've also noticed that, sometimes, when I add a new
    recordset DW is doubling up the close statement at the foot of my page:

    <%
    rsProdCats.Close()
    Set rsProdCats = Nothing
    %>
    <%
    rsProdCats.Close()
    Set rsProdCats = Nothing
    %>

    Why would it do that? Is this a DW bug? If so, is there a fix?

    Thanks
    nath.


    Nathon Jones Guest

  2. Similar Questions and Discussions

    1. Name Redefined? What is this Dim? (DWMX/ASP/VBscript/Access)
      Hi, I've been having this problem with a few sites now. It appears that in some cases, and I can't spot a trend, but when I add a recordset to a...
    2. adding columns to an existing recordset
      Say I've retrieved a recordset from a database using the cfquery tag. <cfquery name="qryGetTeams" datasource="#Application.DS#" dbtype="ODBC">...
    3. DWMX V6.0 and DWMX V7.0 Lost Feature - TIMELINE
      DWMX V6.0 and DWMX V7.0 Lost Feature - TIMELINE Has anyone noticed the "MODIFY timeline" feature in DWMX Version 6.0 is gone in DWMX V7.0. The...
    4. RecordSet.Move or RecordSet.AbsolutePosition??
      Hi, I'm trying to use either one of these methods to position the cursor in a specific position inside a recordset, but neither one seems to...
    5. recordset ActiveConnection Close
      Does anybody know why Dreamweaver does not automatically close the ActiveConnection for recordsets in they way that it closes recordsets...
  3. #2

    Default Re: DWMX adding two Recordset.Close()? (ASP, VBScript)

    I also see that sometimes, I just delete all the close statements and then
    open each recordest and close them one at a time and it seems to fix
    everything by adding the close statements back like it should.

    Mitch


    "Nathon Jones" <nathon@SHPAMkirkmoor.com> wrote in message
    news:d4al02$kvu$1@forums.macromedia.com...
    > Hi,
    >
    > In connection with my other post about a strange Dim line being added to
    my
    > Connections.asp file...I've also noticed that, sometimes, when I add a new
    > recordset DW is doubling up the close statement at the foot of my page:
    >
    > <%
    > rsProdCats.Close()
    > Set rsProdCats = Nothing
    > %>
    > <%
    > rsProdCats.Close()
    > Set rsProdCats = Nothing
    > %>
    >
    > Why would it do that? Is this a DW bug? If so, is there a fix?
    >
    > Thanks
    > nath.
    >
    >

    mitchel 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