I have been trying to get this working for 2 days. I have a form with a bunch of fields and 2 file upload inputs for images to be uploaded. I have gone through and added Server Connect steps, the Update Executor, etc but the form does nothing. I am now stumped and am thinking or requesting my money back as I have paid for all the required stuff but it's still no go!

Hello,
Please provide a link to your page, where we can check what goes wrong and help you fix it.

Here is the link
www.cruzjimenez.nz/_admin/blog-edit.asp?id=1

It throws up an error with the updateRecord script page that was created but am not sure what the error. I can allow errors to be outputted to the browser if you need?

The page is an ASP page that cals in items from the database using a Recordset.

I've been using DMXZone for over a decade now and love the products so hopefully we can get it going.

Thanks

I see an internal server error on your page, after submiting. Please enable the detailed error reporting as well as enable the debug mode in the server connect:

OK, have enabled debugging
Do you need the Secret Key?

No, the secret key is not needed.
Can you send me a screenshot of your update action step setup - where you define your file fields values?

I have been kicked out of my remote connection so will have to send those screen shots tomorrow if that's OK?
I have set them according to the tutorial video www.dmxzone.com/go/23317/use-html5-file-upload-with-update-record-server-action

I will have another go tomorrow as the page needs to update 2 images

It's 8pm my time

Here are 2 screenshots
www.dropbox.com/s/f23uily9na8e12s/Screen%20Shot%202016-07-26%20at%208.01.34%20PM.png?dl=0

www.dropbox.com/s/pe8g1me7sto9l1i/Screen%20Shot%202016-07-26%20at%207.48.36%20PM.png?dl=0

I am afraid this video is outdated, sorry about that, we forgot to archive it ... There is a simple way of doing this now, without the conditions step etc.
Just setup the file update exactly as your other fields and put the same value (name returned by the upload step) in the Condition field - then it will update file only if a file is uploaded, otherwise it won't update this field, just like:


So your action file steps should be:
- DB connection
- File Upload
- Update Record


Also i notice you are using '-' in the field names ... which cause issues. Please use "fieldName" instead of "fiel-name" in order to avoid future troubles.

OK thanks, will give it a go

I made those changes but still receive the updateRecords.asp error

Now, there is another error message, related to the type of data which you insert in some of your database table columns: "Value has wrong type". Can you tell me what database are you using?

MSSQL 2015 version I think
I saw that error too. Would that be database level or the definition in the DMX Server Object?

I think this is more database table fields types related. It seems that some of the form fields values, which you are submitting, is not the type, that its database table field requires.
Something like trying to insert text into a date column (that is just an example).

Can you send me a screenshot of your database table setup, where i can see the fields types? Please use my email for this:

I have made a change to an input on the page (the recordid) so hopefully that will work now. Just need to set it to go to a list.asp page after completion?

Please remove this from the onsuccess event ....
"onSuccess": "dmxServerActionControl('run','blogUpdate',{},this);"

This is causing an infinite loop! There is no logic to run the blogUpdate executor, when it successfully completes?!
Just set a go to url behavior that redirects to list.asp on success please.

OK, will do. Again it was taken form the video tutorial.
It seems to be working now as the database is being updated but the image upload part isn't working and no errors seems to be showing

The video tutorial shows how to run another executor, which just lists the database records. It does not run the update executor infinitely.
I will check your page now.

Are you sure you included the two upload fields in your server action update step?
Thumbnail and Main Image ?

I only put in the thumbnail to test it out
I haven't included the main image in the update scripts

Something is not really right, but i will need to access your site. Is it possible to provide the ftp details, so i can connect to your site and check what is wrong.
My email is:

This reply was removed on 7/26/2016 7:42:22 PM.
See the changelog

Please do not post such sensitive data in our public forums! That's why i provided my email, in my last post so you can send it there.

This reply was removed on 7/26/2016 7:42:04 PM.
See the changelog

I will now inspect your site and will let you know what is wrong.

Fixed, there was a small error. In the fIle upload step you were using:
{{$_POST.thumbImg.name}} instead of just {{$_POST.thumbImg}}
I fixed this in your action file - all is working fine now. Please download the dmxConnect folder from your ftp. Everything else is fine already.