Tim,
In the thread "problem with DBD::ODBC and placeholders
[SEC=UNCLASSIFIED]" on dbi-users recently you said:
> Drivers that support named placeholders like ":N" where N is an
> integer, could support both forms of binding: bind_param(":1",$v) and
> execute($v)
> It's not dis-allowed. Driver docs should clarify this issue.
Is it really your intention that to bind named parameter "fred" as in
the SQL "insert into xxx values(:fred)" you call bind_param(":fred",$v)?
As it happens DBD::ODBC has a bug in its support of named parameters
(other than :1, :2 etc) which means it did not work at all but it ALSO
expects the name parameter ":fred" above to be passed to bind_param as
"fred" i.e. the leading ':' is treated as an introducer and not part of
the parameter name. I believe, but am prepared to be put right, other
non-perl database drivers also drop the ':' when binding.
As it didn't work before I can change it to be either - just let me know.
Thanks.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
