Hello,
... because it dies with error SQL-HY000 "handle already in use". Is there any way to make this return two different handles?
Could that be because the DBI plugin for TT uses prepare_cached, and thus returns
the same handle, since you try to open exactly the same handle twice? I don't
have the source in front of me, so I can't check though.
Two workarounds I can think of offhand, change the TT DBI code (not a good idea,
IMHO :), or add a variable to the second connect string that makes no difference.
i.e. AutoCommit = 1 in mysql, since mysql doesn't have commits and rollbacks
anyway (last I checked). All you need is one parameter difference, and it won't
return the cached statement handle.
Not sure about the rest...
-Andrew
( already getting use out of "Practical mod_perl" where he read this yesterday ;)
_______________________________________________ templates mailing list [EMAIL PROTECTED] http://lists.template-toolkit.org/mailman/listinfo/templates
