the only thing I did was assign values to all those date vars and such that he accesses, and values into the associative array.. no actual changes to his code... I was just saying that his code works.. but sure... I mean.. if it helps.. whatever.. :) 
$sc{1}="bob";
$sc{'eatit200'}="jane";
$sc{'testCINDY'}="cindy";
($SMONTH,$SDAY,$SYEAR,$SHOUR,$SMINUTE,$EDAY,$EYEAR,$EHOUR,$EMINUTE)=(1
+,2,3,4,5,6,7,8,9);
foreach my $sc_id (keys %sc) {

  # Oracle wil not let me put in that '0' at the start; all call_id's 
+will start with '7' 
  my $call_id = sprintf "7%02d%02d%02d%02d%02d%07d%02d%02d%02d%02d%02d
+",$SMONTH,$SDAY,$SYEAR,$SHOUR,$SMINUTE,$sc_id,$EDA

  my $status = "scheduling";

  my $temp_record_statement = qq!
  INSERT INTO SC_APPT
  (CONTACT, CALL_ID, SC_ID, CONT_PHN, AP_START, AP_END, STATUS, COMPAN
+Y,
  TRANS_ID, APPT_TYPE, REP_EMAIL, ADD_ST, ADD_STATE, ADD_CITY, ADD_ZIP
+)
  VALUES
  ('system_reserve', $call_id, $sc_id, 8003069329, '$start_time', '$en
+d_time', '$status', 'Quest Software',
  $trans_id, 'Internal', 'Joanna', 'placeholder', 'NJ', 'Montclair', 9
+99999999) !;

print $temp_record_statement, "\n";
print $sc_id, "\n";

  #$dbh->do("$temp_record_statement") || dienice("320 Couldn't execute
+ statement: $temp_record_statement $sc_id" . $sth-
}

[download]
I hope that helps... like I said.. I didn't really change anything.. it just worked to start with.. I was just pointing out that his problem was something different that what he was describing... -- bliz

In reply to RE: RE: Re: loop criteria not accessable in loop?? by bliz
in thread loop criteria not accessable in loop?? by jptxs

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.