Database Discussion - Data type mismatch in criteria expression

Print Page | Close Window

Data type mismatch in criteria expression

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4043
Printed Date: 29 March 2026 at 10:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Data type mismatch in criteria expression

Posted By: smith_martin
Subject: Data type mismatch in criteria expression
Date Posted: 03 July 2003 at 12:43pm

here's the error:

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

here's the code:

Dim strConn ' Database connection string
Dim SQL ' String that will have our SQL statments

' Time to create and open recordset
Set RS = Server.CreateObject("ADODB.Recordset")
RS.CursorLocation = 3 ' adUseClient
RS.Open SQL, strConn ' adOpenKeyset CursorType

error is reported on that last line of code. Any ideas / help? Thanks.

-------------
--
martin smith
http://students.mwc.edu/~msmit8iu/webdev/index.html

Replies:

Posted By: Bunce
Date Posted: 03 July 2003 at 12:51pm

Depends whats in the variable SQL, which you didn't post.

-------------
There have been many, many posts made throughout the world...
This was one of them.