Cast Postgresql Problem

[Frank Lupo]

=============================================================
CURRENT
=============================================================
   public String getConvertPhrase(DataType destType, DataType srcType, Object 
format)
   {
       switch(destType)
       {
          case BOOL:      return "CAST(? AS UNSIGNED)";
          case INTEGER:   return "CAST(? AS SIGNED)";
          case DECIMAL:   return "CAST(? AS DECIMAL)";
          case DOUBLE:    return "CAST(? AS DECIMAL)";
          case DATE:      return "CAST(? AS DATE)";
          case DATETIME:  return "CAST(? AS DATETIME)";

=============================================================
FIX
=============================================================

   public String getConvertPhrase(DataType destType, DataType srcType, Object 
format)
   {
       switch(destType)
       {
->           case BOOL:      return "CAST(? AS BOOL)";
->           case INTEGER:   return "CAST(? AS INTEGER)";
          case DECIMAL:   return "CAST(? AS DECIMAL)";
          case DOUBLE:    return "CAST(? AS DECIMAL)";
          case DATE:      return "CAST(? AS DATE)";
->           case DATETIME:  return "CAST(? AS TIMESTAMP)";




--
Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP 
autenticato? GRATIS solo con Email.it http://www.email.it/f

Sponsor:
250 Biglietti da Visita gratuiti + 1 elegante Porta biglietti metallico! Spese 
di spedizione escluse. Offerta limitata, fai in fretta!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8958&d=2-7