RE: how to denote the like symbol % in perl program

2010-05-04 Thread Pam Wampler
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

Re: how to denote the like symbol % in perl program

2010-05-04 Thread Steve Bertrand
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

RE: how to denote the like symbol % in perl program

2010-05-04 Thread Pam Wampler
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";

Re: how to denote the like symbol % in perl program

2010-05-04 Thread Steve Bertrand
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 to denote the like symbol % in perl program

2010-05-04 Thread Pam Wampler
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