
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-06-2018 08:55 PM
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.
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.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-07-2018 03:41 PM
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.
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-07-2018 03:41 PM
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.
