- Posts: 20
- Thank you received: 1
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
- Topic Author
- Offline
- Junior Member
Less
More
11 years 5 months ago #87234
by bwoo5
Can't use " ' " in name or email for token based survey was created 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.
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 20
- Thank you received: 1
11 years 3 months ago #90354
by bwoo5
Replied by bwoo5 on topic Can't use " ' " in name or email for token based survey
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.
Thanks for your help.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11758
- Thank you received: 2753
11 years 3 months ago #90365
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Can't use " ' " in name or email for token based survey
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.
- helper
- Offline
- Senior Member
Less
More
- Posts: 46
- Thank you received: 7
11 years 3 months ago #90370
by helper
Replied by helper on topic Can't use " ' " in name or email for token based survey
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.
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.