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
>>
>
>