Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
0

Update Syntax Error

LEGEND ,
Nov 24, 2006 Nov 24, 2006

Copy link to clipboard

Copied

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


TOPICS
Server side applications

Views

281
Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Nov 25, 2006 Nov 25, 2006

Copy link to clipboard

Copied

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
>


Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Nov 26, 2006 Nov 26, 2006

Copy link to clipboard

Copied

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


Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines