As I said before, I'm not an ODBC expert at all, so I'm not sure the answer
to that.  You may want to try 0.29 as the bug fix had to do with quoting.

The "ugly solution" is to select * from the table and just pick the columns
you want from the result set.  If this is going to be a one time thing, I'd
consider that, or as a stop-gap until you get the space-in-the-column-name
thing figured out.


Carsten Sch�fer wrote:

> Jeff,
> I'�m using 0.28
> I already tried to install 0.30 but the ppm-archive isn't updated yet.
> Carsten
> BTW, is a column name with space in name called "SQLSpecialColumns"?
>
> > -----Urspr�ngliche Nachricht-----
> > Von: Jeff Seger [mailto:[EMAIL PROTECTED]]
> > Gesendet: Freitag, 11. Januar 2002 16:55
> > An: Carsten Sch�fer
> > Cc: [EMAIL PROTECTED]
> > Betreff: Re: AW: AW: Perl on W2K with ODBC and having trouble reading
> > from the sameDSNtwice
> >
> >
> > Alright I just took a quick peek at CPAN's website and saw that
> > SQLSpecialColumns are supported starting with version DBD::ODBC
> > 0.28 and there
> > is a bug fix in version  0.29 for them.  So if you are using
> > version 0.27 or
> > earlier, you may want to get the latest and greatest.
> >
> > See  http://search.cpan.org/doc/JURL/DBD-ODBC-0.30/ODBC.pm
> >
> > jeff
> >
> > Carsten Sch�fer wrote:
> >
> > > > Carsten Sch�fer wrote:
> > > >
> > > > > In NDS there are some tables with names like "Given Name".
> > > > > How can I prepare a SELECT statement with space in the
> > colum name? I've
> > > > > tried \"Given Name\", 'Given Name', [Given Name] and {Given Name}.
> > > > > Any idea?
> > > > > Carsten
> > >
> > > > Actually, what happens if you just prepare "select given name
> > > > from table" and
> > > > execute that?
> > > >
> > > > jeff
> > > >
> > >
> > > Jeff,
> > > I got the following
> > > "Prepare failed: Column not found: Given ---- at line --"
> > >
> > > Carsten
> >
> >

Reply via email to