Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

A bind variable is really needed here . . .

by hesco (Deacon)
on Nov 01, 2009 at 15:15 UTC ( [id://804349]=perlquestion: print w/replies, xml ) Need Help??

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 = ?'
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://804349]
Approved by AnomalousMonk
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (5)
As of 2024-04-23 21:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found