0
Update Syntax Error
LEGEND
,
/t5/dreamweaver-discussions/update-syntax-error/td-p/714955
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
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
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Newsgroup_User
AUTHOR
LEGEND
,
/t5/dreamweaver-discussions/update-syntax-error/m-p/714956#M146807
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
>
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
>
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Newsgroup_User
AUTHOR
LEGEND
,
LATEST
/t5/dreamweaver-discussions/update-syntax-error/m-p/714957#M146809
Nov 26, 2006
Nov 26, 2006
Copy link to clipboard
Copied
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
>>
>
>
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
>>
>
>
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

