▼  Site Navigation Main Articles Search  ▼  Anime + Manga Anime Reviews Anime Characters Gallery Screenshots Manga Reviews  ▼  Misc News Links to Webcomics Bible Quotes About Older Musings
site version 7.3
older
newer

11/4/09
Wednesday 1:46am


Date Posted:
11/4/09

ok, there is a problem with the search program.  It is now case sensitive for some reason and it has to do with the new database that I am using.  In short some results might not be displayed when doing a search.  I am trying to figure this out.

UPDATE: I just need to convert it from

SELECT ID, summary FROM memoblog WHERE lcase(concat(ID,summary)) LIKE '%terts%'
to
SELECT ID, summary FROM memoblog WHERE lcase(concat(cast(ID as char),summary)) LIKE '%terts%'

archives


TAGS: none

All Memo Tags
anime 1, article 1, commercial 1, computer 5, games 22, hard to remember 1, keyboard shortcuts 1, links 1, memo blog 1, mini-review 5, moving 2, mysql 1, news 11, none 1635, opera 68, private 4, quotes 1, reformat hard drive 19, sgopc 1, site update 11, site version 205, star wars 2, swtor 1, video 1, website 9, wishlist 3

copyright 2005–2020