fetchall_arrayref instead of...

From: Beau Hayes (Beau_at__what_is_this_.oblios-cap.com)
Date: 06/15/04

  • Next message: Alex oboimov: "problem building DBI module" 
    Date: Tue, 15 Jun 2004 12:41:51 GMT

    Greetings. I'm doing some simple dbi stuff, migrating from an
    asp/sqlserver7 environment a couple years ago. I have a spot where I
    intended to take a few characters as input, use a "SELECT * FROM foo
    WHERE stuff LIKE 'abc'". I just realized mysql doesn't do "like".
    Poking through perldoc DBI I see fetchall_arrayref and it's the only
    alternative I can think of so far: suck a table into an array and loop
    a regex through it, but that seems like it can't be nearly as
    efficient. All suggestions/pointers welcome. 

    -- 
beau
http://www.semanticrestructuring.com/prisdem.php
Chose One: ( )Democracy ( )Paperless Voting
http://www.verifiedvoting.com
  • Next message: Alex oboimov: "problem building DBI module"