close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Link to Detail Page returns error

Thread began 1/28/2010 5:43 pm by shesters381675 | Last modified 2/02/2010 6:35 pm by Eric Mittman | 958 views | 6 replies |

shesters381675

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!

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

shesters381675

Still Nothing

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?

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

shesters381675

Code from Details page 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).

Sign in to reply to this post

shesters381675

Url

Thanks for your assistance.

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...