ASP DW8 - code changed?

Report · Jan 25, 2007

hello, i used Dreamweaver (windows xp) to write asp pages with the previous version of dreamweaver. now i installed DW8 and upload the pages and the server cannot display them. i note that some code is different. i.e. rsTest07b_cmd.ActiveConnection

used to be rsTest07b.ActiveConnection what is this new _cmd

and what can i do to make my files work?

is there a new tutorial or something? and the support pages aren't viewable for the last 2 days

thanks, scarlette shobbs@vcu.edu

Report · Jan 25, 2007

I ran into this myself about 2 months before. I unsuspectingly upgraded.
What I ended up having to do is go into each page and recreate all the
recordsets so that they use the "Command" rather than the plain old
recordset.

When You figure out the new way it does things, you will discover a
whole new can of worms...Suddenly, knowing how to make basic dynamic
content isn't good enough any more. Now, as has been true for some time,
injection attacks threaten those that don't change it all over. You then
discover the importance and urgency of knowing Stored Procedures and all
the rest that is associated with it.

However, once you figure out what the stuff in the new "recordsets" are,
you will like it.

When you say "broken" what do you mean?

Report · Jan 28, 2007

thank you,

my pages just did not display, i was only trying a test since i had tried it before with current pages and when i worked on them in upgraded DW8 the no longer displayed. i don't remember if there was an error message or not.

someone came to my office on friday and just created a new connection string for me that will allow me to work on my new project. then i guess i'll discover what you mean about the new recordset stuff and Stored Procedures. Thanks for the tip and i'll start looking up Stored Procedures now. We did do a test page and i did not see anything new in the recordsets but i did not look too hard, was just concerned about the simple page displaying text at the time.

We tried the new connection string on the old pages and nope, did not work at all - i cannot imagine going in and changing all those old pages -

if you have any reference to send me where i can learn "beyond the basics" - new recordset info and Stored Procedures i would appreciate it. let's stored procedures is in the database, correct?

thanks again

s

Report · Jan 29, 2007

http://www.adobe.com/cfusion/knowledgebase/

Just go to the above link and search "8.0.2" & Dreamweaver or command or
SQL injection... This should bring up a number of references.

Original Recordset

Set Recordset1 = Server.CreateObject("ADODB.Recordset")

New Recordset

Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")

Notice one is recordset and the other is command