in reply to Re: Re: DBI Long File names?
in thread DBI Long File names?
For identifiers, each database has its own quoting mechanism. The ANSI standard is double quotes:
SQL Server uses square brackets:SELECT foo FROM "$bar"
SELECT foo FROM [$bar]
New versions of DBI have the $dbi->quote_identifier method. It can be used the same as $dbi->quote
my $quoted_log = $dbi->quote_identifier($log) my $sql = "SELECT foo FROM $quoted_log";
This may be new enough that DBD::XBase does not support. Then you will have to find out what quoting mechanism it uses and use that.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: Re: Re: DBI Long File names?
by talwyn (Monk) on Oct 02, 2003 at 15:07 UTC | |
|
Re: Re: Re: Re: DBI Long File names?
by talwyn (Monk) on Oct 06, 2003 at 18:52 UTC |