Re^5: Perl $dbh->prepare failed

actually I thought if the refernce is there(if I can print the reference with some hexadecimal code) the database connection is there.

No... it don't work that way. As soon as your first script exited that handle was destroyed. There's no (easy) way of passing a handle from one process reference to another unless you are using some sort of persistance layer.

Peter L. Berghold -- Unix Professional
Peter -at- Berghold -dot- Net; AOL IM redcowdawg Yahoo IM: blue_cowdawg

Comment on Re^5: Perl $dbh->prepare failed

Replies are listed 'Best First'.
Re^6: Perl $dbh->prepare failed by thil (Sexton) on Sep 12, 2006 at 13:17 UTC
Thanks for all your assistence.	[reply]
Re^7: Perl $dbh->prepare failed by aquarium (Curate) on Sep 14, 2006 at 18:18 UTC
as has been pointed out..your database handle becomes invalid from script to script, as they are individual instances of perl. in case of using mod_perl on a webserver you have to be aware of a basic gotcha..mod_perl runs one instance of perl and bootstraps the script code into it. this produces some weird results if you're not careful with variables, as these (variables of same name) will keep their values from previous run. this would explain you being able to print a (supposedly valid) reference to the database handle from the second script. Unfortunatelly this is just a left over value due to mod_perl side effects, but the database handle is actually invalid. from what i understand of your web application, it doesn't need to keep sessions alive and complex state handling. I understand that one script gets some form input and generates a clickable table or form or such. then clicking on this calls the second script to generate more output etc. For this kind of thing you make each script totally independent and "atomic". first script gets called: process input, open database, read, close database, generate output. second script would do exactly same. without special attention, coupling these separate scripts closer together is a recipe for problems. the hardest line to type correctly is: stty erase ^H	[reply]