I am using activestate version 5.8 on XP with DBI 1.38. I am trying to return values into an associative array so that I don't keep needing to connect to the database. I am new to perl and DBI is looking like rocket science. The code below has been gleaned from the Internet so I am not completely sure what is going on.
Basically I need to read the values into the array so that they can be called anywhere within the script. When I use print " drop folder $queue {'cch'}\n"; as a test for a known value i get a nil value. Any help would be much appreciated. Cheers Neill sqlstatement="SELECT KeyName,[Value] FROM ConfigTable where SectionName = 'OPIQ'"; #Select rows from table $sth = $dbh->prepare($sqlstatement); $sth->execute || die "Could not execute SQL statement ... maybe invalid?"; while (my $opi = $sth->fetchrow_hashref){ my %queue = $opi }; ******************** IMPORTANT NOTICE This email (including any attachments) is meant only for the intended recipient. It may also contain confidential and privileged information. If you are not the intended recipient, any reliance on, use, disclosure, distribution or copying of this email or attachments is strictly prohibited. Please notify the sender immediately by email if you have received this message by mistake and delete the email and all attachments. Any views or opinions in this email are solely those of the author and do not necessarily represent those of Trinity Mirror PLC or its associated group companies (hereinafter referred to as "TM Group"). TM Group accept no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. Although every reasonable effort is made to keep its network free from viruses, TM Group accept no liability for any virus transmitted by this email or any attachments and the recipient should use up-to-date virus checking software. Email to or from this address may be subject to interception or monitoring for operational reasons or for lawful business practices. Trinity Mirror PLC is the parent company of the Trinity Mirror group of companies and is registered in England No 82548, with its address at One Canada Square, Canary Wharf, London E14 5AP. ******************** -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>