→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
GMFDE
Engaged Sweeper III
What is the proper syntax for this operation? I have tried the following:
Where tblAssets.AssetName = In ('asset name 1', 'asset name 2', 'asset name 3', 'asset name 4', 'asset name 5')
or
Where tblAssets.AssetName = In "'asset name 1, 'asset name 2'

I have also tried a number of variations.
1 ACCEPTED SOLUTION
GMFDE
Engaged Sweeper III
Disregard. I found out the problem was that Lansweeper has a very narrow interpretation about what constitutes a comma and a single quote mark. I had been using an html based text editor for doing my script markup. When I switched to Notepad++ and started writing the code out from scratch it worked. One cut/paste and global find and replace later, Viola.

View solution in original post

1 REPLY 1
GMFDE
Engaged Sweeper III
Disregard. I found out the problem was that Lansweeper has a very narrow interpretation about what constitutes a comma and a single quote mark. I had been using an html based text editor for doing my script markup. When I switched to Notepad++ and started writing the code out from scratch it worked. One cut/paste and global find and replace later, Viola.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now