Dreamweaver 8.0.2 and Recordsets

[netboy]

When I create a recordset with the 8.0.2 dreamweaver update it is not updateable. I can no longer just set some values and call recordset.update....

I use to be able to set the locktype. How do I do that now?

[Newsgroup_User]

You can't. It's no longer supported. You'll have to hand-code it.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[netboy]

Yuck! This will break 1000's if not 1,000,000's of web pages. Nice.

[Newsgroup_User]

It is a bizarre change. But, there we go.

The specific reason is down to SQL Injection. Say one had a recordset
connected to SQL Server with SQL of

select * from MyTable where ID=MM_Param

and then a runtime parameter value of Request.Querystring("ID"). In theory,
the database could then be compromised. The simple solution is to use
Cint(Request.Querystring("ID")), but the powers to be decided to change the
recordset code instead.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[netboy]

You also can no longer pass a field and direction for sorting through the querystring. Any work arounds?

[Newsgroup_User]

Hogwash... of course you can still... you just have to customize the code. I
did the same thing before 8.0.2 and it still works now after.

You should brush up on your coding and you too could do that.

"netboy" <webforumsuser@macromedia.com> wrote in message
news:e4l6t9$1d1$1@forums.macromedia.com...
> You also can no longer pass a field and direction for sorting through the
> querystring. Any work arounds?

[Newsgroup_User]

And you can still do it in the new dialog for setting up a Recordset in
8.0.2.

No need of workarounds or special programming. I usually role my own code so
I'm so used to do that. But it's good to see the DW does support it.

"DownWithBugs" <Bugs@TMM.com> wrote in message
news:e4l78s$1sk$1@forums.macromedia.com...
> Hogwash... of course you can still... you just have to customize the code.
> I did the same thing before 8.0.2 and it still works now after.
>
> You should brush up on your coding and you too could do that.
>
> "netboy" <webforumsuser@macromedia.com> wrote in message
> news:e4l6t9$1d1$1@forums.macromedia.com...
>> You also can no longer pass a field and direction for sorting through the
>> querystring. Any work arounds?
>
>