Re: question about standard taglib sql

Steven F. Bell <sbell <at> frycomm.com> writes:

> 
> Hello,
> 
> I am using the standard taglib sql tag to query a database and large 
> text fields are coming back like:
> net.sourceforge.jtds.jdbc.ClobImpl <at> 94aa42
> 
> What could be causing this, and is there any means to correct it, and 
> get the proper text back?
> 
> Also, the results in the tag are alphabetical a-z, can this order be 
> changed around to match the field order in the database?
> 

Hi,

I had the same problem because i used the datatype ntext of text of a sql server
database. 

Using varchar instead of text resolved my problem.

Hope this helps,
Jerry