I want to make a case insensitive search page.
I want to do this by converting what the user types in the search page to uppercase
and also converting the dataobject to uppercase using the 'upper' command in SQL.
I use the following code to convert what the user types to uppercase.
[[SPIDER_EVENT<Search_onWebEvent>
public int Search_onWebEvent(CSpWebEvent event)
{ String upper =
getDisplayFieldValue( "TITLE").toString().toUpperCase();
setDisplayFieldValue( "TITLE",new CSpString( upper ) );
String upper1 =
getDisplayFieldValue( "COMMENTS").toString().toUpperCase();
setDisplayFieldValue( "COMMENTS",new CSpString( upper1 ) );
int command = doQBE();
if (command == PROCEED)
{
command = doAction(event);
}
return(command);
}
]]SPIDER_EVENT<Search_onWebEvent>
This works fine.
I also use the upper command in the dataobject but it doesn't seem to work until
after the search. (ie the Master Display page shows everything in uppercase
but
the serach doesn't work since the users search is uppercase and the
dataobject is
still mixed case). Is there anyway to force the dataobject to use the upper
command
before the search page is submitted?
_________________________________________________________________________
To unsubscribe from this mailing list please send an email to:
[EMAIL PROTECTED]
Please remember to use the same email address you subscribed with.
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
