php - Date Insertion Issue in Oracle Database and Codeigniter -

-

I have trouble updating the Oracle DB table with date column. I have tried many solutions but now Also not working I can not insert date into database codeigniter using active record or common query. Column type timestamp. Here are some solutions I can try Please help 

  $ this-> Db- & gt; Set ('AC_START', 'TO_DATE (' 2014-03-4 2:30 ',' yyyy-mm-dd hH: mm ')); $ this-> db- & gt; set (' AC_END ' , 'TO_DATE (' 2014-05-5 2:34 ',' yyyy-mm-dd hh: mm ') "); $ This- & gt; Db- & gt; Putting ('activities');   
 Here is the error message that I always get  
 Error number:  
  INSERT "LI_PPPA". "Action" ("AC_START", "AC_END") value ('TO_DATE (' 2014-03-4 2:30 ',' yyyy-mm-dd hh: mm '),' TO_DATE ('2014-05-5 2:34 ',' Yyyy-mm-dd hh: mm ')')   
  filename:  directory \ program \ system \ database \ db_driver.php Line number: 330  
 
 You have to ensure that CI does not escape the original values ​​that you are going through the Oracle database. , Because  To_date  is an oracle function.  
 Try the following:  
  $ this-> Db- & gt; Set ('AC_START', 'TO_DATE (' 2014-03-4 2:30 ',' yyyy-mm-dd hh: mm ') ", FALSE); $ This- & gt; Db- & gt; Set ('AC_END', 'TO_DATE (' 2014-05-5 2:34 ',' yyyy-mm-dd hh: mm ') ", FALSE); $ this-> db- & gt; insert (' Activity '); Code here   
 You are telling the codigator to avoid that value.

Comments

Post a Comment

Popular posts from this blog

jsp - No mapping found for HTTP request with URI with annotation config Spring MVC and Jetty -

-
Image
I'm only using annotation configuration, the server starts, but when I use some pages error is displayed: Warning: no mapping found for HTTP request with URI [/WEB-INF/view/main.jsp] name 'org.springframework.web.servlet.DispatcherServlet -D7259e with DispatcherServlet in Controller mapping works fine, but no JSP page is full. I am using Jetty 9.2.0.M0 and Spring MVC 4.0.4 release. JetTyP Config: Private Static Last String CONTEXT_PATH = "/"; Private Static Last String MAPPING_URL = "/ *"; Private Zero Server (Int port) throws exceptions {server server = new server (port); Server.addLifeCycleListener (New LifeCycleListener ()); Server.setHandler (getServletContextHandler (getContext ())); Server.start (); Server.join (); } Private static ServletContextHandler getServletContextHandler (WebApplicationContext context) throws IOException {LOGGER.info ( "ServletContextHandler is ready"); CircleContaxHandler themeHandler = new circactont...
Read more

c# - Roxy file manager in MVC doesn't accept session path -

-
Hi friends I've downloaded a file manager for my MVC project. So I added to my project and everything works fine but everyone can use this product I mean everyone can type urls and upload files to my host !!!! This filemanager has a Jason config file, as you can see here: {"FILES_ROOT": "Fileman / Upload "," "File_type_kenny": "file", "THUMBS_VIEW_WIDTH": "140", "THUMBS_VIEW_HEIGHT": "120", "PREVIEW_THUMB_WIDTH": "300", "PREVIEW_THUMB_HEIGHT": "200", "MAX_IMAGE_WIDTH": "0" "ASP_net / Main.Shex? A = Created", " Dealederer ":" ASP_net / MAN.assx "ADELEDED IR "," MOVEDIR ":" ASP_net / Main.Shex? A = MoVEDIR "," Copdier ":" ASP_net / Main.Shex? A = Copdier "," Richie Dar ":" ASP_net / Main ASP_net / main.hex? A = Upload "," Downlo...
Read more

java - Ajax call to jsp and jsp redirecting to further jsp -

-
I am getting an Ajax call on a jsp page which in turn is redirecting based on the value of a flag variable JSP file. The AJAX call is something like this: $ Ajax ({url: 'uploadwebcamimage.jsp', type: "post", data: {encodeimg: dataUrl, OwnerId: document.Clickpictures.OwnerId.value, OwnerPhone: document.Clickpictures.OwnerPhone.value, mobilepass: document.Clickpictures. Mobilepass.value, emailpass: document.Clickpictures.emailpass.value, mypassword: document.Clickpictures.mypassword.value, mygroupuserid: document.Clickpictures.mygroupuserid.value}, error: work () {warning ('error');} success : Function (msg) {// warning ((msg)); if (msg) indexOf ("true")> = 0) {// how grouplist location.href = "site_index_groupadmin.jsp res1 =?" + to get the grouplist;} else {warning ("unsuccessful");}}}); And in jsp I have done something like this: & lt;% ArrayList & lt; String & gt; List = New Arrestist & lt; Stri...
Read more