[Catalyst] DBIx::Class::Loader::mysql

[Ben Norman]

# mysql -V
mysql  Ver 14.7 Distrib 4.1.13, for suse-linux (i686) using readline 5.0

The backticks dont help on line 52 when running the app where it says

my $query = "SHOW TABLE STATUS FROM $dbname LIKE $table";

thanks
ben

Sebastian Riedel wrote:

>
> Am 16.11.2005 um 00:43 schrieb ben.norman at qmunity.net:
>
>> Andy,
>> I was putting a simple little front end together for a database of  
>> keys (the
>> kind of keys that open a door) for a client.
>>
>> catalyst.pl Keys
>> mv Keys keys
>> cd keys
>> script/keys_create.pl model DB DBIC 'dbi:mysql:keys' keys keys
>>
>> Ran the create script using DBIC as the model helper, it failed to  
>> create for
>> the table named key.
>> I applied the following mod which made it work.
>>
>> l0027:/opt/ewide # diff perl/DBIx/Class/Loader/mysql.pm
>> /usr/lib/perl5/site_perl/5.8.7/DBIx/Class/Loader/mysql.pm
>> 86c86
>> <     my $query = "DESCRIBE `$table`";
>> ---
>>
>>>     my $query = "DESCRIBE $table";
>>
>
> Which mysql versions do accept a quoted table name?
>
>
> -- 
> sebastian
>
>
> _______________________________________________
> Catalyst mailing list
> Catalyst at lists.rawmode.org
> http://lists.rawmode.org/mailman/listinfo/catalyst