RE: DBI->prepare problem w/ trace

2003-01-16 Thread Dan Muey
Nevermind. I figured it out. It seems that in the routine that contained the eval changed the value of $db_use to $db_user due to my bad typing. Which made it seem like the eval was the problem when it wasn't. So it couldn't prepare the statement because that table didn't exist in the database

RE: DBI->prepare problem w/ trace

2003-01-16 Thread Dan Muey
Just FYI Here's the entire code surrounding it from db connection to disconnect : my $dbhqq = DBI->connect("DBI:mysql:$db_use:$db_host","$db_user","$db_pass"); $queryqq = "SELECT * FROM $root_table WHERE ID=\'$Root_ID_DB\'"; print $queryqq; #DBI->trace(1,"trace.txt"); ($tmp = $quer

DBI->prepare problem w/ trace

2003-01-16 Thread Dan Muey
Howdy group, I've also posted this message with the dbi mailing list but so far nothing from them... I have a script that does several queries and I have trouble with one : I can't seem to get a particular query to prepare(). $queryqq = "SELECT * FROM $root_table WHERE ID=\'$Root_ID_DB\'"; P