title: Zip_Longest Returning One Result
body: <p>in my confirmAck function I am trying to use the file_date_l list in my SQL query. The thing is its only returning one &quot;file_date_l&quot;. When i do a seperate for loop that is not in my zip_longest then it returns 3 or 4 results. Why is it that when i use it with zip_longest it returns only one query?</p>
  <p>results:</p>
  <pre><code>select * from sendfile where processingdate = '    2020/12/07' and 
          paymenttotamt = 123.20 and datasetname like '%FILENAME%' 
  </code></pre>
  <p>expected results:</p>
  <pre><code>select * from sendfile where processingdate = '    2020/12/07' and 
          paymenttotamt = 123.20 and datasetname like '%FILENAME%' 
  
  select * from sendfile where processingdate = '    2020/12/07' and 
          paymenttotamt = 123.20 and datasetname like '%FILENAME%' 
  select * from sendfile where processingdate = '    2020/12/07' and 
          paymenttotamt = 123.20 and datasetname like '%FILENAME%' 
  </code></pre>
  <p>code edited:</p>
  <pre><code>def scrapeBOAWebsite(gp_url, gp_subject_l)
  
  
      icl_dollar_amount_l = []
      file_date_l = []
  
      for gp in gp_url_l:
          options = Options()
          options.add_argument('--headless')
          options.add_argument('--no-sandbox')
          options.add_argument('--disable-gpu')
          options.add_experimental_option(&quot;detach&quot;, True)
          browser = webdriver.Chrome(options=options,
                                     executable_path=r'\\TEST\user$\bxt058y\Documents\driver\chromedriver.exe')
          browser.get(gp)
          body = browser.find_element_by_xpath(&quot;//*[contains(text(), 'Total:')]&quot;).text
          icl_dollar_amount = re.findall('(?:[\£\$\€]{1}[,\d]+.?\d*)', body)[0]
          icl_dollar_amount_l.append(icl_dollar_amount)
          get_company_id = body.split(&quot;Customer Id:&quot;, 1)[1]
          get_file_date = body.split(&quot;Receipt Time:&quot;, 1)[1][0:14]
          print(get_company_id)
          file_date_l.append(get_file_date)
  
      return icl_dollar_amount_l, file_date_l
  
  def confirmAck(sql_server_conn, sql_server_cursor,icl_dollar_amount_l,file_date_l):
  
      for icl_dollar_amount,f_date in zip_longest(icl_dollar_amount_l, file_date_l):
          get_sendfile_details_q = f&quot;&quot;&quot;select * from sendfile where processingdate = '{f_date}' and 
          paymenttotamt = {str(icl_dollar_amount).replace(',', '').replace('$', '')} and datasetname like '%FILENAME%' &quot;&quot;&quot;
  
          get_sendfile_details_q_results = sql_server_cursor.execute(get_sendfile_details_q).fetchall()
  
          print(get_sendfile_details_q)
  
  icl_dollar_amount_l, file_date_l = scrapeBOAWebsite(gp_url_l, gp_subject_l)
  confirmAck(sql_server_conn, sql_server_cursor, icl_dollar_amount_l, file_date_l)
  </code></pre>