empire-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Frank Lupo <frank_l...@email.it>
Subject Cast Postgresql Problem
Date Thu, 02 Jul 2009 15:47:10 GMT
=============================================================
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

Mime
View raw message