Re: Column names have spaces in them!!!
- From: bogus@xxxxxxxxxxxxx (Unknown Sender)
- Date: Tue, 31 Jan 2006 12:10:22 -0500
I believe you want square-brackets for Access:
my $sth = $dbh->prepare("SELECT * FROM taskhours_per_date WHERE [EMPLOYEE NAME]
= ?");
Paul
Quoting Robert Hicks <sigzero@xxxxxxxxx>:
> 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
>
.
- References:
- Column names have spaces in them!!!
- From: Robert Hicks
- Column names have spaces in them!!!
- Prev by Date: Column names have spaces in them!!!
- Next by Date: Re: Column names have spaces in them!!!
- Previous by thread: Column names have spaces in them!!!
- Next by thread: Re: Column names have spaces in them!!!
- Index(es):
Relevant Pages
|
|
