DMXzone Database Updater ASP Support Product Page


First trial

Reported 26 Jul 2016 00:02:28
has this problem
26 Jul 2016 00:02:28 User  posted:
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!


Replied 26 Jul 2016 06:21:43
26 Jul 2016 06:21:43 Teodor Kuduschiev replied:
Please provide a link to your page, where we can check what goes wrong and help you fix it.
Replied 26 Jul 2016 06:39:38
26 Jul 2016 06:39:38 User  replied:
Here is the link

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.

Replied 26 Jul 2016 06:42:38
26 Jul 2016 06:42:38 Teodor Kuduschiev replied:
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:
Replied 26 Jul 2016 06:58:50
26 Jul 2016 06:58:50 User  replied:
OK, have enabled debugging
Do you need the Secret Key?
Replied 26 Jul 2016 07:41:50
26 Jul 2016 07:41:50 Teodor Kuduschiev replied:
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?
Replied 26 Jul 2016 07:58:53
26 Jul 2016 07:58:53 User  replied:
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

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

It's 8pm my time
Replied 26 Jul 2016 08:07:02
26 Jul 2016 08:07:02 Teodor Kuduschiev replied:
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.
Replied 26 Jul 2016 08:18:27
26 Jul 2016 08:18:27 User  replied:
OK thanks, will give it a go
Replied 26 Jul 2016 10:42:13
26 Jul 2016 10:42:13 User  replied:
I made those changes but still receive the updateRecords.asp error
Replied 26 Jul 2016 10:59:28
26 Jul 2016 10:59:28 Teodor Kuduschiev replied:
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?
Replied 26 Jul 2016 11:05:33
26 Jul 2016 11:05:33 User  replied:
MSSQL 2015 version I think
I saw that error too. Would that be database level or the definition in the DMX Server Object?
Replied 26 Jul 2016 11:08:56
26 Jul 2016 11:08:56 Teodor Kuduschiev replied:
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:
Replied 26 Jul 2016 11:09:39
26 Jul 2016 11:09:39 User  replied:
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?
Replied 26 Jul 2016 11:13:07
26 Jul 2016 11:13:07 Teodor Kuduschiev replied:
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.
Replied 26 Jul 2016 11:15:26
26 Jul 2016 11:15:26 User  replied:
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
Replied 26 Jul 2016 11:16:42
26 Jul 2016 11:16:42 Teodor Kuduschiev replied:
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.
Replied 26 Jul 2016 11:20:26
26 Jul 2016 11:20:26 Teodor Kuduschiev replied:
Are you sure you included the two upload fields in your server action update step?
Thumbnail and Main Image ?
Replied 26 Jul 2016 11:27:11
26 Jul 2016 11:27:11 User  replied:
I only put in the thumbnail to test it out
I haven't included the main image in the update scripts
Replied 26 Jul 2016 11:28:26
26 Jul 2016 11:28:26 Teodor Kuduschiev replied:
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
Replied 26 Jul 2016 11:34:58
26 Jul 2016 11:34:58 Teodor Kuduschiev replied:
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
Replied 26 Jul 2016 11:38:40
26 Jul 2016 11:38:40 Teodor Kuduschiev replied:
I will now inspect your site and will let you know what is wrong.
Replied 26 Jul 2016 11:51:46
26 Jul 2016 11:51:46 Teodor Kuduschiev replied:
Fixed, there was a small error. In the fIle upload step you were using:
{{$}} 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.

Reply to this topic