$var = %infinity%

[Necromorph]

okay, this is most likely been answered, i did look around for a bit with nothing usefull but is there an easy way to asign a varable to infiniy?

basically this is what i want

$instance = "MSSQLSERVER"
$infinity = {here is where the method to get infinity would go}
For $x = 1 to $infiniy
    $var = RegEnumVal("HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL", $x)
If $instance = $var Then
    MsgBox(0, "instance already exists", $var)
EndIf
Next

i know that people problably won't have more then two instances of SQL, so i could just say $x - 1 to 5, and it would most likely be fine, but still, i would just like to know how to "wildcard" a number, so to speak, thanks for any help.

[AlmarM]

Try something like this.

Global $iNum = 0

While Sleep(100)
    ConsoleWrite("| ------> $iNum        : " & $iNum & @CRLF)
    $iNum += 1

    If ($iNum == 10) Then Exit ; just to make sure the script exits
WEnd

EDIT:

HotKeySet("{ESC}", "_Exit")

Global $sInstance = "MSSQLSERVER"
Global $iNum = 1

While Sleep(25) ; prevent lots of CPU usage
    $sVar = RegEnumVal("HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL", $iNum)

    If ($sVar == $sInstance) Then
        MsgBox(0, "", "Instance already exists." & @CRLF & $sVar)
    EndIf

    $iNum += 1
WEnd

Func _Exit()
    Exit
EndFunc

Edited October 11, 2010 by AlmarM

[trung0407]

Try to do a loop and exit until you found the value or exitloop when there is error

[jvanegmond]

Infinity is approximately 97231. I tried counting further, but couldn't.

$instance = "MSSQLSERVER"
$infinity = 97231
For $x = 1 to $infiniy
    $var = RegEnumVal("HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL", $x)
If $instance = $var Then
    MsgBox(0, "instance already exists", $var)
EndIf
Next

[Necromorph]

thanks for all the help everyone, here is how i ended up doing it

$instance = "MSSQLSERVER"
$x = 1

Do
    $instances = RegEnumVal("HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL", $x)
    If $instance <> $instances Then
        $x += 1
    ElseIf $instance = $instances Then
        MsgBox(0, "", "Instance already exists." & @CRLF & $instance)
        ExitLoop
    EndIf
Until @error = -1

may not be the best, but it is working. and Manadar, i agree with you, and like i said, i could have said " For $x = 1 to 5" and been fine with sql instances, but i want a better way to get to "infinity", which i still didn't answer. thanks.

[trung0407]

This is a proper way to write

This is to find a value, exit when value is found

$instance = "MSSQLSERVER"
$x = 0
Do
    $x += 1
    $instances = RegEnumVal("HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL", $x)
Until @error = -1 Or $instances = $instance
;msgbox...

Use exitloop when it's really necessary

Edited October 11, 2010 by trung0407