[boulder.pm] DBI question

Jay Kominek jay.kominek at colorado.edu
Fri Feb 4 17:46:56 CST 2000


Oopsie. I meant to respond to this, I swear. :) I just forgot until Jason
posted again. So I'll just elaborate on two more things he could've done:

He had:

>     10  $sql =  "select cust_abbr, pid, date_time 
>     11          from ra_online
>     12          where cust_abbr = 'PG'" ;

And that worked, but this didn't:

>     10  $sql =  "select cust_abbr, pid, date_time 
>     11          from ra_online
>     12          where cust_abbr = $CA" ;

You could also do:

     10  $sql =  "select cust_abbr, pid, date_time
     11          from ra_online
     12          where cust_abbr = '$CA'" ;

or:

     10  $sql =  "select cust_abbr, pid, date_time
     11          from ra_online
     12          where cust_abbr = ?" ;

     ??  $sth = $dbh->prepare($sql);
     ??  $sth->execute($CA);

- Jay Kominek <jay.kominek at colorado.edu>
  Hi, NSA sniffer guys!



More information about the Boulder-pm mailing list