FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Michael,

Thanks, I replied to myself after a google search ;-)

BTW, what is the proper API way of doing it?  It'd be nice to support it.

Brian

On Tue, 29 Jan 2002, Michael Peppler wrote:

> Brian Bruns writes:
>  > FreeTDS does not manipulation of the SQL text prior to sending it to the 
>  > server, except in the case of TDS 7.0 an ascii string is converted to 
>  > unicode when submitted.  The content is not changed however.
>  > 
>  > you may want to try something like 
>  > 
>  > SELECT "Date" from "Table" 
>  > 
>  > and there is a way to turn strict ansi compliance on (escapes me at the 
>  > moment).  But long story short, ANSI defines " and ' as different 
> things.  
>  > ' (single quote) is used for string literals whereas " (double quote) is 
>  > used for identifiers such as tables/columns with spaces in them, eg 
>  > SELECT "My Column" FROM "My Table With Spaces in the Name"
>  > 
>  > So double quotes with ansi compliance turned on may work.
> 
> For Sybase you normally need to set the "quoted identifier" option for
> the connection.
> 
> This can be done at the API level (though I suspect that FreeTDS
> doesn't support this yet), or via a language request:
> 
> SET quoted_identifier on
> 
> Michael
> 
> 
>  > On Tue, 29 Jan 2002, Shrock, Court wrote:
>  > 
>  > > Here is my problem:
>  > > 
>  > > The database that I need to access has table names that are normally
>  > > reserved--ie, "Date", "Bit", etc...I would like to be able to pass the 
> query
>  > > "SELECT Date FROM Events" or "SELECT * FROM Events ORDER BY Date", but 
> the
>  > > response acts as though it thinks Date is a function (I know one does 
> exist,
>  > > but I want to refer to the column name, not the function).  I know this
>  > > because I get an error about wrong number of parameters with the query
>  > > "SELECT Date() FROM Events".  Any ideas?
>  > > 
>  > > Does freetds do any manipulating of the query string before it sends 
> it to
>  > > the server listed in the freetds.conf?
>  > > 
>  > > I can "SELECT * FROM Events" and the Date column is returned, but my 
> problem
>  > > is that how can one include reference to "Date" in the WHERE, GROUP, 
> and
>  > > ORDER portions of the query?  Incidently, the "SELECT * FROM Events" 
> returns
>  > > the data that I need--connectivity is not a problem.
>  > > 
>  > > I am accessing the database via PHP-4.1.1/freeTDS-0.53 on linux-2.2.19.
>  > > 
>  > > Many thanks,
>  > > Court
>  > > 
>  > > 
>  > > ---
>  > > You are currently subscribed to freetds as: [camber AT ais.org]
>  > > To unsubscribe, forward this message to $subst('Email.Unsub')
>  > > 
>  > 
>  > 
>  > ---
>  > You are currently subscribed to freetds as: [mpeppler AT peppler.org]
>  > To unsubscribe, forward this message to $subst('Email.Unsub')
> 
>