This topic is locked
[SOLVED]

  Error on Advanced Search and Multiline Dropdown box

8/16/2012 2:10:59 AM
ASPRunnerPro General questions
S
solosoftware author

Hello ASPRunnet team,
If you define in your Advanced Search that the field (the field is of the Lookup wizard type) is multiline (ie. 10 lines) the bellow error in red happens.

If you put just 1 line on Multiline, then the search is performed correctly.
Is there a fix or workaround on this?


Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/webserverpage/include/aspfunctions.asp, line 1242


This is the function that has the error.
function db_query(sSQL,conn)

dim asp_rs

if IsIdentical(dDebug,true) then response.write sSQL & "
"

Set asp_rs = server.CreateObject("ADODB.Recordset")

asp_rs.Open sSQL,conn

call ReportError

set db_query=asp_rs

end function

Sergey Kornilov admin 8/16/2012

Post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.

S
solosoftware author 8/21/2012

When the Multiline option is more than one line (ie. 10 lines) the software automatically changes the selection (from Equal to Contains).
This is by design. So you have to go with one line to avoid the error.