FreeTDS Development Group

["Peppi Vecchio" <PVecchio AT orangelake.com>]

I'm running Apache/Linux and Perl with DBD::Sybase and FreeTDS on our
server.  I'm talking to a W2K box with SQL Server 7.0 on it.  FreeTDS
connected easily and works great. My only problem is I'm having difficulty
querying the box.  I'm used to using DBI and MySQL but the syntax in
DBD::Sybase/SQL Server is different. Am I to use Sybase syntax or SQL
Server 7.0 syntax?  Specifically I have difficulty passing a string into
my SELECT query.  Looks like this:<br><br>
<code>
$ENV{'SYBASE'} = '/usr/local/freetds' unless $ENV{'SYBASE'};

    my $dbh =
DBI->connect('dbi:Sybase:server=myserver.com;database=this_db','usr','pass');

    my $a1 = "This";
    my $a2 = $dbh->quote( "SELECT COUNT(*) FROM this_table WHERE
this_column >= $a1" );
    my $sth = $dbh->prepare( $a2 ); 
     $sth->execute() or die $sth->errstr;
</code><br><br>
Any help would be appreciated.  Supa Thanx
PeppiV