Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 551
  • Last Modified:

MSSQL Select one Field

I am building a Auto-It script that connects to ms sql and returns a field for a variable. Here is my query:

SELECT TOP 1 sde_id FROM  sde.SDE_process_information
Displays:

sde_id
116648


But I would like it to just return 116648 only. How do i get results for just one field without the row name.
Thanks


Sqlserver 2008
0
CityInfoSys
Asked:
CityInfoSys
1 Solution
 
cyberkiwiCommented:
Without looking at your script, it's very hard to change it.
Normally, a query would only return the value, so your script must be specifically inserting the column name.
Does it actually return as a string with embedded line break?
0
 
LowfatspreadCommented:
if you are running via sqlcmd try the -H parameter...alternatively  use a stored procedure and an output parameter,,,
0
 
George K.Commented:
Have a look at these functions


_CreateTable - create a new table in the database.
_CreateColumn - create a new column in a table in the database.
_DropCol - delete a column and its contents from a table in the database.
_DropTbl - delete a table and its contents from the database.
_CountRecords - returns the number of records in a column that match a specific search parameter.
_CountTables - returns the number of tables that are in the database.
_GetColNames - returns an array with the number of columns in the first array element and all of the column names in the specified table from the database.
_GetTblNames -returns an array with the number of tables in the first array element and all of the table names in the specified database.
_GetColVals - gets all of the values in a specified column in a specified table from the database.
_GetColCount - returns the number of columns in a specified table in the database.
_GetColType - returns the data type of a column specified in a table from the database.
_GetDBNames - returns an array with the number of databases in the first array element and all of the database names in the specified server.
_ChangeCon - changes the connection object to allow for a different username, password, server, or database.



http://dailycupoftech.com/2007/04/18/mysql-data-manipulation-with-autoit/




0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
George K.Commented:
Can you paste your code?
0
 
CityInfoSysAuthor Commented:
Here is the code I am still working on. Mainly I need to figure out the query part. Also this is MSSQL not mysql.
Thanks
;AutoIt Code

$Query = "SELECT TOP 1 sde_id FROM  sde.SDE_process_information"

Func SqlConnection()
	If $adoCn.State = $adStateOpen Then $adoCn.Close
	$adoCn.ConnectionString = $Conn
	$adoCn.Open
	If $adoRs.State = $adStateOpen Then $adoRs.Close
	$adoRs = $adoCn.Execute($Query)
	If $adoRs.State = $adStateOpen Then
		$J = $adoRs.Fields.Count - 2 
		For $K = 0 To $J
		$Output = $Output & $adoRs.Fields($K).Name & @TAB
		Next
		$Output = $Output & @CRLF
		$Output = $Output & $adoRs.GetString(2, -1, @TAB, @CRLF, "Null")
		$adoRs.Close
		GUICtrlSetData($EditResults, $Output)
	EndIf
EndFunc   

Open in new window

0
 
George K.Commented:
I 've had a very fast look to your code.
Maybe delete this line?:
$Output = $Output & $adoRs.Fields($K).Name & @TAB
0
 
cyberkiwiCommented:
Delete 4 lines otherwise you have a loop that does nothing. You also get an extra CRLF

delete
            For $K = 0 To $J
            $Output = $Output & $adoRs.Fields($K).Name & @TAB
            Next
            $Output = $Output & @CRLF

so you end up with
;AutoIt Code

$Query = "SELECT TOP 1 sde_id FROM  sde.SDE_process_information"

Func SqlConnection()
	If $adoCn.State = $adStateOpen Then $adoCn.Close
	$adoCn.ConnectionString = $Conn
	$adoCn.Open
	If $adoRs.State = $adStateOpen Then $adoRs.Close
	$adoRs = $adoCn.Execute($Query)
	If $adoRs.State = $adStateOpen Then
		$J = $adoRs.Fields.Count - 2 
		$Output = $Output & $adoRs.GetString(2, -1, @TAB, @CRLF, "Null")
		$adoRs.Close
		GUICtrlSetData($EditResults, $Output)
	EndIf
EndFunc   

Open in new window

0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now