jstl and blob

2004-03-30 Thread Lorenzo Sicilia
Hi to the list, Do I can use sql tag to make a blob? Like this: sql:update INSERT INTO foo (filename,file) VALUES(?,?) sql:paramfooFile/sql:param sql:param value=${image}/ /sql:update I had try but ${image} contains only fileName.I know is better use a upload tag or

RE: XML XPath expression help

2004-03-30 Thread Johnson, Chris
Doh! I wasn't paying close enough attention to your newsSources XML. I would think it should work like this: x:forEach select=$newsSources//eachNewsSource[sourceID=$source] Because sourceID isn't an attribute of eachNewsSource, it's a child of it. You only use the '@' sign for referencing an

textarea/textarea not rendered correctly

2004-03-30 Thread Ashish Srivastava
Hi, In my XML I have a form like : ns:some ns:summary form textarea name=text rows=2 cols=48 wrap=hard/textarea /form /ns:summary /ns:some In the jsp I am using xtags to render the form as : xtags:copyOf select=/ns:some/ns:summary/node()/ Anything after /textarea is put

RE: XML XPath expression help

2004-03-30 Thread Dylan MacDonald
Nice! That works too. Thanks again - and thanks for the XPath lessons everyone. - Dylan -Original Message- From: Johnson, Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 6:07 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: Bill Siggelkow Subject: RE: XML XPath expression

Formatted date not returning

2004-03-30 Thread Keith
I'm trying to return a formatted date from an Oracle database. I format the date in the query itself using the TO_CHAR() funtion. The problem is, when I use the TO_CHAR() function, JSP is acting like nothing is returned. If I take the function out and just select the column as normal, it

Re: Formatted date not returning

2004-03-30 Thread Hassan Schroeder
Keith wrote: I'm trying to return a formatted date from an Oracle database. I format the date in the query itself using the TO_CHAR() funtion. The problem is, when I use the TO_CHAR() function, JSP is acting like nothing is returned. If I take the function out and just select the column as

creating body content

2004-03-30 Thread Dean A. Hoover
I have been experimenting with creating custom tags for a few days now and have created some simple but useful tags for my application. None of the tags I've written so far use any body content. Now I want to create a tag that does not have a body but will insert JSP code that needs to be

Re: Formatted date not returning

2004-03-30 Thread Keith
Nope, that didn't work. I don't see the identifiers being used anywhere in the Oracle book I have. It didn't throw an error or anything, just did the same thing. Thanks for the suggestion, though! I did notice that I do have formated dates returning in another document, but the forEach is using

More SQL Date problems

2004-03-30 Thread Keith
Now I'm thorougly confused. I could've sworn this was working before (as I claimed in my first email to the group. fmt:parseDate value=${param.dob} var=parsed_dob pattern=dd-MM- / sql:transaction sql:update INSERT INTO resource_registry ( dob ) VALUES (? sql:dateParam

Re: More SQL Date problems

2004-03-30 Thread Hans Bergsten
Keith wrote: Now I'm thorougly confused. I could've sworn this was working before (as I claimed in my first email to the group. fmt:parseDate value=${param.dob} var=parsed_dob pattern=dd-MM- / sql:transaction sql:update INSERT INTO resource_registry ( dob ) VALUES (?

Re: More SQL Date problems

2004-03-30 Thread Hans Bergsten
Keith wrote: Ahhh, ok. I assumed it was the JSTL stuff throwing the error. I've not done much programming in actual Java, which is why I'm using the JSTL library. The field is set to accept a NULL value in the database. There's already data in the database, and there's many DOB's missing for

Re: More SQL Date problems

2004-03-30 Thread Keith
Yeah, I'd read about not using that bridge driver. I'm using Oracle 9i Release 2, J2SE v1.4.2, and the JDBC Oracle Driver for JDK 1.4. Keith -- Original Message --- From: Hans Bergsten [EMAIL PROTECTED] To: Tag Libraries Users List [EMAIL PROTECTED] Sent: Tue, 30 Mar 2004

RE: Formatted date not returning

2004-03-30 Thread Martin van Dijken
Hey Keith, I still have to guess this has indeed something to do with JSTL not understanding the .dob . Haven't been around SQL much of late so I can't answer that one. Why not simplify this problem and use a fmt:formatDate tag instead of doing the formatting in SQL? Martin -Oorspronkelijk

RE: More SQL Date problems

2004-03-30 Thread Martin van Dijken
Hmm Keith, Can you specify the url you're using to connect to the database? * out the uid and psw of course... Also can you post a stack trace? I did a few Googles on your exception and heard some people shouting the oracle thin driver should work best. It's what I have used in the past and I've

RE: creating body content

2004-03-30 Thread Martin van Dijken
Hey Dean, A simple answer, it's not possible to do this. A tag is only allowed to create Template text which is output directly to the client. So your HTML etc would go fine, but your bean:message tag would be sent to the client unparsed as well. There might be something you can do in JSP 2.0