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

Started by Kim Hoabout 23 years ago2 messagespatches
Jump to latest
#1Kim Ho
kho@redhat.com

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 CHAR and trim if necessary.

Cheers,

Kim

Attachments:

fixgetXXXmethods.difftext/plain; charset=UTF-8; name=fixgetXXXmethods.diffDownload+34-0
#2Dave Cramer
pg@fastcrypt.com
In reply to: Kim Ho (#1)
Re: Fix getXXX methods when used with CHAR columns or

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 CHAR and trim if necessary.

Cheers,

Kim

______________________________________________________________________

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

--
Dave Cramer <Dave@micro-automation.net>