Hi there,

Have upgraded to DW8.02 from DW2004 and updated the ASPUpload 2 extension to 2.22 to match.

However, when I go back to any existing page and update the "Insert" behaviour and ASPUpload behaviour, I get the following error once the page/s are uploaded to the server;

ADODB.Command error '800a0d5d'
Application uses a value of the wrong type for the current operation.
/webbook/deal_admin/deal_add.asp, line 90


line 90 is as follows;

MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 135, 1, -1, MM_IIF(UploadFormRequest("date_start", UploadFormRequest("date_start", null)) ' adDBTimeStamp

So it seems to be an issue with the date data from the form going to the dB. The column is set as "smalldatetime", and everything was working before I upgraded...

Anyone able to help with this - would sure appreciate it.

Cheers
Rick.

Has anyone at all, got further information on this cos its still causing me a major problem and I cannot fix it.

Darren

Hey Darren,

I never got any sort of reply to this and couldn't find anything else about it on the net. My only conclusion was that ASPUpload 2 does NOT work properly with DW 8.02.

I haven't looked for a while, so there might be some fix that I am not aware of but I ended up going back to DW2004 as I had too many pages using the ASPUpload script to change.

Let me know if you do find a fix - and I'll do the same here.

Cheers
Rick.

Hi,

I never actually used the ASP upload, but my problem was with the date field using MS access, causing the same problem as you. It just does not work, i have trawled through many sites and no one seems to have found an answer, simply putting it down to the version 8.0.2.

I have contacted Adobe directly, and will see if they respond.

Darren

Edited by - darrenj1 on 02 May 2007 13:00:02

I'm getting the same error. It only seems to happen when I have a large amount of text in the editor... My data tpe in the Database (MS SQL 2005) is set to varchar(MAX). I've also tried the data type Text. I can't seem to get it to work. Any ideas?