Tagged: database connection action
This topic contains 10 replies, has 0 voices, and was last updated by 
pmeidinger 9 years, 5 months ago.
- AuthorPosts
- August 31, 2011 at 7:37 pm #818
I created a Database Connection Action that passes an integer and a char(5) value to a stored procedure. I noticed that when I pass a value that contains the plus sing (+) to the char(5) parameter, the plus sign gets dropped. This is happening even when I test the action in the PerfectForms admin screen. I’m not doing any processing of the parameter in the stored procedure, just sending it back as a return parameter. Is there a workaround for this?
August 31, 2011 at 10:15 pm #5835I assume you are getting the value from a text input field. A behavior build in to the application forces text input fields to ignore characters like “+”. You can work around this by changing the format of the text input field to “text”.
August 31, 2011 at 11:38 pm #5836It’s not the text input that’s the problem because, like I said, this happens even when you try to test the Database Connection Action in the PerfectForms admin screen.
September 1, 2011 at 12:12 am #5837Also, the value that I will eventually be sending as a paramenter will be from a drop-down input, not a text field.
September 1, 2011 at 8:55 pm #5842Can you give me an example of the value that you are passing with the “+” sign?
September 7, 2011 at 5:03 pm #5847It’s for a student grade, so any of the following:
A+
B+
C+
D+
September 8, 2011 at 5:18 pm #5849Special characters cannot be passed to a stored procedure. You could convert the “+” character to “plus” before it is passed to the stored procedure.
September 8, 2011 at 8:59 pm #5852Bummer. What’s the reason for that, if you can share? Are there any other characters that can’t be passed to a procedure?
September 9, 2011 at 6:53 pm #5853Special characters (non-alpha characters) cannot be passed to a stored procedure.
September 14, 2011 at 3:57 pm #5858Not being able to send non-alpha characters to a stored procedure is a huge concern for me, so I went through our other forms to see which ones send data to the database via a stored proc. I tested one and was able to send this string
+_)(*&^%$#@!~`|]}[{‘”;?.>,<
to the database successfully. So it seems you *can* send special characters. However, this data came from a Text Input in the form, and my initial problem was that the plus sign wasn’t being sent from a Drop-Down. Is it just the Drop-Down that can’t send the plus sign? I know it can send the minus sign to a stored proc. It would be helpful to get a definitive answer on this issue.
September 16, 2011 at 3:14 pm #5859The newest version (V.2.0) of the Connection Agent will handle the special characters. I will send you the link and password.
- AuthorPosts
You must be logged in to reply to this topic.