Solved

Recordsets not recognized

Posted on 2003-12-01
9
383 Views
Last Modified: 2010-04-25
I am constantly having problems with Dreamweaver not recognizing recordsets that I have created.  

I create recordsets using the Bindings tab and they Test fine and show up in the Bindings window. However, when I try to create a Server Behavior (using the Plus sign in the Server Behavior tab), I occasionally get an error stating that I need to create a recordset.  This error happens just about every time I try to do an Update Record (yes, all my text boxes are assigned to fields) and sporatically when I try an Insert Record.

Has anyone else come across this? How can I fix this?

I am using DreamWeaver MX, version 6.1.

Here is a screenshot of an error I get. As you can see, it prompts for me to create a recordset even when one exists.
http://lennon.csufresno.edu/~bcs25/error.gif
and another one:
http://lennon.csufresno.edu/~bcs25/error2.gif
0
Comment
Question by:upplepop
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 

Expert Comment

by:brisctt
ID: 9855378

What are you trying to develop in....ASP/MS Access or PHP/MySQL?

I've been using Dreamweaver MX for quite some time...mostly in PHP/MySQL.....I always create my recordsets in the server behaviors panel.  

0
 
LVL 4

Expert Comment

by:c_swanky
ID: 9857015
Please post your code... cannot see all of it in the screen shot.

0
 

Author Comment

by:upplepop
ID: 9868146
I am developing in ASP.  The recordsets are made in either the Bindings or Server Behaviors panels.

Here is my code from a relatively simple page. In this case, I try to make a dynamic table (using the button in the Application Panel) and get instructed to add a recordset.

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/MISDatabase.asp" -->
<%
Dim ActivityList
Dim ActivityList_numRows

Set ActivityList = Server.CreateObject("ADODB.Recordset")
ActivityList.ActiveConnection = MM_MISDatabase_STRING
ActivityList.Source = "SELECT * FROM Log"
ActivityList.CursorType = 0
ActivityList.CursorLocation = 2
ActivityList.LockType = 1
ActivityList.Open()

ActivityList_numRows = 0
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#C0C0C0">
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" class="border">
  <tr>
    <td bgcolor="#C0C0C0" class="page_head"><font size="2"><strong>Blank</strong></font></td>
  </tr>
  <tr>
    <td bgcolor="#DDDDDD" class="page_minor">&nbsp; </td>
  </tr>
</table>
</body>
</html>
<%
ActivityList.Close()
Set ActivityList = Nothing
%>
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 4

Expert Comment

by:c_swanky
ID: 9872704
What are some of the field names in the LOG table?

You are doing just about everything except displaying the recordset value, maybe that's why you are getting that notice.

See code below:  NOTICE the   <%Response.Write("Log_Id")%>   statement.  You will need to replace "Log_Id" with a valid field name from your database.



<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" class="border">
  <tr>
    <td bgcolor="#C0C0C0" class="page_head"><font size="2"><strong>Blank</strong></font></td>
  </tr>
  <tr>
    <td bgcolor="#DDDDDD" class="page_minor"> <%Response.Write("Log_Id")%> </td>
  </tr>
</table>
0
 

Author Comment

by:upplepop
ID: 10023812
Log_Id is a field name from my database, so that's not the problem.
0
 

Author Comment

by:upplepop
ID: 10112343
Anyone else have any ideas? Otherwise, I'll ask to PAQ this thread.
0
 

Author Comment

by:upplepop
ID: 10160144
For anyone else who has this problem, I'll leave my workaround.

Shut down the program. Open it using the shortcut icon (not by opening a file). Close the blank document it creates and open the document you are working with. This usually resolves the problem.
0
 
LVL 2

Accepted Solution

by:
Lunchy earned 0 total points
ID: 10186093
PAQed, with points refunded (250)

Lunchy
Friendly Neighbourhood Community Support Admin
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question