New topic: sqlite LIKE statement with . in it bug?
<http://forums.realsoftware.com/viewtopic.php?t=38204> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message jasmatuphcreations Post subject: sqlite LIKE statement with . in it bug?Posted: Sat Mar 19, 2011 6:07 am Joined: Fri May 07, 2010 9:40 pm Posts: 30 I have a very nice app close to completion and have done 100 of hours of testing, and I just found a small bug which has me baffled. I have a string matching process, using a LIKE statement in my sql statement. This will return the data Code:SELECT * FROM tbl_A WHERE [ArtistName] LIKE '%Muph & Plutonic%' AND [Title] LIKE '%And Then Tomorrow Came%'; ..AND THEN TOMORROW CAME however this statement will not return the data Code:SELECT * FROM tbl_A WHERE [ArtistName] LIKE '%Muph & Plutonic%' AND [Title] LIKE '%...And Then Tomorrow Came%'; It seems there is an issue with the ".", this issue is consistand I've even tried an Exact match Code:SELECT * FROM tbl_A WHERE [ArtistName] = 'Muph & Plutonic' AND [Title] = '...And Then Tomorrow Came'; whilst this works Code:SELECT * FROM tbl_A WHERE [ArtistName] = 'Muph & Plutonic' AND [Title] LIKE '%And Then Tomorrow Came%'; I'm confused, any special hints? Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
