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