On 2010.05.04 11:21, Pam Wampler wrote:
> How do you add the % sign in a perl program, if you are doing an oracle
> query in the program?
>
> Example ....select date, name from my_table where name like upper(?)%
>
>
>
> The question mark would allow the user to enter the name - and I need to
> append the % sign so that oracle will know to do a like search.
What code do you have so far? Without any idea of what you've tried, my
first suggestion is to use DBIx::Class, and searches are clean and easy:
my $rs = $schema->resultset( 'Plans' )->search(
{ plan => { -like => "%$plan_name%" }},
{ plan_status => $status },
);
while ( my $record = $rs->next ) {
...show us what you have so far...
Steve
--
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
http://learn.perl.org/
