DW8 Bindings Panel not showing recordsets

[Guest]

G'day,
I have a number of sites configured, with many pages using recordsets. For some reason DW8 is no longer showing the recordsets in the bindings panel. This is true for pages that were created in DW8 and still in their original code state and for pages that I have modified to send e-mail when a record is added, so it is not due to me modifying code.

Any tips on how to refresh or re-populate the bindings panel would be gratefully appreciated.

DW8 | ASP | VBScript

[Newsgroup_User]

Do the recordsets show up in Code view?



--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner''s
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"emjemnsw" <webforumsuser@macromedia.com> wrote in message
news:epe8oh$t7n$1@forums.macromedia.com...
> G'day,
> I have a number of sites configured, with many pages using recordsets. For
> some reason DW8 is no longer showing the recordsets in the bindings panel.
> This
> is true for pages that were created in DW8 and still in their original
> code
> state and for pages that I have modified to send e-mail when a record is
> added,
> so it is not due to me modifying code.
>
> Any tips on how to refresh or re-populate the bindings panel would be
> gratefully appreciated.
>
> DW8 | ASP | VBScript
>

[Guest]

yes they do.
I've attached a code sample of one recordset that I haven't "messed" with but doesn't show in the bindings panel.
I have created some other recordsets today and they are showing OK in the panel.

Thanks,
Mark

[Newsgroup_User]

It looks like you are creating a query from a query rather than from a data
table. Is that right?


--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner''s
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"emjemnsw" <webforumsuser@macromedia.com> wrote in message
news:epf5vs$187$1@forums.macromedia.com...
> yes they do.
> I've attached a code sample of one recordset that I haven't "messed" with
> but
> doesn't show in the bindings panel.
> I have created some other recordsets today and they are showing OK in the
> panel.
>
> Thanks,
> Mark
>
> <%
> Dim rsOpenPlans
> Dim rsOpenPlans_cmd
> Dim rsOpenPlans_numRows
>
> Set rsOpenPlans_cmd = Server.CreateObject ("ADODB.Command")
> rsOpenPlans_cmd.ActiveConnection = MM_NewsDB_STRING
> rsOpenPlans_cmd.CommandText = "SELECT ID FROM
> qryMigration_Open_Migrations"
> rsOpenPlans_cmd.Prepared = true
>
> Set rsOpenPlans = rsOpenPlans_cmd.Execute
> rsOpenPlans_numRows = 0
> %>
> <%
> ' *** Recordset Stats, Move To Record, and Go To Record: declare stats
> variables
>
> Dim rsOpenPlans_total
> Dim rsOpenPlans_first
> Dim rsOpenPlans_last
>
> ' set the record count
> rsOpenPlans_total = rsOpenPlans.RecordCount
>
> ' set the number of rows displayed on this page
> If (rsOpenPlans_numRows < 0) Then
> rsOpenPlans_numRows = rsOpenPlans_total
> Elseif (rsOpenPlans_numRows = 0) Then
> rsOpenPlans_numRows = 1
> End If
>
> ' set the first and last displayed record
> rsOpenPlans_first = 1
> rsOpenPlans_last = rsOpenPlans_first + rsOpenPlans_numRows - 1
>
> ' if we have the correct record count, check the other stats
> If (rsOpenPlans_total <> -1) Then
> If (rsOpenPlans_first > rsOpenPlans_total) Then
> rsOpenPlans_first = rsOpenPlans_total
> End If
> If (rsOpenPlans_last > rsOpenPlans_total) Then
> rsOpenPlans_last = rsOpenPlans_total
> End If
> If (rsOpenPlans_numRows > rsOpenPlans_total) Then
> rsOpenPlans_numRows = rsOpenPlans_total
> End If
> End If
> %>
>
> <%
> ' *** Recordset Stats: if we don't know the record count, manually count
> them
>
> If (rsOpenPlans_total = -1) Then
>
> ' count the total records by iterating through the recordset
> rsOpenPlans_total=0
> While (Not rsOpenPlans.EOF)
> rsOpenPlans_total = rsOpenPlans_total + 1
> rsOpenPlans.MoveNext
> Wend
>
> ' reset the cursor to the beginning
> If (rsOpenPlans.CursorType > 0) Then
> rsOpenPlans.MoveFirst
> Else
> rsOpenPlans.Requery
> End If
>
> ' set the number of rows displayed on this page
> If (rsOpenPlans_numRows < 0 Or rsOpenPlans_numRows > rsOpenPlans_total)
> Then
> rsOpenPlans_numRows = rsOpenPlans_total
> End If
>
> ' set the first and last displayed record
> rsOpenPlans_first = 1
> rsOpenPlans_last = rsOpenPlans_first + rsOpenPlans_numRows - 1
>
> If (rsOpenPlans_first > rsOpenPlans_total) Then
> rsOpenPlans_first = rsOpenPlans_total
> End If
> If (rsOpenPlans_last > rsOpenPlans_total) Then
> rsOpenPlans_last = rsOpenPlans_total
> End If
>
> End If
> %>
>

[Guest · Accepted solution]

Hi Nancy,
in this case yes - but I have many other recordsets based on both queries and tables (all in Access) and have not had this problem in either type or recordset before.

I have just re-installed DW802 and they are all showing in the bindings panel again. I say re-installed because I did have 802 running at one stage but for some reason after a while it started playing up (would not load - began initializing and hung). So I removed DW and re-installed from original disc. I'm pretty sure the recordsets were OK after that for a while, but I won't swear to it.

Anyway, out of frustration I have updated the installation to 8.0.2 and it seems to be OK, recordsets showing etc.

Thanks for your intent to help, but hopefully things will be OK now.....I'll see how it goes when I start enabling my extensions.

cheers,
Mark

[Newsgroup_User]

So I removed DW and re-installed from original disc.
> I'm pretty sure the recordsets were OK after that for a while, but I won't
> swear to it.
>
> Anyway, out of frustration I have updated the installation to 8.0.2 and it
> seems to be OK, recordsets showing etc.

You should have said the above in the first place. If you went back to 8.0
and original recordsets were created in 8.02, then they wouldn't show up
because 8.02 completely changed the code on recordsets to prevent SQL
Injection attack. That's why your reupdating to 8.02 made them show up
again.


--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner''s
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development