Thread: Fix getXXX methods when used with CHAR columns or columns with decimals

Problem:
 - Error parsing input in getByte() and getShort() if input has a decimal or whitespace (from CHAR columns)
 - Error parsing CHAR columns in other getXXX methods.

Fix:
 - Added trim() to getXXX methods
 - In getByte() and getShort(), check the field type and take out the decimal and everything after it. Also check for
CHARand trim if necessary. 

Cheers,

Kim



Attachment

Re: Fix getXXX methods when used with CHAR columns or

From
Dave Cramer
Date:
patch applied,

Thanks,

Dave
On Wed, 2003-06-18 at 13:44, Kim Ho wrote:
> Problem:
>  - Error parsing input in getByte() and getShort() if input has a decimal or whitespace (from CHAR columns)
>  - Error parsing CHAR columns in other getXXX methods.
>
> Fix:
>  - Added trim() to getXXX methods
>  - In getByte() and getShort(), check the field type and take out the decimal and everything after it. Also check for
CHARand trim if necessary. 
>
> Cheers,
>
> Kim
>
>
>
> ______________________________________________________________________
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Dave Cramer <Dave@micro-automation.net>