Forum

HomeHomeCoreCoreGeneralGeneralAgain Nested IIFAgain Nested IIF
Previous
 
Next
New Post
8/9/2012 2:35 AM
 

I tested the code of mfnc and it was nearly perfect.

 

From a syntax perpective, it's perfect but when tested it, the code return a error because " character is inserted in the string (see it below).

 

...
FROM [SK_CRM_vw_CustomersList]
" WHERE (Username LIKE '%d3%'
 OR Company LIKE '%d3%'
 ...

 

Then I deleted the \" of the code of mfnc and it works! From a syntax perspective, it's strange but it correct the problem.

 

...

{IIF,"'[mSearch,Form]'=''","","\{IIF,\"'\[chkUserID,Form]'='1'\",\" WHERE UserID= @mSearch\",\" WHERE (Username LIKE '%@mSearch%'

...

 

Thanks for all your answers... I'm now convincing that nested IIF works but definitively not obvious :-)

 

Dom

Previous
 
Next
HomeHomeCoreCoreGeneralGeneralAgain Nested IIFAgain Nested IIF


 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seattle, WA • info@openwebstudio.com

Bookmark & Share Bookmark and Share