<%
set rscrm = con.execute("select * from trip_details where trip_id = 'MK/"&rs("A1_pnr")&"' order by tatoo asc")
while not rscrm.eof
var_dep = rscrm("dep_airport")
var_arr = rscrm("arr_airport")
'var_arr = var_arr+var_arr
crm_iti = var_dep&"-"&var_arr
response.write "departure airport = " & var_dep & "<br>"
response.write "arrival airport = " & var_arr & "<br>"
rscrm.movenext
wend
%>
how can i select the FIRST instance of the var_dep and all FOUR instances of var_arr and out them into a variable?
www.crmpicco.co.uk
loop
