response.write 1

[crmpicco]

How do i response.write this out?

Set rsFare = con.Execute("select * from net_fares where (arr LIKE ('%" & UCase(ariapt1) & "%')) and (dep LIKE ('%" & UCase(depapt1) & "%')) AND cabin='"& cabinclass & "' and company_id = '"& trim(session("agencyid"))&"' ORDER BY 1fare1234 ASC")

 

[FesterSXS]

I assume you just mean the SQL.

strSQL = "select * from net_fares where (arr LIKE ('%" & UCase(ariapt1) & "%')) and (dep LIKE ('%" & UCase(depapt1) & "%')) AND cabin='"& cabinclass & "' and company_id = '"& trim(session("agencyid"))&"' ORDER BY 1fare1234 ASC"

Response.Write strSQL

Set rsFare = con.Execute(strSQL)

Tony
________________________________________________________________________________

http://www.SpiraxSarco.com