I've got an issue with either rose or DBI. I can't track down where its at.
I'm trying to search on text field ( actually an RSA public key,) and can't get rose to handle it. i think it might be a newline issue? i can do searches fine in raw sql ( see below ) using the same code that manager is creating (also below) i think it must have something to do with newlines and the bind. has anyone run into anything similar before? ---- sample rose SELECT "id", "is_active", "keytype_id", "name", "private_key", "private_key_is_user_managed", "public_key", "timestamp_created", "timestamp_inactive", "useraccount_id" FROM "useraccount_keyinfo" WHERE "public_key" ILIKE ? AND "useraccount_id" = ? (-----BEGIN RSA PUBLIC KEY----- MIGJAoGBAMOSuERR3M7vbIC7vVVpazX3M5xZabh7VbB+mPDWuC7vfxZ+bU1nq1hl TIpWydnSPxV2wCwaqX0YlmeWWqgd+wh6ytmibDC508XFt/urpL7zHYaosFD3rK11 ijZloQatYPmuK4PfA8wPNkMD5T0QJLwWDSFUNpoTYEo19q40VwvJAgMBAAE= -----END RSA PUBLIC KEY-----%, 129) ---- raw sql SELECT "id", "is_active", "keytype_id", "name", "private_key", "private_key_is_user_managed", "public_key", "timestamp_created", "timestamp_inactive", "useraccount_id" FROM "useraccount_keyinfo" WHERE "public_key" ILIKE '-----BEGIN RSA PUBLIC KEY----- MIGJAoGBAMOSuERR3M7vbIC7vVVpazX3M5xZabh7VbB+mPDWuC7vfxZ+bU1nq1hl TIpWydnSPxV2wCwaqX0YlmeWWqgd+wh6ytmibDC508XFt/urpL7zHYaosFD3rK11 ijZloQatYPmuK4PfA8wPNkMD5T0QJLwWDSFUNpoTYEo19q40VwvJAgMBAAE= -----END RSA PUBLIC KEY-----%' AND "useraccount_id" = 129; SELECT "id", "is_active", "keytype_id", "name", "private_key", "private_key_is_user_managed", "public_key", "timestamp_created", "timestamp_inactive", "useraccount_id" FROM "useraccount_keyinfo" WHERE "public_key" = '-----BEGIN RSA PUBLIC KEY----- MIGJAoGBAMOSuERR3M7vbIC7vVVpazX3M5xZabh7VbB+mPDWuC7vfxZ+bU1nq1hl TIpWydnSPxV2wCwaqX0YlmeWWqgd+wh6ytmibDC508XFt/urpL7zHYaosFD3rK11 ijZloQatYPmuK4PfA8wPNkMD5T0QJLwWDSFUNpoTYEo19q40VwvJAgMBAAE= -----END RSA PUBLIC KEY----- ' AND "useraccount_id" = 129; ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Rose-db-object mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/rose-db-object
