MollyPages.org
"You were wrong case. To live here is to live." |
Pages /
Database /
Forms /
Servlet /
Javadocs
/
License & Download /
Tutorials /
Cookbook
/
Contact & Hire
|
root@turing:/examples/dbo# java examples.dbo.Test -conf postgres.cnf -test examples.dbo.Getwhere -where "lower(name) like '%kolo%'" INFO New log level set to: LogLevel [3,INFO] INFO fc.util.FilePropertyMgrLoaded properties from file: postgres.cnf >>> Retrieved 1 rows [Class Name: [mollytest] [isDiscarded=false] [isNew=false] [isModified=false] Note: IsNullInDB only meaningful for existing rows (i.e., isNew=false) PK FK Field Value isModified isNullinDB isSerial/AutoInc x - uid 1 - - x - - name Molly Kolodny - - - - - email mol@holografix.net - - - - - password blue9 - - - - - created_on 2007-04-10 - - - - - is_active true - - - ] JVM shutdown: fc.io.Log - closing all logs... test=# select * from mollytest where lower(name) like '%kolo%'; uid | name | email | password | created_on | is_active -----+---------------+--------------------+----------+------------+----------- 1 | Molly Kolodny | mol@holografix.net | blue9 | 2007-04-10 | t (1 row)
root@turing:/examples/dbo# java examples.dbo.Test -conf mysql.cnf -test examples.dbo.Getwhere -where "lower(name) like '%kolo%'" INFO New log level set to: LogLevel [3,INFO] INFO fc.util.FilePropertyMgrLoaded properties from file: mysql.cnf >>> Retrieved 1 rows [Class Name: [mollytest] [isDiscarded=false] [isNew=false] [isModified=false] Note: IsNullInDB only meaningful for existing rows (i.e., isNew=false) PK FK Field Value isModified isNullinDB isSerial/AutoInc x - uid 1 - - x - - name Molly Kolodny - - - - - email mol@holografix.net - - - - - password blue9 - - - - - created_on 2007-04-08 - - - - - is_active true - - - ] JVM shutdown: fc.io.Log - closing all logs... mysql> select * from mollytest where lower(name) like '%kolo%'; +-----+---------------+--------------------+----------+------------+-----------+ | uid | name | email | password | created_on | is_active | +-----+---------------+--------------------+----------+------------+-----------+ | 1 | Molly Kolodny | mol@holografix.net | blue9 | 2007-04-08 | 1 | +-----+---------------+--------------------+----------+------------+-----------+ 1 row in set (0.00 sec)