The following code writes to a table called "trips".
It writes the SeatID variable to the "seat" field.
This all works fine.
What I need to do is take the Blue part and make that into a session where it is red right now. All code here works except for the red part - that is the part I need to add.
I know the red part is incorrect but I am stumped. This is just an example to try to explain what I need.
Any ideas? Still new at ASP and definitely new at trying to make session variables

squery = " update trips set Seat" & Session("Seatid") & "='" &
rs.fields("paxid").value & "' where TripID =" & Session("tripid")
conn.execute squery
session("paxID" & Session("Seatid") & ")= & rs.fields("paxid").value &Response.Redirect "fourth.asp"