Databases
StackOverflow2013
Postsdbo
POCannot pass datetime from value field within the jquery
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCannot pass datetime from value field within the jquery
    text
    copied!<p>I have this code which adds textbox after every half an hour this is the screenshot of that <img src="https://i.stack.imgur.com/9Cvjp.jpg" alt="enter image description here"></p> <p>The thing I have marked is the the <code>yo</code> variable. This is part of the code </p> <pre><code>&lt;script type="text/javascript"&gt; $(document).ready(function(){ document.getElementById('time').value = yo; var data=$('#data').val(); var counter = 1; var d=new Date(); var i; var newdate= new Array(); newdate=$('#newdate').val(); newdate= newdate.replace("[", "").replace("]", ""); var newdate1=newdate.split(","); var a=newdate1[0]; var b=newdate1[1]; var c=newdate1[2]; var dateString=$('#strtime').val(); var dateString2=$('#endtime').val(); var dateString1=$('#date').val(); var d1 = new Date(dateString1+" "+dateString); var d5= new Date(dateString1+" "+dateString2); var yo=d1; var d3=new Date(dateString1+" "+a); var d4=new Date(dateString1+" "+b); function msToTime(Milliseconds) { var d = new Date(Milliseconds); return [d.getHours(), d.getMinutes(), d.getSeconds()].join(':'); } setInterval(function() { var xtime=null; if(yo.getTime() &lt;= d.getTime() &amp;&amp; yo.getTime() &lt;= d5.getTime()){ if( (d1.getTime() == d3.getTime()) || (d1.getTime() == d4.getTime())){ var freq=$('#freq').val(); freq=parseInt(freq); var newTextBoxDiv = $(document.createElement('div')).attr("id", 'TextBoxDiv' + counter); newTextBoxDiv.after().html('&lt;div&gt;&lt;label style="float:left;"&gt;'+yo+'&lt;/label&gt;&lt;/div&gt;&lt;textarea name="textbox' + counter + '" id="textbox' + counter + '" &gt;&lt;/textarea&gt;&lt;input type="hidden" id="time" name="time" value='+yo+'/&gt;'); newTextBoxDiv.appendTo("#TextBoxesGroup"); yo.setMinutes(yo.getMinutes() + freq); } counter++; } },1000); }); &lt;/script&gt; </code></pre> <p>The yo value appears in the label as you can see in the screenshot.But when I type something in the textbox of 14:30 and send it to the database,for some reason only fri gets passed and I get a mysql error</p> <pre><code>com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: 'Fri' for column 'time' at row 1 </code></pre> <p>The column in mysql is datetime.</p> <p>I also tried with time column. and the code I had used was the same except for this line</p> <pre><code>newTextBoxDiv.after().html('&lt;div&gt;&lt;label style="float:left;"&gt;'+yo+'&lt;/label&gt;&lt;/div&gt;&lt;textarea readonly="readonly" name="textbox' + counter + '" id="textbox' + counter + '" value="'+msToTime(yo.getTime())+'0" /&gt;'); </code></pre> <p>In the value of the hidden field I used to take the milliseconds and convert to only time and pass to the database.The time used to pass but not 14:30 but instead 11:30.The first time.</p> <p>Please provide me suggestions on either of them.</p> <p><strong>UPDATE</strong></p> <pre><code>&lt;% java.util.Date now = new java.util.Date(); String DATE_FORMAT = "yyyy-MM-dd hh:mm:ss"; SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT); String date = sdf.format(now) ; String time=request.getParameter("time"); String data0=request.getParameter("textbox1"); String data1=request.getParameter("textbox2"); String data2=request.getParameter("textbox3"); String data3=request.getParameter("textbox4"); String data4=request.getParameter("textbox5"); String data5=request.getParameter("textbox6"); String data6=request.getParameter("textbox7"); String data7=request.getParameter("textbox8"); String data8=request.getParameter("textbox9"); String data9=request.getParameter("textbox10"); String data10=request.getParameter("textbox11"); String data11=request.getParameter("textbox12"); String data12=request.getParameter("textbox13"); String data13=request.getParameter("textbox14"); String user = session.getAttribute("par1").toString(); Connection con=null; String message=""; try{ Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/gla", "root", "root"); Statement st=con.createStatement(); String sql = "INSERT INTO user_data (date,user,data0,data1,data2,data3,data4,data5,data6,data7,data8,data9,data10,data11,data12,data13,time) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; PreparedStatement statement = con.prepareStatement(sql); statement.setString(1, date); statement.setString(2, user); statement.setString(3, data0); statement.setString(4, data1); statement.setString(5, data2); statement.setString(6, data3); statement.setString(7, data4); statement.setString(8, data5); statement.setString(9, data6); statement.setString(10, data7); statement.setString(11, data8); statement.setString(12, data9); statement.setString(13, data10); statement.setString(14, data11); statement.setString(15, data12); statement.setString(16, data13); statement.setString(17, time); int row = statement.executeUpdate(); if (row &gt; 0) { message="Edit"; } } catch (SQLException ex) { message = "ERROR: " + ex.getMessage(); ex.printStackTrace(); } finally { if (con != null) { // closes the database connection try { con.close(); } catch (SQLException ex) { ex.printStackTrace(); } } } %&gt; &lt;/body&gt; &lt;/html&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload