PM
To: Pam Wampler
Cc: beginners@perl.org
Subject: Re: how to denote the like symbol % in perl program
On 2010.05.04 12:11, Pam Wampler wrote:
> Here's the code -- I'm just learning perl so any help is greatly
> appreciated
>
> It will work if I have the user input someth
On 2010.05.04 12:11, Pam Wampler wrote:
> Here's the code -- I'm just learning perl so any help is greatly
> appreciated
>
> It will work if I have the user input something like pam% with the
> percent sign...but I really just want the user to have to enter pam and
> have the program append the %p
quot;;
}
if ($sth->rows == 0) {
print "No names matched $name',\n\n";
}
$sth->finish;
print "\n";
print "Enter name> ";
}
$dbh->disconnect;
$rv = $sqlQuery->execute
or die "can't execute the query: $sqlQuery->errstr";
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
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