Skip to Content
0
Former Member
Apr 22, 2014 at 11:34 AM

How to write XSJS Select Query with input parameters

230 Views

Hello Experts,

I am creating a xsjs file and in that file I am trying to write a Select Query based on a Calculation View

I have tried it the following way:

var query = 'SELECT TOP 100 \"Name\", \"Address\", \"City\", \"Country\" FROM \"_SYS_BIC\".\"Test.HL/AddressView\"'

+ 'WITH PARAMETERS(\'PLACEHOLDER\' = (\'$$P_Name$$\', \' Akhil \'),'

+ '\'PLACEHOLDER\' = (\'$$P_City$$\', \' Lucknow \'))';

But it gives me the "Mixed spaces and tabs error".

How should I write XSJS Select Query with input parameters?

Regards,

Rohit