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

Reply via email to