keep getting error 80040e07

[caiquemom]

I can't seem to figure out what I am doing wrong. I keep getting the error message

"Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/leghistres1.asp, line 48"

The query I am using is:

SELECT DISTINCTROW publicact1999.PublicAct, publicact1999.Bill, [99HTRIN].[House Pages], [99seni].[Senate Pages], combo.[Page Numbers], publicact1999.Bill FROM ((publicact1999 LEFT JOIN 99HTRIN ON publicact1999.Bill = [99HTRIN].Bill) LEFT JOIN 99seni ON [99HTRIN].Bill = [99seni].Bill) LEFT JOIN combo ON [99seni].Bill = combo.Bill WHERE ('searchpa'='" & Request.QueryString("[by]&quot & "') AND (publicact1999.PublicAct='" & Request.QueryString("[search]&quot & "') OR ('searchbill'='" & Request.QueryString("[by]&quot & "') AND (publicact1999.Bill='" & Request.QueryString("[search]&quot & "')"


I think that the problem problem is in the AND (publicact1999.Bill='" & Request.QueryString("[search]&quot & "').

The actual search page is at:

http://www.cslib.org/leghist.asp

Anyone have any idea?

Chris

 

[tlbroadbent]

If the query you posted is the actual query being sent to SQL Server, the problem is that SQL Server has no way to interpret the value of Request.QueryString("[by]&quot and Request.QueryString("[search]&quot. Those value must be resolved on your page before executing the query. Terry

X-) "Life would be easier if I had the source code." -Anonymous