what's wrong with this code...

iam creating sql*plus script to generate html report... everything works fine.. the code has problem only when i try to create a tooltip for the href.

set feedback off
set verify off
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD "<TITLE>Department Report</TITLE> -
<STYLE type='text/css'> -
<!-- BODY {background: #FFFFC6} --> -
</STYLE>" -
BODY "TEXT='#FF00Ff'" -
TABLE "WIDTH='90%' BORDER='5'"
COLUMN firstname HEADING 'FIRST_NAME' ENTMAP OFF
COLUMN lastname HEADING 'LAST_NAME'
spool c:\output\my_first.html
SELECT '<A HREF="..\popupbasic.html" onmouseover="return escape('Some text')">'||FIRSTNAME||'</A>' FIRSTNAME, lastname from suntemp;
spool off

pls help me!!

sundar

SELECT '<A HREF="..\popupbasic.html" onmouseover="return escape('Some text')">'||FIRSTNAME||'</A>'

This is possibily where your problem lies......

you have correctly concatonated FIRSTNAME into the text string, but failed to do the same for 'Some text' (and possibiliy any other quote not show here.

replace all quotes that appear inside the text quotes with two quotes...(make sense?)

e.g. SELECT 'select ''hello mum'' from dual;' FROM dual;
i.e. escape(''Some text'')">'||FIRSTNAME||'</A>