©Mike Moxcey 1999

Modify SQL with Passed in Parameters

Now just insert the new variable in your SQL code:
@sql_show = <<ENDOFSQL;
select '<tr><td>', seq,
'</td><td>', priority, '</td><td>', open_date,
'</td><td>', to_char(open_date,'HH:MI PM'),
'</td><td>', name,'</td><td>', email,
'</td><td>',substr(problem,1,30),'</td></tr>
from oratut.calls $get_call;
ENDOFSQL


home next