©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