©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