[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