Link to Detail Page returns error

I have created a set of search pages using the wizard. I am able to search and see results. When I click on the link to the detail page it returns this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/Communities_Detail.asp, line 37


The code from line 37 (and 38) in the detail page is as follows:
Set WADACommunities = WADACommunities_cmd.Execute
WADACommunities_numRows = 0

Tried searching online and have not found much help. Any ideas??
Thanks!

This usually happens when you have the data type specified one way in the query and another in the DataAssist Search server behavior. For example, if you are searching in a date type column with a string value you might get this error. You should check the recordset on the page and the DataAssist Search server behavior to make sure that your data types match up.

I have gone over the data types, in the database, and server behavior. The item being linked is Wchar and in the db it's text. This shouldn't be a problem (right ?). That is the item being linked. Just in Case I coverted some boolean data to text. Still same problem. Search works, but the link on the results page will not go to the detail page? I think I must be missing something?

How do you have the query setup on the details page? It might be that the URL parameter that you are filtering the recordset on is the mismatch that is occurring. If you can post back with your recordset code on this page so we can take a look at it. You may need to cast a value before it is referenced in the query. Also make sure to include the datatypes for any of the specific columns referenced in the query.

<%
Dim WADACommunities__ParamSessionCom_Name
WADACommunities__ParamSessionCom_Name = "-1"
If (Session("WADA_Insert_Communities") <> "") Then
WADACommunities__ParamSessionCom_Name = Session("WADA_Insert_Communities")
End If
%>
<%
Dim WADACommunities__ParamCom_Name2
WADACommunities__ParamCom_Name2 = "-1"
If (Request.QueryString("Com_Name") <> "") Then
WADACommunities__ParamCom_Name2 = Request.QueryString("Com_Name")
End If
%>
<%
Dim WADACommunities__ParamCom_Name
WADACommunities__ParamCom_Name = "-1"
If (Request.QueryString("Com_Name") <> "") Then
WADACommunities__ParamCom_Name = Request.QueryString("Com_Name")
End If
%>
<%
Dim WADACommunities
Dim WADACommunities_cmd
Dim WADACommunities_numRows

Set WADACommunities_cmd = Server.CreateObject ("ADODB.Command")
WADACommunities_cmd.ActiveConnection = MM_AlabaAdv_STRING
WADACommunities_cmd.CommandText = "SELECT Com_Name, Com_Link, Com_Link2, Com_Link3, Contact_Name_First, Contact_Name_Last, Contact_Address, Contact_Phone, Contact_Email, Contact_Website, City_Population, County_Name, County_Population, Commercial_Airport, Regional_Airport, Public_Water, Public_Sewer, Garbage_Pickups, No_Physicians, Phys_city, Phys_county, Hosp_Beds_City, Hosp_Beds_County, Nursing_Homes, Assited_Liv, Regional_Health_Care, RHC_Distance, Military_Posts, Military_Distance, Worship_Place, Worship_Denom, Post_Secondary_1, Post_Secondary_2, Post_Secondary_3, Pubilc_Library FROM Communities WHERE Com_Name = ? OR ( -1=? AND Com_Name=?)"
WADACommunities_cmd.Prepared = true
WADACommunities_cmd.Parameters.Append WADACommunities_cmd.CreateParameter("param1", 203, 1, 255, WADACommunities__ParamCom_Name) ' adLongVarWChar
WADACommunities_cmd.Parameters.Append WADACommunities_cmd.CreateParameter("param2", 203, 1, 255, WADACommunities__ParamCom_Name2) ' adLongVarWChar
WADACommunities_cmd.Parameters.Append WADACommunities_cmd.CreateParameter("param3", 203, 1, 255, WADACommunities__ParamSessionCom_Name) ' adLongVarWChar

Set WADACommunities = WADACommunities_cmd.Execute
WADACommunities_numRows = 0
%>

All of the fields are text except the population fields, distance, and Number fields (like No_Physcians).

Thanks for your assistance.

I have opened a ticket for you on this issue so we can exchange some files in private. To update the ticket login to WebAssist.com and visit your support history.