 |
Progonoi
Magician
Joined: 28 Jan 2007
Posts: 430
|
 Posted: Thu Feb 14, 2008 10:36 pm
Replacing special characters in Mapquery.
|
inspired by: http://forums.zuggsoft.com/forums/viewtopic.php?p=112300&highlight=#112300
Experiencing the exact same problem only that the solution Arminas' has suggested in the above thread only works for me if I'd use
"Name Like" query.
The problem is that I'd rather use "Name =" query instead (exact match) and in that case the suggested %subchar isn't valid.
I tried to use %subchar("room","'","''") instead but that doesn't seem to work as well.
I'm out of ideas so I hope someone would perhaps be able to help.
Thanks,
Prog |
|
|
|
|
Vijilante
SubAdmin
Joined: 18 Nov 2001
Posts: 5182
|
Posted: Fri Feb 15, 2008 1:21 am
|
The %subchar function is one to one, meaning 1 character in the search portion equates to one character in the substition. You need to use %replace to to change 1 character into many. Also the LIKE query is a case-insensitive exact match when no wildcards are used. As far as I know only % is a wildcard character.
|
|
_________________
The only good questions are the ones we have never answered before.
Search the Forums |
 |
|
|
|
|
|
