I would like to create a session variable and store it in a table. I created a sqlmethod as follows: id: active_sessions arguments: sessionid select * from session where <!--#sqltest sessionid column=sessid type=string--> which works fine when tested. I have called it like this: <!--#if "REQUEST.cookies.has_key('CK_Session')"--> Your sessionid is <!--#var CK_Session--><br> <!--#else--> No sessionid <!--#/if--><br> <!-- this confirms that the CK_Session variable is available--> <!--#in expr="active_sessions(sessionid=CK_Session)"--> <!--#if sequence-start--> Yes, this session id is logged<br> <!--#else--> Need to add this session id<br> <!--#/if--> <!--#/in--> but nothing gets printed between the #in #/in tags. ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz