This topic is locked

Data type mismatch in criteria expression.

3/5/2008 9:32:51 AM
ASPRunnerPro General questions
D
dunga author

Error Type:

Microsoft JET Database Engine (0x80040E07)

Data type mismatch in criteria expression.

/MTOC1/include/commonfunctions.asp, line 659
guys what can be the source of this?????
previously everything worked, but with this 393 build problems are on the rise.

D
dunga author 3/5/2008

the problem arises when I try to use LInked field.
here what the problem is:
I have a database which is setup as follows:

Id autonumber

Link - text

description
In visual editor if I use: please pay attention:
view as : Hyperlink, display word(i.e Link)

and

on add page

I will use

Link field as TEXT area, i will get the above error.
but in 5.1 I have NO problems.
can someone please help.???

D
dunga author 3/5/2008

done:)
list page
link field set up as a hyperlink

display wor(i.e.Link)
add/edit page in the Edit as dialog set ups as MEMO

250/500
(mind you my field in access is set as a memo(and that was the problem) my links are very long longer than 255 characters, and I needed 500 or more.