We help IT Professionals succeed at work.

Cursortype management with Dreamweaver CS3

tacobell1234
tacobell1234 asked
on
381 Views
Last Modified: 2009-06-04
Hello,

I recently upgraded to CS3 from Dreamweaver MX and was surprised to discover that the automatic coding for Recordsets had changed quite a lot. The software now generates commands rather than recordsets.  (SEE BELOW)
Problem is, the default cursortype generated by the new code is obviously not the one I need (ie '1'), and some fields in my asp page aren't getting populated.

Would anyone know how to get Dreamweaver CS3 to kindly let me choose my cursortype, and lacking this, how to change it manually ?
Set Recordset7 = Server.CreateObject("ADODB.Recordset")
Recordset7.ActiveConnection = MM_ttt_STRING
Recordset7.Source = "SELECT * FROM fff WHERE fff = " + Replace(Recordset7__MMColParam, "'", "''") + ""
Recordset7.CursorType = 1
Recordset7.CursorLocation = 2
Recordset7.LockType = 1
Recordset7.Open()
 
became this:
 
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_ttt_STRING
Recordset1_cmd.CommandText = "SELECT * FROM tttt WHERE ID_tttt = ?" 
Recordset1_cmd.Prepared = true
Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 5, 1, -1, Recordset1__MMColParam) ' adDouble
Set Recordset1 = Recordset1_cmd.Execute

Open in new window

Comment
Watch Question

Don't talk to me.
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.