on 05-29-2013 8:33 AM
Hi All,
How to pass multiple or more than one values for [Param.1] in fixed query.
For exapmle, My query is like this,
In MII
SELECT * FROM Customers
WHERE City IN '[Param.1]'
In SQL
SELECT * FROM Customers
WHERE City IN ('Paris','London');
In SQL, the above mentioned query is working fine, but same is not working in MII. Please anyone let me know what I am missing ?
Regards,
Aravinth
I have tried like,
SELECT * FROM Customers
WHERE City IN ('[Param.1]')
and passed value as Paris','London Now it is working fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
6 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.