Help for this page

Select Code to Download


  1. or download this
    DEBUG: $self->_process_cc_pre_confirm() says the sql.get_new_subscribe
    +r query reads:  
    $VAR1 = 'SELECT lsmb_acct_id, addr1, addr2, city, state, zip, billing_
    +plan, billing_cycle, fname, lname, email, phone FROM accounts a LEFT 
    +JOIN account_users u ON a.account_code = u.account_code WHERE account
    +_billing_contact = \\\\\\'yes\\\\\\' AND a.account_code = ?';
    Uncaught exception from user code:
    \tDBD::Pg::st execute failed: called with 1 bind variables when 0 are 
    +needed at . . . line 569.
    
  2. or download this
      my $sql = $self->{'cfg'}->param("sql.get_new_subscriber");
      $self->log('DEBUG','$self->_process_cc_pre_confirm() says the sql.ge
    +t_new_subscriber query reads: ',$sql);
      my $sth = $self->{'dbh'}->prepare($sql);
      $sth->execute($self->{'s'}->param('account_code'));
      my $subscriber = $sth->fetchrow_hashref();
    
  3. or download this
    get_new_subscriber='SELECT lsmb_acct_id, addr1, addr2, city, state, zi
    +p, billing_plan, billing_cycle, fname, lname, email, phone FROM accou
    +nts a LEFT JOIN account_users u ON a.account_code = u.account_code WH
    +ERE account_billing_contact = \'yes\' AND a.account_code = ?'