Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Can't use " ' " in name or email for token based survey

  • bwoo5
  • bwoo5's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
11 years 4 months ago #87234 by bwoo5
In my token table I have a participant with the name O'ryan and his email is O'ryan@xxx.com

When I put this into limesurvey it changes his name to oryan and the email to oryan@xx.com.

his actually email needs to have the ' in there. Is there a work around to this?

Thanks.
The topic has been locked.
  • bwoo5
  • bwoo5's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
11 years 2 months ago #90354 by bwoo5
Is there a workaround for this issue? Just did another survey with a someone that has a name of Mike O'Bryan and his email is mike.o'bryan@xyz.com. Limesurvey imports this and shows it correctly in the token table but when it sends the email, the email address it used was bryan@xyz.com, it is chopping off the mike.o'

Thanks for your help.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
11 years 2 months ago #90365 by holch
I have no solution but an opinion: the person that invented email addresses with special characters should be spanked. ;-)

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
More
11 years 2 months ago #90370 by helper
And spanked very hard!

In defense of LimeSurvey - this is a very "typical" method for SQL injection to put an apostrophe in a text field. LimeSurvey just takes that risk out by not processing the character.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose