On Fri, 3 Jan 2003 15:36:11 +1100 Ron Savage <[EMAIL PROTECTED]> wrote:
> In this, admittedly unusual, situation the above occurs:
> OS: Win2K
> Perl: V 5.8.0
> DBI: V 1.32
> ODBC: 1.01
> DSN: Points to a Microsoft Access database
> Table name: Nathan Bailey (note the single space)
>
> If I do:
> select * from `Nathan Bailey`
> it works. Yes, they are backticks.
> If I do
> select col_a, col_b from `Nathan Bailey`
> I get:
> Describe failed during DBI::st=HASH(0x1c9f0b8)->FETCH(ParamValues)
I presume this is the error message in $DBI::errstr (aka $sth->errstr).
Adding $dbh->trace(4); before you prepare the statement may give you
more details of what is happening. The contents of $sth->{Statement}
would also be interesting.
It would help us understand your problem if you post a snippet of the
code that demonstrates the problem.
> This problem does not arise with other 'funny' table names, eg:
> `Display_ISDT_210_&_Digital` (note the &).
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
