Use select * sparingly! Explicitly select cols & keep db formatting & db logic on the db side.
Quoting Keith <[EMAIL PROTECTED]>: >> I wasn't formatting anymore. I did not have an "AS column_name" after the >> TO_CHAR(), >> though. That lets it display. Thanks. >> >> Only problem I can see with this, though, is that I now have to explicitly >> list all the >> columns I need from a table if there's a date in it. There are some queries >> where I need >> all columns and do a SELECT *, and this wouldn't be an easy fix for some of >> them. Still >> looking through the taglib documentation. I'm still pretty new to custom tag >> libraries, so >> it's slow going now. >> >> Keith >> >> >> ---------- Original Message ----------- >> From: David Schwartz <[EMAIL PROTECTED]> >> To: Tag Libraries Users List <[EMAIL PROTECTED]> >> Sent: Mon, 16 Aug 2004 13:35:50 -0400 >> Subject: RE: Display Taglib & Dates >> >> > Once it's returned from oracle simply display using JSTL. There wont be a >> need >> > to format. >> > >> > Quoting Keith <[EMAIL PROTECTED]>: >> > >> > >> That is what the TO_CHAR() function does. Using it results in no output >> > >> (empty table >> > >> cells) with the display taglib, tho. >> > >> >> > >> Keith >> > >> >> > >> ---------- Original Message ----------- >> > >> From: "Karl Coleman" <[EMAIL PROTECTED]> >> > >> To: "Tag Libraries Users List" <[EMAIL PROTECTED]> >> > >> Sent: Mon, 16 Aug 2004 13:20:06 -0400 >> > >> Subject: RE: Display Taglib & Dates >> > >> >> > >> > I know T-SQL on MS SQL Server has functions that allow for date >> > >> formatting. Maybe >> > >> something similar exists for Oracle. >> > >> > >> > >> > Karl >> > >> > >> > >> > -----Original Message----- >> > >> > From: Keith [mailto:[EMAIL PROTECTED] >> > >> > Sent: Monday, August 16, 2004 1:18 PM >> > >> > To: Taglibs >> > >> > Subject: Display Taglib & Dates >> > >> > >> > >> > I just got the Display taglib to try and make some of my job a little >> > >> easier. Things >> > >> > seemed to be going good til I ran across the problem of a date field. >> I'm >> > >> pulling from an >> > >> > Oracle database, so the following query: >> > >> > >> > >> > <sql:query var="projects"> >> > >> > SELECT a.project_id, >> > >> > a.project_name, >> > >> > a.kickoff_date >> > >> > FROM project_main a >> > >> > ORDER BY project_id DESC >> > >> > </sql:query> >> > >> > >> > >> > returns something like this: >> > >> > >> > >> > 10016 >> > >> > Project1234 >> > >> > 2004-07-15 00:00:00.0 >> > >> > >> > >> > I'd like to format the date field to look like this: 15-Jul-2004 >> > >> > Before, I just used the <fmt:formatDate> tag, but I'm at a loss for >> how to >> > >> use it in >> > >> > conjuction with the display taglib. I tried using the TO_CHAR >> function in >> > >> the database >> > >> > query to format my date beforehand, but then it doesn't return any >> date >> > >> information at >> > >> > all. Any help? >> > >> > >> > >> > Keith >> > >> > >> > >> > --------------------------------------------------------------------- >> > >> > To unsubscribe, e-mail: [EMAIL PROTECTED] >> > >> > For additional commands, e-mail: [EMAIL PROTECTED] >> > >> > >> > >> > --------------------------------------------------------------------- >> > >> > To unsubscribe, e-mail: [EMAIL PROTECTED] >> > >> > For additional commands, e-mail: [EMAIL PROTECTED] >> > >> ------- End of Original Message ------- >> > >> >> > >> >> > >> --------------------------------------------------------------------- >> > >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> > >> For additional commands, e-mail: [EMAIL PROTECTED] >> > >> >> > >> >> > >> > David Schwartz >> > Array Software Inc. >> > http://www.arrayone.com >> > >> > --------------------------------------------------------------------- >> > To unsubscribe, e-mail: [EMAIL PROTECTED] >> > For additional commands, e-mail: [EMAIL PROTECTED] >> ------- End of Original Message ------- >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> David Schwartz Array Software Inc. http://www.arrayone.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
