Yes there are indeed some publishers which do have single quotes in the name, e. g. the German mag "64'er":
(and in case you didn't know, this is what has been confusing mySQL from its "birth")
- Go to Advanced Search
- Enter "64'er" (without double quotes) into the Publisher field
- Press "Go" button
You'll get over 450 results.
Now go to page 1, 2, 3 >>> boom.
You'll get "search returned no games" and the publisher field will show a whopping sort of "64\\\\\\\'er" text.
Would be nice if this could be fixed. Thanks.
Welcome to the Gamebase 64 forums. An attempt to document ALL Commodore 64 gameware before it's too late!
Advanced search form: single quotes trouble!
Moderator: Jimbo
- andreas2
- Keen Member
- Location: ...ADVENTURE GUY...
- Brataccas
- Keen Member
Post
It looks like the problem is in the routine that accepts input from the web form.. this would be whatever inserts those backslash characters and prints "Alpha-numeric characters only please!"
The SQL query works perfectly fine. For example, here is the link for the fourth page:
http://www.gb64.com/search.php?a=6&adv_ ... 18&h=0&p=3
Chage that last value "p=3" to "p=5" to get to the sixth page, etc.
The SQL query works perfectly fine. For example, here is the link for the fourth page:
http://www.gb64.com/search.php?a=6&adv_ ... 18&h=0&p=3
Chage that last value "p=3" to "p=5" to get to the sixth page, etc.
- andreas2
- Keen Member
- Location: ...ADVENTURE GUY...
Post
thanks, but I know of this ugly workaround already
it is very awkward to advance pages that way, so what is needed is a proper fix!
usually it also happens that the backslashes are added up to the URL, which also explains that there are no results anymore after a couple of sub-pages!
it is very awkward to advance pages that way, so what is needed is a proper fix!
usually it also happens that the backslashes are added up to the URL, which also explains that there are no results anymore after a couple of sub-pages!
Who is online
Users browsing this forum: No registered users and 1 guest