Help with form results in query

[Ken]

How can I get this line to work? I am trying to get the results entered in a
form to be part of my query. I am able to get the form results but I get a
error stating Syntax error (missing operator) in query expression 'Assignee
= Tom Jones'.
Below is the line where the error occurs

Session("dbWhere") = "Assignee = " & Request.Form("assignsearch")

Thanks
Ken

[Tom Kaminski [MVP]]

"Ken" <kl*****@spamfreeingr.com> wrote in message
news:uT**************@TK2MSFTNGP10.phx.gbl...

How can I get this line to work? I am trying to get the results entered in a form to be part of my query. I am able to get the form results but I get a
error stating Syntax error (missing operator) in query expression 'Assignee = Tom Jones'.
Below is the line where the error occurs

Session("dbWhere") = "Assignee = " & Request.Form("assignsearch")

Session("dbWhere") = "Assignee = '" & Request.Form("assignsearch") & "'"

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

[Ken]

Now this is giving me problems. Is this the correct way ?
Session("dbWhere") = "Assignee = '" & Request.Form("assignsearch") & "'" or
"Add_Assignees = '" & Request.Form("assignsearch") & "'"
"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:bl**********@kcweb01.netnews.att.com...

"Ken" <kl*****@spamfreeingr.com> wrote in message
news:uT**************@TK2MSFTNGP10.phx.gbl...

How can I get this line to work? I am trying to get the results entered in

a

form to be part of my query. I am able to get the form results but I get

a error stating Syntax error (missing operator) in query expression

'Assignee

= Tom Jones'.
Below is the line where the error occurs

Session("dbWhere") = "Assignee = " & Request.Form("assignsearch")

Session("dbWhere") = "Assignee = '" & Request.Form("assignsearch") & "'"

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running

IIS http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

[Phillip Windell]

You can't use an "or" like that. You can't assign a value to a
Session variable with an "or". You can use an
"if...or...then...else" when testing for a current value, but you
haven't made it clear what you are trying to do. Let use know what you
are *really* trying to do,...you may have to change your whole
approach.

--

Phillip Windell [CCNA, MVP, MCP]
pw******@wandtv.com
WAND-TV (ABC Affiliate)
www.wandtv.com

"Ken" <kl*****@spamfreeingr.com> wrote in message
news:ud**************@TK2MSFTNGP09.phx.gbl...

Now this is giving me problems. Is this the correct way ?
Session("dbWhere") = "Assignee = '" & Request.Form("assignsearch") & "'" or "Add_Assignees = '" & Request.Form("assignsearch") & "'"

[Bob Barrows]

Ken wrote:

How can I get this line to work? I am trying to get the results
entered in a form to be part of my query. I am able to get the form
results but I get a error stating Syntax error (missing operator) in
query expression 'Assignee = Tom Jones'.
Below is the line where the error occurs

Session("dbWhere") = "Assignee = " & Request.Form("assignsearch")

Whenever you have this type of error, use response.write to see the results
of your concatenation. You have no hope of troubleshooting this just by
looking at the code. You need to see the result.

Bob Barrows