×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Dreamweaver Management

ASP.VBs Trouble Shoot Recordsets. by Cheech
Posted: 31 Jul 03

I always use a Response.Write statement for my recordset source.

To achieve this automatically edit the file called
recordset_main.edml
usually located in
(Main drive letter):\Program Files\Macromedia\Dreamweaver MX\Configuration\ServerBehaviors\ASP_Vbs\
and edit the section below

Set @@rsName@@ = Server.CreateObject("ADODB.Recordset")
@@rsName@@.ActiveConnection = MM_@@cname@@_STRING
@@rsName@@.Source = "@@encodedSQL@@"
@@rsName@@.CursorType = @@cursorType@@
@@rsName@@.CursorLocation = @@cursorLocation@@
@@rsName@@.LockType = @@lockType@@
@@rsName@@.Open()

This should be altered to read

Set @@rsName@@ = Server.CreateObject("ADODB.Recordset")
@@rsName@@.ActiveConnection = MM_@@cname@@_STRING
@@rsName@@.Source = "@@encodedSQL@@"
'Response.Write(@@rsName@@.Source)
@@rsName@@.CursorType = @@cursorType@@
@@rsName@@.CursorLocation = @@cursorLocation@@
@@rsName@@.LockType = @@lockType@@
@@rsName@@.Open()


Close Dreamweaver, if it is open, from now on every recordset will have a commented out line to output the sql statement to the screen, just remove the " ' " from the response.write whenever you are having problems.

Cheech

Back to Adobe FAQ Index
Back to Adobe Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close