Frank_Rizzo - 2:57 pm on Feb 21, 2013 (gmt 0)
I have ' in the get string at the moment. This works fine and retrieves the right page from the database:
If that translates to
then surely the database is not going to find that exact match if I extract the name from after the second -
namesearch = "Ed ONeill"
Would it not be wise to include the apostrophe
or at least a token, such as ~ which can be identified and transformed before database search?
Yes there will be some strange names in there with double barrel, multiple initials such as Lord R W Fortescue-Smythe
As in the above example I could use a token, which should be URL friendly?
Then it's a case of transforming _ to - before the database search.