barrycarlyon has asked for the wisdom of the Perl Monks concerning the following question:

Fellow Monks,

I want to perform a search of a database using abstarct search as follows, (psuedo ccde)

search_where page != anything with a / in it

Where search_where is the Class::DBI::AbstratSearch method, page is the column, != not equals and anything with a slash I believe is '%/%' but im not sure

So can anyone tell me what the correct 'command line' should be Yours

Barry Carlyon barry@barrycarlyon.co.uk

Replies are listed 'Best First'.
Re: Abstract Search
by davidrw (Prior) on Apr 13, 2006 at 19:01 UTC
    You can just use Class::DBI's retrieve_from_sql method: 
    my @results = Your::Class->retrieve_from_sql(qq{ NOT page like "%/%" }
+);

    [download]
[reply]
[d/l]
[select]
Re: Abstract Search
by Zerhash (Scribe) on Apr 13, 2006 at 18:54 UTC
    its sounds like a simple regex unless the class doesnt allow it.
    foreach (@search_where_page){
print unless (m(/));
}

    [download]
[reply]
[d/l]

Back to Seekers of Perl Wisdom