ruby-oci8 question

[beny 18241]

Hi,


I have some problem, i want to make select query with $name variable but
i cant, this is my code please help what is wrong


print "Enter name :"
$name = STDIN.gets

conn = OCI8.new('user', 'pass')
num_rows = conn.exec("SELECT * FROM test where name like '%" + $name +
"%'")
do |r|
puts r.join(',')
end

 

[Patrick Okui]

Hi,


I have some problem, i want to make select query with $name variable
but
i cant, this is my code please help what is wrong


print "Enter name :"
$name = STDIN.gets

this $name has a '\n' in it, try STDIN.gets.chomp

 

[beny 18241]

this $name has a '\n' in it, try STDIN.gets.chomp

thanks works

 

[Patrick Okui]

thanks works

You're welcome. Also consider removing the '$' and using the variable
as just "name" just like conn and num_rows (I'm guessing you're from a
perl or php background).