Using groovy how do i pass parameters to the sql statement?

[Robert Walton]

I am writing a groovy script to read a database table and am having trouble with the sql statement. I need to pass it two parameters but it seems i can not get the syntax correct.

ex: def sSql = "select field from table where Segment = $sSegment and Service = $sService"

Would someone be able to show me the correct syntax to pass a parameter to the sql statement?

[Didem K]

import groovy.sql.Sql

def segment

def service

def resuslt = sql.rows("select field from table  t where t.segment=? and t.service=?" ,segment, service);