Community FAQ
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.

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now