I am trying to insert data into a newly created table with <br>$result = db_insert('cc_npo_storage')<br> ->fields(array(<br> 'ein' => '$afields[0]',<br><br>table is defined<div class="line" id="LC34">
<span class="sd"> * CREATE TABLE `cc_npo_storage` (</span></div><div class="line" id="LC35"><span class="sd"> * `ein` varchar(10) NOT NULL,</span></div><br>The data I am inserting into field ein is ( '$afields[0]') <br>
Array[0] => 010759876 <br><br>(I used the php command explode to take apart a delimited input string thus the array). <br><br>My problem is that I am getting the following message:<br><em class="placeholder">PDOException</em>: SQLSTATE[22001]: String data,
right truncated: 1406 Data too long for column 'ein' at row 1: INSERT
INTO {cc_npo_storage} (ein, name, city, state, country, tforeign,
flagged, nid) VALUES (:db_insert_placeholder_0,
:db_insert_placeholder_1, :db_insert_placeholder_2,
:db_insert_placeholder_3, :db_insert_placeholder_4,
:db_insert_placeholder_5, :db_insert_placeholder_6,
:db_insert_placeholder_7); Array
(
[:db_insert_placeholder_0] => $afields[0]
[:db_insert_placeholder_1] => $afields[1]
[:db_insert_placeholder_2] => $afields[2]
[:db_insert_placeholder_3] => $afields[3]
[:db_insert_placeholder_4] => $afields[4]
[:db_insert_placeholder_5] => $afields[5]
[:db_insert_placeholder_6] => $afields[6]
[:db_insert_placeholder_7] => $afields[7]
)
in <em class="placeholder">insertdata()</em> (line <em class="placeholder">125</em> of <em class="placeholder">\sites\all\modules\custom\input\input.module</em>).<br><br>I have googled to no avail. <br><br>Thanks for any help<br>
Tony<br clear="all"><br>-- <br><p><b style="font-family:'Lucida Handwriting',cursive;font-size:13px;background-color:rgb(255,255,255)"><i>Anthony Stefan Maciejowski</i></b></p><p></p><br><p></p><br>