Hello,

I try to change the search options to make searches like "Love" = "love" = "LOVE' = 'LoVe'

That is: Now when I make a search I obtain different results with word 'Love' than with word 'love' and I couldn´t find the option to change this! :-(

Any help? Thanks!!!!

Hello,

I still have this problem and I need to solve it asap. Any help?

Thank you!

There isn't an option to change this - LSQL will search for whatever is put in the search box (the 'query').

To get the behaviour you want you'd need to hack the search script and modify the 'query' string to change all alphabetical characters to lowercase before it is sent to the search routine.

Someone may correct me here, but I don't think this could be done with a global?

There is a perl function to change alpha characters to upper/lowercase whichever is your preference - you should be able to find it by searching the GT forums.

All the best
Shaun

Hello Shaun,

Thanks for your reply.

I didn´t found any function in this forum to do that. I think its another function that is not included in LSQL distribution for PostgreSQL compatibility. I found a message with similar problem in LSQL running under Oracle, but it didn´t fix anything. :-(

I still have this problem and it´s really important for me to fix.

Any aditional help??

Thanks! :-(

I'm not exactly sure what you are asking, but take a look at the Alpha_Bar plugin.

It's old, and not perfect, but I think it may offer some ideas to what you are trying to do.

I needed a way to search for a phrase within, or at the begining, of another string.

It changes the way the search is passed in, so you get "like %string%" type searches instead of what Links normally does.



I'm digging out of over 2 years of problems on my end, and have not had much time to keep up. I have a stack of things to do and release, and fix up, but no eta's any more.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

Hi,

What search method are you using? Try switching to INTERNAL and then rebuild the index tables and see if that fixes things.

Cheers,

Alex
--
Gossamer Threads Inc.

Hello,

I had using 'NONINDEXED' method. I try to change this to INTERNAL (links and category tables) and when I try to run the rebuild search script:

[9:17am]# ./nph-index.cgi --reindex
Started at Tue Feb 18 09:17:31 2003.

Reindexing Links SQL Database ...

2560 links.

Done!

Reindexing Category Database ... 0 categories.
Content-type: text/html

<p><font face='Tahoma,Arial,Helvetica' size=2>A fatal error has occured:</font></p><blockquote><pre>Can't call method "fetchrow_arrayref" on an undefined value at /webs/cgi-bin/links/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 244.
</pre></blockquote><p><font face='Tahoma,Arial,Helvetica' size=2>Please enable debugging in setup for more details.</font></p>
Can't call method "fetchrow_arrayref" on an undefined value at /webs/cgi-bin/links/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 244.


Please, note the '0 Categories' indexed above. I had more than 300 categories in database.

Then, when I try to make a search:

A fatal error has occured:

Can't call method "prepare" without a package or object reference at /webs/cgi-bin/links/admin/GT/SQL/Driver/PG.pm line 61.

Please enable debugging in setup for more details.

Please, let me know how to fix this.

Thanks!