I installed 0.30 and tried several ways for the column name with space.

my $command = $DB->prepare('SELECT NDS_Name, "Given Name" FROM UserNDS')
                                  ("SELECT NDS_Name, \"Given Name\" FROM UserNDS")
                                  ("SELECT NDS_Name, 'Given Name' FROM UserNDS")

and so one...

does anyone has an idea?

Carsten


> -----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