hi all
i have directory
/usr
under this directory i have subdirectories
tmp1,tmp2,tmp3
like this
/usr/tmp1
/usr/tmp2
/usr/tmp3
and so on
i want to search string in files (i don't know the name of the files)and i want to serch it in all the directories under the /usr
how shell i do... (3 Replies)
I am doing "ps -f" to see my process.
but I get lines that one of it represents the ps command itself.
I want to grep it out using -v flag, but than I get another process that belongs to the GREP itself :
I would like to exclude
# ps -f
UID PID PPID C STIME TTY TIME CMD... (2 Replies)
i want to search in the current directory all the files that contain one word for example "hello"
i want to achieve it with the grep command but not with the grep * (2 Replies)
Hi, im taking an entry Unix class, and as part of my lab assignment I have to copy all files in the /home/david/lab3 directory that have the file extension .save to your lab3/temp directory. I'm having trouble getting the grep to do anything worth while
I've been trying to do:
cp... (6 Replies)
Hi,
I have around 500 Text files and Each file will be having either
String1 or String2.
I want to list the file only which has String1 and Sting2 in a single command.. (5 Replies)
Hi
I have lots of file in on folder and i want to egrep from only few files.
List of files......
Polt_KJ_430_OutputRBS_istUt_CR2.log
Polt_KN_4122_OutputRBS_ncChk_CR.log
Polt_LN_2230_OutputRNC_Hth_CLKLKL.log
Solt_KJ_430_OutputRBS_istUt_CR2.log
Solt_KN_4122_OutputRBS_ncChk_CR3.log... (2 Replies)
grep -i -f panel_genes.txt hg19_refGene.txt > match.txt
seems to be pulling names the do not exist in the input file (panel_genes.txt) - the output is attached as well (match.txt)
For example, RNF185 or ZNF146 are not genes in the input. I am trying to match the input file genes only and am... (9 Replies)
Hello,
I am running below command as root user
#nodetool cfstats tests | grep "Memtable switch count"
Memtable switch count: 12
Where as when I try to run same command as another user it gives different result.
#su -l zabbix -s /bin/bash -c "nodetool cfstats tests | grep "Memtable switch... (10 Replies)
for example i have a directory
home/solaris/unix/samplefiles/
with defaults files in it.. those default files have 1 word in common "UNIX". how can i list the files without "UNIX" words in it using grep command
thanks,
im using unix solaris, korn shell.. (1 Reply)
Discussion started by: daveaztig14
1 Replies
LEARN ABOUT PHP
sqlsrv_commit
SQLSRV_COMMIT(3)SQLSRV_COMMIT(3)sqlsrv_commit - Commits a transaction that was begun withsqlsrv_begin_transaction(3)SYNOPSIS
bool sqlsrv_commit (resource $conn)
DESCRIPTION
Commits a transaction that was begun with sqlsrv_begin_transaction(3). The connection is returned to auto-commit mode after sqlsrv_com-
mit(3) is called. The transaction that is committed includes all statements that were executed after the call to sqlsrv_begin_transac-
tion(3). Explicit transactions should be started and committed or rolled back using these functions instead of executing SQL statements
that begin and committ/roll back transactions. For more information, see SQLSRV Transactions.
PARAMETERS
o $conn
- The connection on which the transaction is to be committed.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
sqlsrv_commit(3) example
The following example demonstrates how to use sqlsrv_commit(3) together with sqlsrv_begin_transaction(3) and sqlsrv_rollback(3).
<?php
$serverName = "serverNamesqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true ));
}
/* Begin the transaction. */
if ( sqlsrv_begin_transaction( $conn ) === false ) {
die( print_r( sqlsrv_errors(), true ));
}
/* Initialize parameter values. */
$orderId = 1; $qty = 10; $productId = 100;
/* Set up and execute the first query. */
$sql1 = "INSERT INTO OrdersTable (ID, Quantity, ProductID)
VALUES (?, ?, ?)";
$params1 = array( $orderId, $qty, $productId );
$stmt1 = sqlsrv_query( $conn, $sql1, $params1 );
/* Set up and execute the second query. */
$sql2 = "UPDATE InventoryTable
SET Quantity = (Quantity - ?)
WHERE ProductID = ?";
$params2 = array($qty, $productId);
$stmt2 = sqlsrv_query( $conn, $sql2, $params2 );
/* If both queries were successful, commit the transaction. */
/* Otherwise, rollback the transaction. */
if( $stmt1 && $stmt2 ) {
sqlsrv_commit( $conn );
echo "Transaction committed.<br />";
} else {
sqlsrv_rollback( $conn );
echo "Transaction rolled back.<br />";
}
?>
SEE ALSO sqlsrv_begin_transaction(3), sqlsrv_rollback(3).
PHP Documentation Group SQLSRV_COMMIT(3)