How can use following query in ASP ?
This query run properly on sql query analyzer but When I use this query on asp it give following error.

Error Type:
Microsoft VBScript compilation (0x800A0409)
Unterminated string constant
/mtp/xl_data2a.asp, line 80, column 57
ssql="select fromnode,tonode,volume,IP,fromnode2,tonode2,
--------------------------------------------------------^

Query is:

ssql="select fromnode,tonode,volume,IP,fromnode2,tonode2, // line 80
case BOND when 'SBU' then 'SBU' else Null end as SBU,
case BOND when 'IP-1' then 'IP-1' else Null end as [IP-1],
case BOND when 'EXITSOUTHBOND' then 'EXITSOUTHBOND'
else Null end
from
(select fromnode,tonode,volume,substring(fromnode,3,2) IP,
fromnode % 10 fromnode2, tonode % 10 tonode2,
case
when FromNode%10=1 and ToNode%10=2 then 'SBU'
when substring(fromnode,3,2)=01 then 'IP-1'
when FromNode%10=7 then 'Eastbound in Excluding Right'
end BOND
from emme) emme2
ORDER BY IP"

set rs=cn.Execute(ssql)


Datatype is varchar

Mateen

You need to have all of the sql-string on one line - is that the case?

The unterminated-error means that it can't find the closing quote, so I guess you have some line breaks - right?

thanks.

Put all code in one line

What is

// line 80
 doing in there anyway?



Sal