Skip to Content.
Sympa Menu

freetds - Re: What SQL syntax can I use with FreeTDS?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Peppi Vecchio" <PVecchio AT orangelake.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: What SQL syntax can I use with FreeTDS?
  • Date: Tue, 23 Jul 2002 08:14:31 -0400


> 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




Archive powered by MHonArc 2.6.24.

Top of Page