publius wrote:
I tried to use the phrase "glad you're happy" in a Feedback comment, but got an SQL error.
Fixed! Just made a test with the following feedback and it worked:
Code: Select all
it's a test with "all sorts of things" inside.Julien
| LaserDisc Database https://forum.lddb.com/ |
|
| Apostrophes in Feedbacks https://forum.lddb.com/viewtopic.php?f=9&t=1477 |
Page 1 of 1 |
| Author: | publius [ 31 Jul 2012, 22:55 ] |
| Post subject: | Apostrophes in Feedbacks |
I tried to use the phrase "glad you're happy" in a Feedback comment, but got an SQL error. I found that I could avoid this by typing "glad you\'re happy", & the backslash does not appear in the feedback message as displayed. |
|
| Author: | hippiedalek [ 01 Aug 2012, 09:33 ] |
| Post subject: | Re: Apostrophes in Feedbacks |
I've noticed apostrophes, colons, semi colons etc cause problems with the search too. |
|
| Author: | admin [ 01 Aug 2012, 11:57 ] |
| Post subject: | Re: Apostrophes in Feedbacks |
This is presumably a wrong escape'ing of characters (on feedbacks) for quote/apostrophes. I moved the topic to "bug reports". hippiedalek wrote: I've noticed apostrophes, colons, semi colons etc cause problems with the search too. Do you have an example with semi-colons? Regards, Julien |
|
| Author: | hippiedalek [ 01 Aug 2012, 12:36 ] |
| Post subject: | Re: Apostrophes in Feedbacks |
admin wrote: Do you have an example with semi-colons? Sorry, when I look into it now it seems I was getting confused with another problem I've had when searching with colons; if a title includes a colon and I don't search for it with a colon then it won't return the result. for example searching for "Star Trek The Screen Voyages I to VI" won't return "Star Trek: The Screen Voyages I to VI" Sorry, I should have double checked before adding to this thread, my only defence is that I posted before my morning coffee. |
|
| Author: | rein-o [ 01 Aug 2012, 21:20 ] |
| Post subject: | Re: Apostrophes in Feedbacks |
the only issue that i can think of is: yor: the hunter from the future. if you do a search for YOR you get pages of stuff. if you do a search for YOR: then you get 10 things. i know there were others in the past but i can't remember. |
|
| Author: | admin [ 01 Aug 2012, 22:11 ] |
| Post subject: | Re: Apostrophes in Feedbacks |
publius wrote: I tried to use the phrase "glad you're happy" in a Feedback comment, but got an SQL error. Fixed! Just made a test with the following feedback and it worked: Code: Select all it's a test with "all sorts of things" inside.Julien |
|
| Author: | admin [ 01 Aug 2012, 22:13 ] |
| Post subject: | Re: Apostrophes in Feedbacks |
rein-o wrote: the only issue that i can think of is: yor: the hunter from the future. If you know that the title will begin with Yor then you can use the * wildchar and make a search on Yor*: http://www.lddb.com/search.php?search=yor*&sort=title Julien |
|
| Author: | rein-o [ 01 Aug 2012, 23:15 ] |
| Post subject: | Re: Apostrophes in Feedbacks |
o.k. sounds good. |
|
| Page 1 of 1 | All times are UTC [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|