Hi Regarding you date-format question: When using the dateLabel tag, it has an attribute called pattern which takes a String value compliant with java.text.SimpleDateFormat. Take a look at http://java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html for valid formats. For instance, if you would like to use the Oracle date format DD.MM.YYYY, your dateLabel pattern should have the value dd.MM.yyyy (which is java.text.SimpleDateFormat) compliant.
By the way, the default date format in Oracle is DD-MON-YY, but when working with dates in Oracle they are allways saved in some internal format, so no mather what format you save it with you can allways retrieve it later in a different format, usually by using the enviroment varibale NLS_DATE_FORMAT or using NLS_DATE_FORMAT in an alter session statement. If I understand you correctly, your desired dateformat is "DD MMMM YYYY" ? In java.text.SimpleDateFormat that will be "dd MMMM yyyy", but please note that the four letter month will be written staring with a capital, for instance June. On 5/30/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi everyone, > > i am new to dbforms, and i have some problems and questions: > > FirstPoint: > ----------- > i am working with WSAD5.1.2 and dbforms2.5.20050226 and oracle9i > > i my project i have some fields with date type. > > i have the exception when i try to update one row, with the single page: > > [30/05/05 13:48:36:084 CEST] 6933387a DbInsertButto I > org.dbforms.taglib.DbInsertButtonTag pos DbInsertButtonTag 1 > > [30/05/05 13:48:36:084 CEST] 6933387a DbFormTag I > org.dbforms.taglib.DbFormTag we are talking about=OTFE_OUTLET pcount=1 > pcurrent=1 > > [30/05/05 13:48:36:084 CEST] 6933387a DbFormTag I > org.dbforms.taglib.DbFormTag setting footerreached to true > > [30/05/05 13:48:36:099 CEST] 6933387a DbFormTag I > org.dbforms.taglib.DbFormTag we are talking about=OTFE_OUTLET pcount=1 > pcurrent=2 > > [30/05/05 13:48:36:130 CEST] 6933387a DbFormTag I > org.dbforms.taglib.DbFormTag end reached of OTFE_OUTLET > > [30/05/05 13:48:36:130 CEST] 6933387a DbFormTag I > org.dbforms.taglib.DbFormTag doFinally called > > [30/05/05 13:48:38:849 CEST] 6933387a WebGroup E SRVE0026E: [Erreur de > servlet]-[org/apache/regexp/RESyntaxException]: > java.lang.NoClassDefFoundError: > org/apache/regexp/RESyntaxException > at org.dbforms.config.FieldValue.parseDATE(FieldValue.java:646) > at > org.dbforms.config.FieldValue.getFieldValueAsObject(FieldValue.java:585) > at > org.dbforms.config.FieldValue.getFieldValueAsObject(FieldValue.java:234) > at > org.dbforms.event.classic.UpdateEvent.processEvent(UpdateEvent.java:205) > at org.dbforms.servlets.Controller.process(Controller.java:309) > at org.dbforms.servlets.Controller.doPost(Controller.java:107) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) > at > com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) > at > com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) > at > com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) > at > com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200) > at > com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119) > at > com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276) > at > com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) > at > com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116) > at > com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186) > at > com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) > at > com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) > at > com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618) > at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439) > at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672) > > > > the default pattern for date in oracle db is i think dd MMMM (4 char in > lowercase) and yyyy which i must keep. > > i have try to put this pattern in the <date-format> tag but no success so i > have > also try to put this pattern in the "pattern" attribut in the dateField tag in > my JSP, but same thing no success too. > > i have read some discussion in this mailing list, and i think i have to write > a > class called SingleDateFormat ? > > what i would like to do is to define the pattern in a property file, and tell > to > the dateField tag to use this pattern from the property file and use a > JScalendar too in the same time with the same pattern if possible. > > > > Second Point: > ------------- > > i would like to use tags related to blob type, store en file system. > I have the name of my picture in one field for some tables. > but i have the prefix path on my file system in a property file : > myAppliName.properties (like directory.image.tableNameA.picture = > d:/temp/upload/tableNameA/picture) > > how can i use the blobURL or blobContent tag ? to do download and upload. > > I think i have to write or to use the BlobInterceptor for the upload and the > "nameField" attribute for the download but i don't know how. > > > > Does anyone can help me to fix my date problem, and help me or give me > exemples > for the blob question ? > > > Many thanks, > > Pascal > > > > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > > > ------------------------------------------------------- > This SF.Net email is sponsored by Yahoo. > Introducing Yahoo! Search Developer Network - Create apps using Yahoo! > Search APIs Find out how you can build Yahoo! directly into your own > Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > -- best regards Audun ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
