Hi
can u pls help me out with this as
i am relatively new to unix.
I need to use 4 different types of dates in my shell script
* first day of the last(previous) month
* last day of the last(previous) month
* first day of the current month
* (sysdate-1) yesterday's date for the current... (5 Replies)
Hi everybody:
I have a problem. I have a output files which have this pattern:
number1
--space
block1a - 7rows/10columns/65elements
--space
block1b - 7rows/10columns/65elements
--space
block1c - 7rows/10columns/65elements
--space
number2
--space
block2a - 7rows/10columns/65elements... (0 Replies)
Hi, I have a slight problem in trying to manipulate the text within a file using the "sed" command in that the text i need changed has "/" slashes in.
I have a .sh script that scans the "/db/sybbackup/" directories for any .dmp file older than 2 days and then to >> the information to a file called... (3 Replies)
Hi guys, I was wandering if a Shell guru could give me some advice on tackling a problem.
I have used a mixture of grep, cut and awk to get data from a log file in the following format:
14/11/08 10:39: Checking currenly : Enabled
14/11/08 10:39: Records allocated : 221... (11 Replies)
Hey guys.. I am not sure if this is the right place to post this - but here goes. I need to manipulate an openldap export to match a different schema so that I can import into that system. Basically - its just text manipulation. I have gotten alot of it done just by using simple sed, but I am sorta... (0 Replies)
I have a simple txt files that looks something like this (The title is a part of the text file)
Student Grades
---------------
1 Tim Purser 89
2 John Wayne 56
3 Jenn Hawkins 95
4 Harry Potter 75
Here are my questions:
How would I ONLY print the names of students... (2 Replies)
Hi All,
I have a file like below and i have 2 questions on this (They are 3 lines starts with 01 , 02 and 03. but is
01abc333644554 234 2334535 34534535355353 sfsdf345455
353 4543 jgkg tty 7676
02cdesdfsdfsdf 234 wesdfsdf 345345 234234 234234 2342342 dfgdfg
sdfgg dgdgdg fgvfs... (6 Replies)
Hello,
How can I remove partial duplicates and manipulate text in bash using either awk, grep or sed? Thanks.
Input:
ted,"foo,bar,zoo"
john-son,"foot,ben,zoo"
bob,"bar,foot"
Expected Output:
foo,ted
bar,ted
zoo,ted
foot,john-son
ben,john-son (4 Replies)
I attached both picturehttps://1drv.ms/t/s!Aoomvi55MLAQh1jODfUxa-xurns_ and *.txt file of a sample work file. In this file Reactions which only start with "r1f", "r2f", "r3f"......and so on. And for each reaction the reaction rates is situated couple of lines later with a "+" sign.
For each... (1 Reply)
Hi All,
I have a working script as below.
echo "Files loaded with $(cat /var/tmp/script.X1.out)" | mail -s "Files loaded with return code" mailid
This script takes the output from script.X1.out file and appends the text "Files loaded with return code" and sends the email. Now what I want... (5 Replies)
Discussion started by: midhun3108
5 Replies
LEARN ABOUT PHP
sqlsrv_client_info
SQLSRV_CLIENT_INFO(3)SQLSRV_CLIENT_INFO(3)sqlsrv_client_info - Returns information about the client and specified connectionSYNOPSIS
array sqlsrv_client_info (resource $conn)
DESCRIPTION
Returns information about the client and specified connection
PARAMETERS
o $conn
- The connection about which information is returned.
RETURN VALUES
Returns an associative array with keys described in the table below. Returns FALSE otherwise.
Array returned by sqlsrv_client_info
+--------------+-------------------------------------------------+
| Key | |
| | |
| | Description |
| | |
+--------------+-------------------------------------------------+
|DriverDllName | |
| | |
| | SQLNCLI10.DLL |
| | |
|DriverODBCVer | |
| | |
| | ODBC version (xx.yy) |
| | |
| DriverVer | |
| | |
| | SQL Server Native Client DLL version (10.5.xxx) |
| | |
|ExtensionVer | |
| | |
| | php_sqlsrv.dll version (2.0.xxx.x) |
| | |
+--------------+-------------------------------------------------+
EXAMPLES
Example #1
sqlsrv_client_info(3) example
<?php
$serverName = "serverNamesqlexpress";
$connOptions = array("UID"=>"username", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connOptions );
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
if( $client_info = sqlsrv_client_info( $conn)) {
foreach( $client_info as $key => $value) {
echo $key.": ".$value."<br />";
}
} else {
echo "Error in retrieving client info.<br />";
}
?>
SEE ALSO sqlsrv_server_info(3).
PHP Documentation Group SQLSRV_CLIENT_INFO(3)