On Mon, 1 Apr 2002, Zvolensky, Thomas J {PDBI~Nutley} wrote:
> This is unfortunate as I need to return one record per user per date in my
> query, necessitating the DATE_FORMAT() function in my select.
Oh, I was just thinking that you could use the argument to DATE_FORMAT()
instead of the functi
layed under ORACLE? If so,
I'll move on to other things.
-Original Message-
From: Shawn Bayern [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 2:02 PM
To: Tag Libraries Users List
Subject: RE: JSTL Date Format Question
Okay, I looked at the JDBC driver's code. It retu
On Mon, 1 Apr 2002, Henri Yandell wrote:
> > Okay, I looked at the JDBC driver's code. It returns a byte[] in cases
> > where the underlying object is java.sql.Types.LONGVARBINARY. For some
> > reason, then, it looks like MySQL is returning a LONGVARBINARY column for
> > the one you're labeling
On Mon, 1 Apr 2002, Shawn Bayern wrote:
> Okay, I looked at the JDBC driver's code. It returns a byte[] in cases
> where the underlying object is java.sql.Types.LONGVARBINARY. For some
> reason, then, it looks like MySQL is returning a LONGVARBINARY column for
> the one you're labeling "Date"
-2.0.11-bin.jar which can be downloaded from
> http://prdownloads.sourceforge.net/mmmysql/mm.mysql-2.0.11-you-must-unjar-me
> .jar
>
> Regards.
>
> -Original Message-
> From: Shawn Bayern [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 01, 2002 12:09 PM
> To: Tag Lib
01, 2002 12:09 PM
To: Tag Libraries Users List
Subject: Re: JSTL Date Format Question
A variable that prints a string starting with "[B" is likely a primitive
byte array (byte[]). This means that the MYSQL JDBC driver you're using
is probably returning a byte[] for the column alia
A variable that prints a string starting with "[B" is likely a primitive
byte array (byte[]). This means that the MYSQL JDBC driver you're using
is probably returning a byte[] for the column aliased "Date" when it's
retrieved using ResultSet.getObject(). You could add
to the loop just to be
I have a query that selects records from a datetime column using the JSTL
and MYSQL. When I output the rows to a JSP page I'm getting the following:
Anderau, Eoma BASEL [B@b6421
Andersson, Lisa BASEL [B@5acb2b
[B@5092c0
