1

Topic: Brackets Causes Error in Text Field

Hi all,

I've created a custom occurrence attribute with datatype as text and validation as Standard Text. This is working nicely unless someone uses certain characters - e.g. brackets. In this case, the form submission fails but without an error message being displayed to the user.

I don't have access to the warehouse error logs, but my site doesn't log any error or display a validation message, the form simply reloads with the entered data intact but not submitted to the warehouse.

I wondered if the irecord module is not escaping SQL reserved characters or something and this could be causing a problem at the warehouse end?

2

Re: Brackets Causes Error in Text Field

Hi
I've just tested this on my local development instance. I submitted a value of "this (that)" in a custom occurrence attribute with standard text validation applied on the warehouse definition of the attribute. The form reloaded with the invalid value having an error message underneath it "The value contains characters that are not allowed.". So, for some reason things are working at my end but not yours.
Which warehouse are you submitting to?
Best wishes
John

John van Breda
Biodiverse IT

3

Re: Brackets Causes Error in Text Field

Hi John, It's warehouse1 - the default live server.

All the best,

Steve