checking against a session variable

<i><b>Originally posted by : Simon (simonhewitt2000@hotmail.com)</b></i><br />what is the correct syntax to check against a session variable.<br /><br />my sql looks like this:-<br />mySQL="select distinct customercode from publications where accountno = 17100"<br /><br />I need to change this too, where accountno = session("accountno").<br /><br />but nothing seems to work, what is the correct syntax for the quotes ect.?<br /><br />Ta.<br />Simon<br /><br />

<i><b>Originally posted by : Jignesh (codehunt@yahoo.com)</b></i><br /><%<br />mySQL="select distinct customercode from publications where accountno = " &session("accountno")<br />%><br /><br />will work fine if session variable does not contain blanks. <br /><br /><br />