Classic ASP Discussion - Type mismatch

Print Page | Close Window

Type mismatch

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=2913
Printed Date: 29 March 2026 at 12:01pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Type mismatch

Posted By: cuedog
Subject: Type mismatch
Date Posted: 21 May 2003 at 8:39am

I have converted my database from MS Access 2000 to MySQL. I am now getting a type mismatch error.

Here is the code

articleurl datatype is varchar(150) and articlehead datatype is varchar(100)

What could be the problem?

Replies:

Posted By: ljamal
Date Posted: 21 May 2003 at 11:26am

type mismatch suggests that you are trying to set something to a variable that is not of the same type.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: cuedog
Date Posted: 21 May 2003 at 11:51am

The thing is I am not trying to set the result to a variable. Maybe I should?

Posted By: MorningZ
Date Posted: 21 May 2003 at 1:09pm

Forgot something:

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: cuedog
Date Posted: 21 May 2003 at 2:19pm

Good eye, MorningZ! I did not copy and paste this code. I just wrote it in from my head. I'll check it soon and make sure things are written more carefully. Odd though, this error did not happen until now while changing databases.