On Wed, 7 May 2003, William Thompson wrote:
> I've done a bit with SQL since this project I've been working on, but I
> don't know everything about it. I was considering writing a perl lsearch
> that would make data returned from a DB a flat file and search it.
*Surely* you can do all the searching in the DB query? I thought that's
what languages like SQL are for...
> Instead of: ${lookup{key}lsearch{/some/file}{$value}}
> something like:
> ${lookup{key}lsearch-mysql{sql statement}{$value}}
>
> Something like that in which would use the lsearch facility to search the
> rows (like lines of a file) returned by the sql statement.
I cannot believe that you cannot persuade SQL to search the rows itself.
> I don't think this is possible, but I'll ask anyway. Is there anyway in the
> perl facility to allow perl to use currently cached sql connections?
No.
--
Philip Hazel University of Cambridge Computing Service,
ph10@??? Cambridge, England. Phone: +44 1223 334714.
