Syntax of a Query Question

C

chrispl

In my .asp file I can display a value with the following code .....

<%Response.Write(session("uid"))%> (Displays Chris on th
screen)

What I want to do now is amend my query to be something like thi
.....

fp_sQry="SELECT * FROM Teams WHERE (ManagerCode = "
Response.Write(session("uid"))

of course it doesn't work. It displays the text 'Chris' instead o
including it in the search text.

What do I need to do to correct it?

Many Thanks, Chris
 
T

Thomas A. Rowe

Try:


fp_sQry="SELECT * FROM Teams WHERE (ManagerCode = " & session("uid")

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
T

Thomas A. Rowe

Correction: Remove the ( from before ManagerCode

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Thomas A. Rowe said:
Try:


fp_sQry="SELECT * FROM Teams WHERE (ManagerCode = " & session("uid")

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
Click to expand...
 
S

Stefan B Rusynko

And the session variable may require delimiters (')
fp_sQry="SELECT * FROM Teams WHERE ManagerCode = '" & session("uid") & "' "




| Correction: Remove the ( from before ManagerCode
|
| --
| ==============================================
| Thomas A. Rowe (Microsoft MVP - FrontPage)
| ==============================================
| If you feel your current issue is a results of installing
| a Service Pack or security update, please contact
| Microsoft Product Support Services:
| http://support.microsoft.com
| If the problem can be shown to have been caused by a
| security update, then there is usually no charge for the call.
| ==============================================
|
| > Try:
| >
| >
| > fp_sQry="SELECT * FROM Teams WHERE (ManagerCode = " & session("uid")
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > If you feel your current issue is a results of installing
| > a Service Pack or security update, please contact
| > Microsoft Product Support Services:
| > http://support.microsoft.com
| > If the problem can be shown to have been caused by a
| > security update, then there is usually no charge for the call.
| > ==============================================
| >
| >>
| >> 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.
| >>
| >>
| >> --
| >> chrisplPosted from http://www.pcreview.co.uk/ newsgroup access
| >>
| >
| >
|
|
 
Top