Kokarski, Anton wrote:
> I presume this happens the second time you call get_location_id sub?
>
> seems that your $sth is scoped in eval block.
>
> Anton
i don't believe i'm calling it more than once, but i think the reason is
that i've turned off AutoCommit. it sorta works like this:
- main sub
- turn off autocommit (begin_work)
- call add_item sub
- get location_id from fetch_location_id sub (see prior message)
- use location_id in another insert (call insert_object_&_location)
- add_other_objects_to_other_tables
- ...
- commit
- end sub
i hope that makes sense. basically, i think that maybe the fact that i
don't do finish a transaction before trying to use the data from the
select in an insert might be messing this up, but i'm still not sure why
it works without using the placeholders.
thanks,
twkonefal
--
"For, even if I believed in a natural right of property, independent of
utility and anterior to legislation, I should still deny that this right
could survive the original proprietor." -- Thomas Babington Macaulay
New Media Copyright Extensions Would Harm Canada:
http://ansuz.sooke.bc.ca/icsub.html
