Isalpha() not working on queried value

Archived Topics
1

I have a runQuery statement that returns a record from a database. When I try using the isalpha function on the result it always evaluates to 0. any ideas?

result = fpmi.db.runQuery("SELECT column FROM table WHERE ID = "  + strID)
strResult = result[0][0]
if(strResult.isalpha()):
    print "the value is letters"
else:
    print "the value is not letters"
2

I figured it out. the problem was the datatype of the column. the column was set to char(10) so the value had spaces on the end. I used the rstrip function to remove the trailing white space and now isalpha works.

3

This is my favorite kind of post :slight_smile: Glad you got it figured out.