freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: What SQL syntax can I use with FreeTDS?

From: Bob Kline <bkline AT rksystems.com>
To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
Subject: Re: What SQL syntax can I use with FreeTDS?
Date: Mon, 22 Jul 2002 18:28:41 -0400 (EDT)

On Mon, 22 Jul 2002, Peppi Vecchio wrote:

> 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

What SQL syntax can I use with FreeTDS?, Peppi Vecchio, 07/22/2002
- <Possible follow-up(s)>
- Re: What SQL syntax can I use with FreeTDS?, Bob Kline, 07/22/2002
- Re: What SQL syntax can I use with FreeTDS?, Peppi Vecchio, 07/22/2002
- Re: What SQL syntax can I use with FreeTDS?, Patrick Muldoon, 07/22/2002
- Re: What SQL syntax can I use with FreeTDS?, Bob Kline, 07/22/2002
- Re: What SQL syntax can I use with FreeTDS?, Peppi Vecchio, 07/23/2002