APM: Perl vs Micorsoft SQL 7 (addendum)

Goldilox Goldilox at teachnet.edb.utexas.edu
Fri Mar 28 12:59:33 CST 2003


Oh yeah - forgot to say (see previous message of same subject):

use CGI;my $cg=new CGI;
use DBI;
use DBD::ODBC;

my $dbh = DBI->connect('dbi:ODBC:HydrometSQL','user','pass') || die "Database
connection not made: $DBI::errstr";

my $sql = qq{select sensordef.sensor_number, site.site_name from (sensordef
INNER JOIN site ON sensordef.site_id = site.site_id) where
sensordef.sensor_number > 99999 and site.in_service <> 0 and
sensordef.in_service <> 0 order by site.site_number};

my $newsth = $dbh->prepare( $sql ) ||die "Couldn't prepare statement:
$DBI::errstr";




More information about the Austin mailing list