| Subject: | Not worked with Class::DBI::Sweet ? |
I have "Class::DBI::Sweet" class that use mysql table "Order". To avoid
sql syntax error, i unsuccessfully try use "Class::DBI::Plugin::
Backtickify" module.
I use search method. When i turn on mysql query log i see wrong query
FROM clause:
----------------------------------------------------------------
SELECT `me`.`iduseragent`, `me`.`txtlog`, `me`.`intcount`, `me`.
`lsttype`, `me`.`lstname`
FROM order me
WHERE ( me.lstType = 'mobile' )
----------------------------------------------------------------
If i change
use base 'Class::DBI::Sweet';
with old
use base 'Class::DBI';
i get correct query:
----------------------------------------------------------------
SELECT `iduseragent`, `txtlog`, `intcount`, `lsttype`, `lstname`
FROM `order`
WHERE `lsttype` = 'mobile'
----------------------------------------------------------------
Is this a bug or "Class::DBI::Plugin::Backtickify" just unsupport
"Class::DBI::Sweet"?
Thanks.
Maxim Nechaev