Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP.VBs Trouble Shoot Recordsets.

Dreamweaver Management

ASP.VBs Trouble Shoot Recordsets.

by  Cheech  Posted    (Edited  )
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_Vbsand edit the section below
Code: 
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
Code: 
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
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top