From 731f2e7c2fc1af4060b97656f2637fab05b0ebe2 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 11 May 2011 12:30:08 -0400 Subject: [PATCH] add a special startwith op for use with transformed values (cannot do it another way currently) --- Open-ILS/src/c-apps/oils_sql.c | 13 +++++++++++-- 1 file changed, 11 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/c-apps/oils_sql.c b/Open-ILS/src/c-apps/oils_sql.c index 3f8157db34..b79c5799a5 100644 --- a/Open-ILS/src/c-apps/oils_sql.c +++ b/Open-ILS/src/c-apps/oils_sql.c @@ -2765,16 +2765,25 @@ static char* searchFieldTransformPredicate( const ClassInfo* class_info, osrfHas right_parens = ")"; } + const char* right_percent = ""; + const char* real_op = op; + + if( !strcasecmp( op, "startwith") ) { + real_op = "like"; + right_percent = "|| '%'"; + } + growing_buffer* sql_buf = buffer_init( 32 ); buffer_fadd( sql_buf, - "%s%s %s %s %s %s%s", + "%s%s %s %s %s%s %s%s", left_parens, field_transform, - op, + real_op, left_parens, value, + right_percent, right_parens, right_parens ); -- 2.43.2