Check if variable is empty, if its empty then restart localhost Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Data science time! April 2019 and salary with experience Should we burninate the [wrap] tag? The Ask Question Wizard is Live!Setting Windows PowerShell path variableChecks about WinRM service in remote machineHow can I check if a string is null or empty in PowerShell?PowerShell issue when using string variable from web.config in concatenationPowershell script to restart serviceRename-Computer works fine unless I try to use $credentialsForeach loop output DateTime object plus other details.PowerShell Restart services if SQL statement returns valueWindows Task for restart if user not logged inIs there a way to warn remote computer of pending restart AND have my script wait for the restart to complete?
Denied boarding although I have proper visa and documentation. To whom should I make a complaint?
How do I stop a creek from eroding my steep embankment?
Echoing a tail command produces unexpected output?
List *all* the tuples!
Withdrew £2800, but only £2000 shows as withdrawn on online banking; what are my obligations?
How to bypass password on Windows XP account?
Storing hydrofluoric acid before the invention of plastics
What causes the vertical darker bands in my photo?
Book where humans were engineered with genes from animal species to survive hostile planets
Seeking colloquialism for “just because”
Extract all GPU name, model and GPU ram
What would be the ideal power source for a cybernetic eye?
What does the "x" in "x86" represent?
What is the logic behind the Maharil's explanation of why we don't say שעשה ניסים on Pesach?
List of Python versions
Sci-Fi book where patients in a coma ward all live in a subconscious world linked together
If a contract sometimes uses the wrong name, is it still valid?
Can I cast Passwall to drop an enemy into a 20-foot pit?
Ring Automorphisms that fix 1.
Why light coming from distant stars is not discreet?
Why did the rest of the Eastern Bloc not invade Yugoslavia?
Generate an RGB colour grid
How to deal with a team lead who never gives me credit?
Do I really need recursive chmod to restrict access to a folder?
Check if variable is empty, if its empty then restart localhost
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Data science time! April 2019 and salary with experience
Should we burninate the [wrap] tag?
The Ask Question Wizard is Live!Setting Windows PowerShell path variableChecks about WinRM service in remote machineHow can I check if a string is null or empty in PowerShell?PowerShell issue when using string variable from web.config in concatenationPowershell script to restart serviceRename-Computer works fine unless I try to use $credentialsForeach loop output DateTime object plus other details.PowerShell Restart services if SQL statement returns valueWindows Task for restart if user not logged inIs there a way to warn remote computer of pending restart AND have my script wait for the restart to complete?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Its a fairly basic thing I'm trying to do. I have two SQL queries that populate the variables below. I want the queries to run until they are empty then reboot the localhost.
Do
database Query that populates two variables. If both variables are empty then reboot the local host.
until($jobquery -and $testQuery)
restart-computer -computername "localhost" -force
powershell
add a comment |
Its a fairly basic thing I'm trying to do. I have two SQL queries that populate the variables below. I want the queries to run until they are empty then reboot the localhost.
Do
database Query that populates two variables. If both variables are empty then reboot the local host.
until($jobquery -and $testQuery)
restart-computer -computername "localhost" -force
powershell
1
until (!$jobquery -and !$testQuery)
oruntil ([string]::IsNullOrEmpty($jobquery) -and [string]::IsNullOrEmpty($testQuery))
– LotPings
Mar 8 at 17:50
add a comment |
Its a fairly basic thing I'm trying to do. I have two SQL queries that populate the variables below. I want the queries to run until they are empty then reboot the localhost.
Do
database Query that populates two variables. If both variables are empty then reboot the local host.
until($jobquery -and $testQuery)
restart-computer -computername "localhost" -force
powershell
Its a fairly basic thing I'm trying to do. I have two SQL queries that populate the variables below. I want the queries to run until they are empty then reboot the localhost.
Do
database Query that populates two variables. If both variables are empty then reboot the local host.
until($jobquery -and $testQuery)
restart-computer -computername "localhost" -force
powershell
powershell
asked Mar 8 at 17:40
user770022user770022
1,182133757
1,182133757
1
until (!$jobquery -and !$testQuery)
oruntil ([string]::IsNullOrEmpty($jobquery) -and [string]::IsNullOrEmpty($testQuery))
– LotPings
Mar 8 at 17:50
add a comment |
1
until (!$jobquery -and !$testQuery)
oruntil ([string]::IsNullOrEmpty($jobquery) -and [string]::IsNullOrEmpty($testQuery))
– LotPings
Mar 8 at 17:50
1
1
until (!$jobquery -and !$testQuery)
or until ([string]::IsNullOrEmpty($jobquery) -and [string]::IsNullOrEmpty($testQuery))
– LotPings
Mar 8 at 17:50
until (!$jobquery -and !$testQuery)
or until ([string]::IsNullOrEmpty($jobquery) -and [string]::IsNullOrEmpty($testQuery))
– LotPings
Mar 8 at 17:50
add a comment |
1 Answer
1
active
oldest
votes
Do you mean:
until(!$jobquery -and !$testQuery)
Or maybe a good suggestion would be to add try catch error handling so it will look something like this:
Do
try
database Query that populates two variables. If both variables are empty then reboot the local host.
catch
if(!$jobquery)
Write-Host "Unable to do query because jobquery is empty. Error: $($_.Exception.Message)" -ForegroundColor Red
elseif(!$testQuery)
Write-Host "Unable to do query because testquery is empty. Error: $($_.Exception.Message)" -ForegroundColor Red
else
Write-Host "Unable to do query because the following error: $($_.Exception.Message)" -ForegroundColor Red
until(!$jobquery -and !$testQuery)
restart-computer -computername "localhost" -force
Hope this helps!
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55068335%2fcheck-if-variable-is-empty-if-its-empty-then-restart-localhost%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Do you mean:
until(!$jobquery -and !$testQuery)
Or maybe a good suggestion would be to add try catch error handling so it will look something like this:
Do
try
database Query that populates two variables. If both variables are empty then reboot the local host.
catch
if(!$jobquery)
Write-Host "Unable to do query because jobquery is empty. Error: $($_.Exception.Message)" -ForegroundColor Red
elseif(!$testQuery)
Write-Host "Unable to do query because testquery is empty. Error: $($_.Exception.Message)" -ForegroundColor Red
else
Write-Host "Unable to do query because the following error: $($_.Exception.Message)" -ForegroundColor Red
until(!$jobquery -and !$testQuery)
restart-computer -computername "localhost" -force
Hope this helps!
add a comment |
Do you mean:
until(!$jobquery -and !$testQuery)
Or maybe a good suggestion would be to add try catch error handling so it will look something like this:
Do
try
database Query that populates two variables. If both variables are empty then reboot the local host.
catch
if(!$jobquery)
Write-Host "Unable to do query because jobquery is empty. Error: $($_.Exception.Message)" -ForegroundColor Red
elseif(!$testQuery)
Write-Host "Unable to do query because testquery is empty. Error: $($_.Exception.Message)" -ForegroundColor Red
else
Write-Host "Unable to do query because the following error: $($_.Exception.Message)" -ForegroundColor Red
until(!$jobquery -and !$testQuery)
restart-computer -computername "localhost" -force
Hope this helps!
add a comment |
Do you mean:
until(!$jobquery -and !$testQuery)
Or maybe a good suggestion would be to add try catch error handling so it will look something like this:
Do
try
database Query that populates two variables. If both variables are empty then reboot the local host.
catch
if(!$jobquery)
Write-Host "Unable to do query because jobquery is empty. Error: $($_.Exception.Message)" -ForegroundColor Red
elseif(!$testQuery)
Write-Host "Unable to do query because testquery is empty. Error: $($_.Exception.Message)" -ForegroundColor Red
else
Write-Host "Unable to do query because the following error: $($_.Exception.Message)" -ForegroundColor Red
until(!$jobquery -and !$testQuery)
restart-computer -computername "localhost" -force
Hope this helps!
Do you mean:
until(!$jobquery -and !$testQuery)
Or maybe a good suggestion would be to add try catch error handling so it will look something like this:
Do
try
database Query that populates two variables. If both variables are empty then reboot the local host.
catch
if(!$jobquery)
Write-Host "Unable to do query because jobquery is empty. Error: $($_.Exception.Message)" -ForegroundColor Red
elseif(!$testQuery)
Write-Host "Unable to do query because testquery is empty. Error: $($_.Exception.Message)" -ForegroundColor Red
else
Write-Host "Unable to do query because the following error: $($_.Exception.Message)" -ForegroundColor Red
until(!$jobquery -and !$testQuery)
restart-computer -computername "localhost" -force
Hope this helps!
answered Mar 8 at 17:52
Bernard MoeskopsBernard Moeskops
42738
42738
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55068335%2fcheck-if-variable-is-empty-if-its-empty-then-restart-localhost%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
until (!$jobquery -and !$testQuery)
oruntil ([string]::IsNullOrEmpty($jobquery) -and [string]::IsNullOrEmpty($testQuery))
– LotPings
Mar 8 at 17:50