in reply to Re^3: How to pass hash site variables into sql connection using perl?
in thread How to pass hash site variables into sql connection using perl?

i had used current because every database name will have current.So i tried to include those things inside it.
  • Comment on Re^4: How to pass hash site variables into sql connection using perl?

Replies are listed 'Best First'.
Re^5: How to pass hash site variables into sql connection using perl?
by poj (Abbot) on Mar 30, 2017 at 06:39 UTC

    But you didn't change the hash to suit like this

    #!perl use strict; my %site_map = ( site1 => { host => 'dam.sd.aog.com', db => 'a_site1_current', current => { user => 'ad', pw => '123' } }, site2 => { host => 'dam.sd.aog.com', db => 'a_site2_current', current => { user => 'ad', pw => '123' } }, site3 => { host => 'dam.sd.aog.com', db => 'a_site3_current', current => { user => 'ad', pw => '123' } }, );
      Here in db we had fetched the a_site3_current then why we want to use the current with user and pw?

        Consider these responses to be a good generic approach, obviously you'll alter them to best suit your situation, this is a task for you.

        why we want to use the current with user and pw?

        I have no idea since I didn't understand your answer here