The solution is:

my $command = $DB->prepare( qq / SELECT "Given Name" FROM UserNDS /);

Now everything is working!


Carsten


> -----Urspr�ngliche Nachricht-----
> Von: Jeff Seger [mailto:[EMAIL PROTECTED]]
> Gesendet: Freitag, 11. Januar 2002 17:14
> An: Carsten Sch�fer
> Cc: [EMAIL PROTECTED]
> Betreff: Re: AW: AW: AW: Perl on W2K with ODBC and having trouble
> reading from thesameDSNtwice
>
>
> 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