You are viewing limited content. For full access, please sign in.

Question

Version 9 Workflow Search and Retrieval

Updated September 5, 2014

asked on September 5, 2014

Hello,

I am running into a problem with an existing Workflow Custom ODBC Query to a MySQL Database, namely when I replace:

SELECT * from View WHERE Date = "2014-09-05"

by:

SELECT * from View WHERE Date = @Param

Specifically, the second query always returns 0 row when @Param is assigned 2014-09-05, whereas the first query works fine.

Any hint?

note: similar @Param query works fine with an ODBC connection to a Microsoft SQL database

0 0

Answer

SELECTED ANSWER

replied on September 5, 2014 • Show version history

I believe the problem is with your named parameter.

A direct ODBC command for MySQL does not accept named parameters, but instead just takes a "?"

SELECT * from View WHERE Date = ?

1 0