Re: Placeholders for profiling?
[email protected] ("Greg Sabino Mullane")
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
> We've got a situation where we need to get the placeholders
> used for statements when doing profiling. I've RTFM'd and RTFS'd
> and not found any leads. What do I need to poke to get this
> information?
I'm not terribly familiar with DBI::Profile, but looking at the
code, the main bits are in DBI's DBI.xs, and the execute section of
dbi_profile only looks at $h->{Statement}, not $h->{ParamValues},
so I don't think the information is available.
Thus, your options are probably to call $h->{ParamValues} yourself,
or increase the DBI logging to have it show the execute values.
Looks like a trace level of 1 should be sufficient for the latter.
- --
Greg Sabino Mullane [email protected]
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201002091756
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAktx6FgACgkQvJuQZxSWSsg9bwCgxLR4fHPfO7ujZAk/SnxWeYQX
KEUAn1hYZxjx0YhZi55q+KoqD9umv1rJ
=WOsg
-----END PGP SIGNATURE-----