Thanks Gianluigi,
I don't have the site posted on a public server yet--but may next week.
In the mean time, here's the line from the code that Dreamweaver (CS5) created for the update behavior:
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param34", 201, 1, 500, Request.Form("CustomerGroups")) ' adLongVarChar
I tried changing the ADO data type from adLongVarc_h_a_r(201) to adVarWc_h_a_r(202) but that resulted in the following error:
Microsoft OLE DB Provider for SQL Server error '80040e14' Implicit conversion from data type datetime to float is not allowed. Use the CONVERT function to run this query. If you think it would help to change my DB field to another data type, I'm open to suggestions. Thanks!
Jeff |
|
|