You need to pass the quotes to the SQL engine. And by the way, you
should either use parameters or the quote function for values:
my $sth=$dbh->prepare('select * from taskhours_per_date where "employee
name"=?');
$sth->execute('NAME HERE');
Maybe MS Acesss has other ways to do this, especially old Access
versions have some very strange behaviours.
Alexander
Robert Hicks wrote:
I am using the ODBC module to talk to an Access database. In that
database some of the column names have spaces in them (something like
EMPLOYEE NAME).
I have tried a bunch of stuff (backticking, brackets, braces,
variables) but I cannot seem to do a select on that table.
my $sth = $dbh->prepare("SELECT * FROM taskhours_per_date WHERE
`EMPLOYEE NAME` = 'NAME HERE'" );
How do I use a column name with spaces in it?!
I cannot change the table name itself.
Robert
--
Alexander Foken
mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/
