©Mike Moxcey 1999
Claim Success SQL stmt
- @sql_show = <<ENDOFSQL;
- select '<h3>ID Nr:<em>', seq,
- '</em></h3> Priority:<em>', priority,
- '</em> Date:<em>', open_date,
- '</em> Time:<em>', to_char(open_date,'HH:MI PM'),
- '</em><blockquote><p>User:<em>', name,
- '</em><br>Email:<em>', email,
- '</em></blockquote><p>', problem from oratut.calls
where seq=(select max(seq) from oratut.calls);
- ENDOFSQL
home
next