Thank you for your fast response. I tried this but produces no record: my $qual1 = "'536870914' LIKE \"%-N-%\""; my $qual2 = ars_LoadQualifier( $ctrl, $User_schema, $qual1 ) || die $arr_errstr; my @entries = ars_GetListEntry($ctrl, $User_schema, $qual2,0,0) || die $arr_errstr; Can you find out some thing is missing from my coding? But it works fine on the online form for advanced search. Also, where I can find the next generated number for the form key? Chinh.
--- On Thu, 7/8/10, Thilo Stapff <thilo.sta...@apprologic.de> wrote: From: Thilo Stapff <thilo.sta...@apprologic.de> Subject: Re: [Arsperl-users] Need Help: Qualification String "LIKE" To: "ARSperl User Discussion" <arsperl-users@arsperl.org> Date: Thursday, July 8, 2010, 10:19 AM Use the field ID instead of "User Ident", e.g. '536870912' LIKE "%-N-%" Regards, Thilo Stapff On 08.07.2010 17:05, Chinh Do wrote: > I need to search all fields that have this string "-N-" in the middle, > for examples, "123-N-abc" and "4759ABC-N-Bill". Using Oracle SQL, I can > code "...fieldname LIKE '%-N-%' ". I tried "my $qual1 = "'User Ident' > LIKE \"%-N-%\"" but it does not work. > How do I code the qualification string using ARSPerl to get the same > result as using "LIKE"? > Thank you, > Chinh. > > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > > > > > > -- > Arsperl-users mailing list > Arsperl-users@arsperl.org > https://lists.sourceforge.net/lists/listinfo/arsperl-users ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first -- Arsperl-users mailing list Arsperl-users@arsperl.org https://lists.sourceforge.net/lists/listinfo/arsperl-users
------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
-- Arsperl-users mailing list Arsperl-users@arsperl.org https://lists.sourceforge.net/lists/listinfo/arsperl-users