Let's try this again since the code wasn't uploaded the
last time I tried this. The following is an abbreviated
code snippet that I am using to test entering data into a
character field and retrieving through a search on that
character field. The table "test" has one column "test1"
defined as char
I am using this with python 2.2.1 and Firebird release
-- beginning code snippet--
con = kinterbasdb.connect
cur = con.cursor()
foo = ["foo"]
cur.execute("insert into test (test1) values (?)", foo)
cur.execute("select * from test where test1 = 'foo'")
#this searches for a record entered through ibconsole
cur.execute("select * from test where test1 = 'bar'")
--end code snippet--
Running the script produces the following results:
Basically, I am unable to use the expression "select ...
where field = ' text' " on data entered using kinterbasdb.
I can use "select... where field like 'text%'" but this has
Log in to post a comment.