Tuesday, June 01, 2004

Dreamweaver MX ASP record update form

If you are using Dreamweaver MX to generate ASP code, it appears updating dates is a problem.

When Dreamweaver builds arrays of form fields and values, it seems to use a single quote ( ' ) SQL delimiter in all circumstances. Updating dates requires a pound ( # ) delimiter.

The following is Dreamweaver sample output:

This won't work if the field is a date format:
MM_fieldsStr = "myDate|value"
MM_columnsStr = "[myDate]|',none,NULL"

This will work:
MM_fieldsStr = "myDate|value"
MM_columnsStr = "[myDate]|#,none,NULL"

Choosing submitting as date during the form building wizard doesn't seem to have any effect.

No comments:

Post a Comment