The "What Are You Working On?" Thread - Month Of March 2017

ecchi · 2017-03-29, 12:31 PM

Just done a job I should have done over a year ago. Added the first new submitted gallery to ClitPass (thanks Jeremy).

Only problem is, it broke with my script.

It would appear either DBI or MySQL does not deal with apostrophes in strings the same way Perl does. So when it found the word -men's- in the gallery description, it broke down. Not a big problem because on checking the galleries I can replace the apostrophe with the & # 39 type notation (which is what I did do when I spotted the problem), but that is a pain so I'll have to add a subroutine to the script that searches for apostrophes and replaces them with the code.

2017-03-29, 12:31 PM	#23
ecchi Banned Join Date: Oct 2003 Location: About to be evicted!!!! Posts: 4,082	Just done a job I should have done over a year ago. Added the first new submitted gallery to ClitPass (thanks Jeremy). Only problem is, it broke with my script. It would appear either DBI or MySQL does not deal with apostrophes in strings the same way Perl does. So when it found the word -men's- in the gallery description, it broke down. Not a big problem because on checking the galleries I can replace the apostrophe with the & # 39 type notation (which is what I did do when I spotted the problem), but that is a pain so I'll have to add a subroutine to the script that searches for apostrophes and replaces them with the code.