Extract username only from MySQL query results to pass into variable

hi all,

i new powershell , mysql , having trouble passing username, returned query mysql server, variable without meta data of field name being copied also.

the query responds following:

login  -----  test1

i want "test1" pass variable $test. cannot work out correct way this.

i importing module have created store mysql query can simple call connection , pass query in separate script, module call mysqlconnection.psm1 , contains following:

function run-mysqlquery {        param(          [parameter(              mandatory = $true,              parametersetname = '',              valuefrompipeline = $true)]              [string]$query,             [parameter(              mandatory = $true,              parametersetname = '',              valuefrompipeline = $true)]              [string]$connectionstring          )      begin {          write-verbose "starting begin section"              }      process {          write-verbose "starting process section"          try {              # load mysql driver , create connection              write-verbose "create database connection"              # use direct link dll file              # $mysqldatadll = "c:\program files (x86)\mysql\mysql connector net 6.9.3\assemblies\v4.5\mysql.data.dll"              # [void][system.reflection.assembly]::loadfrom($mysqldatadll)              [void][system.reflection.assembly]::loadwithpartialname("mysql.data")              $connection = new-object mysql.data.mysqlclient.mysqlconnection              $connection.connectionstring = $connectionstring              write-verbose "open database connection"              $connection.open()                            # run mysql querys              write-verbose "run mysql querys"              $command = new-object mysql.data.mysqlclient.mysqlcommand($query, $connection)              $dataadapter = new-object mysql.data.mysqlclient.mysqldataadapter($command)              $dataset = new-object system.data.dataset              $recordcount = $dataadapter.fill($dataset, "data")              $dataset.tables["data"] | format-table          }                  catch {              write-host "could not run mysql query" $error[0]              }              {              write-verbose "close connection"              $connection.close()          }      }      end {          write-verbose "starting end section"      }  }    export-modulemember run-mysqlquery

this module called in script following:

$username = "test1"    import-module activedirectory  import-module c:\windows\system32\windowspowershell\v1.0\modules\mysql\mysqlconnection_test.psm1    $test = run-mysqlquery -connectionstring "server=test;uid=root;pwd=password123;database=test;" -query "select login usr_data usr_id = 226"

as state $test contains:

login  -----  test1

i sure missing simply, stumped far.

powershell , mysql not part of standard expertise appreciated!

ryan

.

$test = (run-mysqlquery -connectionstring "server=test;uid=root;pwd=password123;database=test;" -query "select login usr_data usr_id = 226").login

---

sam boutros, senior consultant, software logic, kop, pa http://superwidgets.wordpress.com (please take moment vote helpful and/or mark answer, applicable) _________________________________________________________________________________ powershell: learn before it's emergency http://technet.microsoft.com/en-us/scriptcenter/powershell.aspx http://technet.microsoft.com/en-us/scriptcenter/dd793612.aspx

Windows Server  >  Windows PowerShell