FreeTDS Development Group

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

> On Mon, 22 Jul 2002, Peppi Vecchio wrote:

Ah, Yes!  Thanks for the help.  I finally got it.  You were right, I
wasn't single quoting inside the double quoted prepare statement.  It
works like this:

    my $a2 = "Nov 11 2001";
    my $a1 = "SELECT COUNT(*) FROM guest WHERE survey_date >= '$a2'"; 
    my $sth = $dbh->prepare( "$a1" );

Thank you very much!

> 
> > Bob,
> >
> > Thanks for the reply and the help.  Unfortunately, I've tried every
> > combination of single, double and no quotes in and around everything in
> > this piece of script. The most common error is:
> >
> > Incorrect syntax near 'a2'.
> 
> If that's the error message you're getting you probably added the single
> quotes but omitted the '$' sign.  Try printing out your query string
> before submitting it to the DBMS.
> 
> -- 
> Bob Kline
> mailto:bkline AT rksystems.com
> http://www.rksystems.com