In my .asp file I can display a value with the following code .....
<%Response.Write(session("uid"))%> (Displays Chris on the screen)
What I want to do now is amend my query to be something like this .....
fp_sQry="SELECT * FROM Teams WHERE (ManagerCode = " & Response.Write(session("uid"))
of course it doesn't work. It displays the text 'Chris' instead of including it in the search text.
What do I need to do to correct it?
Many Thanks, Chris.
<%Response.Write(session("uid"))%> (Displays Chris on the screen)
What I want to do now is amend my query to be something like this .....
fp_sQry="SELECT * FROM Teams WHERE (ManagerCode = " & Response.Write(session("uid"))
of course it doesn't work. It displays the text 'Chris' instead of including it in the search text.
What do I need to do to correct it?
Many Thanks, Chris.