I always do that unless I am overly confident. Seriously, I do test them.

Speaking of SQL: Statement below in "=for comment" tests fine. The error messages when I execute within program say otherwise.

I can't see the problem.


         $stmt = "insert into users (user_id,username,password,pin,pos
+ition,forename,lastname,business,address1,address2,city,state,zip, em
+ail, phone_home, phone_cell, MJ, MD, DD, DP, comments) values ((SELEC
+T AUTO_INCREMENT FROMinformation_schema.TABLES WHERE TABLE_SCHEMA=DAT
+ABASE() AND TABLE_NAME='users'),CONCAT('bwm', (SELECT AUTO_INCREMENT 
+FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE()ANDTABLE_
+NAME='users')), ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

[download]
       my $sth = $dbh->prepare ($stmt) or die "Error Preparing:\n" . $
+stmt . "\nDBI returned: \n", $dbh->errstr;
    
      $value = $sth->execute ($password, $pin, $position, $forename, $
+lastname, $business, $address1, $address2, $city, $state, $zip, $emai
+l, $phone_home, $phone_cell, $MJ, $MD, $DD, $DP, $comments) or die "U
+nable to execute query: " . $sth->errstr;

      my $new_id = $sth->{'mysql_insertid'};

[download]
      
=for comment
      insert into users (user_id, username,password,pin,position, fore
+name,lastname,business, address1, address2,city,state,zip, email ,pho
+ne_home, phone_cell,MJ,MD,DD,DP, comments) values ( (SELECT AUTO_INCR
+EMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AN
+D TABLE_NAME='users'), CONCAT('bwm', (SELECT AUTO_INCREMENT FROM info
+rmation_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='u
+sers')), 'vmmv', 'BbwmB','3', 'Lucifer','Jackson','BWMLLC', '1610 W U
+dall St','Apt 1', 'Jasonville','UT','87167','dingy@yahoo.com','(203) 
+418-5467','(203) 245-4567','2017-01-31','120.00', '2018-03-21','2019-
+03-20','Blah Blah')
=cut

[download]

In reply to Re^7: New CGI Action Call by tultalk
in thread New CGI Action Call by tultalk

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.