Paul,
thanks a lot. after following your instruction,
it works good now
I found every table, every collum has been quoted with [ ]
so, it works good now
Hugh Wang
Paul Findlay 写道:
> Hi Hugh
>
> You seem to be putting quote_char and name_sep into their own hash ref. You
> shou
I am trying to use DBIx Autorization function, I have a table named
User, and collumn named user
since user is a reserved word, it always get error,
I have added the quote_char, name_sep in the connection string
but still fail.
how can I make sure the generated SQL has the User been quoted ?
like
I think I found the reason:
I have following line in my DB.pm
_on_connect_do_ => q{PRAGMA foreign_keys = ON},
this was copied from sqlite example
the sql server can not run this command :
PRAGMA foreign_keys = ON
after I change to
_on_connect_do_ => q{},
the error gone
thanks
Hug
ther table in the same sql server database,
the error came again.
the strange thing is after a reload of the same page, the problem gone.
but restart the Catalyst server, it show up for the first connection
Hugh Wang
Hailin Hu 写道:
It seems the error only occurs on connection.
Do you hav
refresh to reload the page, it works good .
if I restart the server, the error will show up again for the first time
I open the same web page.
the refresh of the same page, will work good.
what's wrong with it? any one has experience
thanks
Hugh Wang
_