DMXzone Server Connect Support Product Page

Not a problem

Won't read from form fields on insert record

Reported 03 May 2017 14:55:34
1
has this problem
03 May 2017 14:55:34 Ken Pollard posted:
I haver a simple form with 2 fields. My insert record won't read the form fields. If I hard code them in the insert it works, but if I use the "Post" data it does not see it. I have gone over all setting twice! Imported for, selected Post data to populate, added server executor, bound form... Here is the error.

{type: "Error", fileName: "modules/dbupdater.asp", lineNumber: 15,…}
fileName
:
"modules/dbupdater.asp"
lineNumber
:
15
message
:
"Cannot insert the value NULL into column 'first_name', table 'scvwd_development.dbo.user_account'; column does not allow nulls. INSERT fails."
stack
:
[{fileName: "lib/core/response.asp", lineNumber: 180, method: "error",…},…]
type
:
"Error"

Replies

Replied 03 May 2017 18:17:52
03 May 2017 18:17:52 Ken Pollard replied:
Issue resolved. As an FYI for someone else. I am using IIS Rewrite and I had a rule to enforce lower case URL, that was causing the issue.

Reply to this topic