Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: ENUM field with apostrophe does not work

ENUM field with apostrophe does not work 3 years 9 months ago #4387

  • linsoussi
  • linsoussi's Avatar Topic Author
  • Offline
  • Posts: 1
  • Thank you received: 0
Hello,
When an apostrophe appear in a ENUM field, joodb can not create the corresponding value in the data. For instance ENUM('Ecole d\'Aménagement et de Gestion de l\'Environnement','Ecole d\'Economie de Socio Anthropologie et de Communication pour le Développement Rural','Ecole de Nutrition et des Sciences et Technologies Alimentaires','Ecole des Sciences et Techniques de Production Animale','Ecole des Sciences et Techniques de Production Végétale') won't work witn joodb.

In other words when a field of a record should have a value from an ENUM, if this value contains an apostrophe, then the field is merely set to null.

Please, how to escape to get the data updated?

Thanks

Please Log in or Create an account to join the conversation.

ENUM field with apostrophe does not work 3 years 9 months ago #4388

  • Dirk
  • Dirk's Avatar
  • Offline
  • Posts: 1140
  • Karma: 21
  • Thank you received: 212
It's a bug

Please extract and replace the file form.php in /administrator/components/com_joodb/helpers
with the new one.




Alernatively you can use a single Quotation mark like this instead ’

This message has an attachment file.
Please log in or register to see it.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Moderators: Dirkjoest