Update Syntax Error

Oops! Mean't to respond to the group, not your mail box!
Here goes again:

Thanks, I tried this many times. I finally resorted to trashing the server
scripts and notes folder on the server and local folder, loaded up a copy of
the file from MX again and reapplied server behaviours. Now works OK. Thanks
for responding, really appreciated.


"Nancy - Adobe Comm. Expert" <nancy@webwish.com> wrote in message
news:ekagfq$a7i$1@forums.macromedia.com...
> It's different because 8.02 changed the recordset (and insert, update
> code) to prevent SQL Injection attacks. Recreate your recordset and
> update pages in 8.02 (takes just a few minutes) and you should be good to
> go.
>
>
> --
> Nancy Gill
> Adobe Community Expert
> Author: Dreamweaver 8 e-book for the DMX Zone
> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
> Beginner''s
> Guide, Mastering Macromedia Contribute
> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
> Development
>
> "Tade's Studio" <tade@visualedge.co.uk> wrote in message
> news:ek6amp$c5k$1@forums.macromedia.com...
>> Hi All,
>> Does anyone know of a fix for the Update syntax error generated by
>> DW8.02?
>> Reason is I have a page that worked with no problems in DWMX but will
>> always generate an update syntax error on my new computer with 8.02
>> installed.
>> I have looked at the code generated by the update server behaviour using
>> DW8.02 and DWMX (code view) and they look SO different. This is why I
>> think there must be a problem with DW8.02
>> I am using an ASP VBscript model with a DSNless connection on DW8.02.
>> Database is Access.
>> I am truly thankful for any help
>>
>
>

It's different because 8.02 changed the recordset (and insert, update code)
to prevent SQL Injection attacks. Recreate your recordset and update pages
in 8.02 (takes just a few minutes) and you should be good to go.


--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner''s
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"Tade's Studio" <tade@visualedge.co.uk> wrote in message
news:ek6amp$c5k$1@forums.macromedia.com...
> Hi All,
> Does anyone know of a fix for the Update syntax error generated by DW8.02?
> Reason is I have a page that worked with no problems in DWMX but will
> always generate an update syntax error on my new computer with 8.02
> installed.
> I have looked at the code generated by the update server behaviour using
> DW8.02 and DWMX (code view) and they look SO different. This is why I
> think there must be a problem with DW8.02
> I am using an ASP VBscript model with a DSNless connection on DW8.02.
> Database is Access.
> I am truly thankful for any help
>