Author Topic: Search problems?  (Read 1812 times)

0 Members and 1 Guest are viewing this topic.

Offline Antigen

  • Newbie
  • *
  • Posts: 12992
  • Karma: +3/-0
    • View Profile
    • http://wwf.Fornits.com/
Search problems?
« on: February 12, 2005, 12:56:00 PM »
Anybody having problems w/ the forum search gizmo? Aside from that it's limited to 200 results, I mean.

Has anybody gotten a DB error instead of a page full of search results?

When elephants ? ght, it is the grass that suffers.

http://jonathangullible.com/translations/UK_Comnt040222.pdf' target='_new'>Kikuyu proverb

« Last Edit: December 31, 1969, 07:00:00 PM by Guest »
"Don\'t let the past remind us of what we are not now."
~ Crosby Stills Nash & Young, Sweet Judy Blue Eyes

Offline Helena Handbasket

  • Posts: 1102
  • Karma: +0/-0
    • View Profile
Search problems?
« Reply #1 on: February 12, 2005, 11:37:00 PM »
Quote
On 2005-02-12 09:56:00, Antigen wrote:

"Anybody having problems w/ the forum search gizmo? Aside from that it's limited to 200 results, I mean.



Has anybody gotten a DB error instead of a page full of search results?

When elephants ? ght, it is the grass that suffers.

http://jonathangullible.com/translations/UK_Comnt040222.pdf' target='_new'>Kikuyu proverb


"


All seems to be working just fine - I didn't try the author search though.
« Last Edit: December 31, 1969, 07:00:00 PM by Guest »
uly 21, 2003 - September 17, 2006

Offline Antigen

  • Newbie
  • *
  • Posts: 12992
  • Karma: +3/-0
    • View Profile
    • http://wwf.Fornits.com/
Search problems?
« Reply #2 on: February 13, 2005, 01:03:00 AM »
Bill (SysAdmin) figured out that it'll choke on ticks (') or (`). I'm guessing it'll also choke on quotes (") or and per se & (&) or maybe even dashes (-) or less than (<) or greater than (>) and some others. That's predictable as those marks are DB commands.

The solution might be to just add a little explanation about how the search string is packaged for submission to the db search engine (which is MySQL via php, btw)

To escape ticks or other MySQL commands just use a backslash () before the questionable character. If it's not a command character, it'll only interpret the backslash to mean "take this literally, not as a command". So when in doubt, just backslash it.

There is so much in the bible against which every insinct of my being rebels, so much so that I regret the necessity which has compelled me to read it through from beginning to end. I do not think that the knowledge I have gained of its history and sources compensates me for the unpleasant details it has forced upon my attention.
--Helen Keller, American lecturer



_________________
Ginger Warbis ~ Antigen
Seed sibling `71 - `80
Straight South (Sarasota, FL)
   10/80 - 10/82
Anonymity Anonymous
Some days, it's just not worth chewing through the leather straps.
« Last Edit: December 31, 1969, 07:00:00 PM by Guest »
"Don\'t let the past remind us of what we are not now."
~ Crosby Stills Nash & Young, Sweet Judy Blue Eyes