CodePlex Issue #22418 Plain Text Attachments

php_sqlsrv_prob.txt

<?php

$connectionInfo = array( "Database"=>"Knowledgeroot2", "UID"=>"sa", "PWD"=>"Integra4711");
$conn = sqlsrv_connect( "WIN-3U11NKJ7P3U\SQLEXPRESS", $connectionInfo);

$sql = 'INSERT INTO "content" ("parent", "name", "content", "created_by", "changed_by", "create_date", "change_date") VALUES (?, ?, ?, ?, ?, ?, ?) SELECT SCOPE_IDENTITY() as Current_Identity';
$params = array(1, 'TTTTTTTTTTTTT', 'TTTTTTTTTTTTT', 0, 0, '20121128 20:01:57', '20121128 20:01:57');

$stmt = sqlsrv_query( $conn, $sql, $params);
if( $stmt === false ) {
     die( print_r( sqlsrv_errors(), true));
}

// Make the first (and in this case, only) row of the result set available for reading.
$next_result = sqlsrv_next_result($stmt);
$next_result = sqlsrv_next_result($stmt);

if( sqlsrv_fetch( $stmt ) === false) {
     die( print_r( sqlsrv_errors(), true));
}

// Get the row fields. Field indeces start at 0 and must be retrieved in order.
// Retrieving row fields by name is not supported by sqlsrv_get_field.
$name = sqlsrv_get_field( $stmt, 0);
echo "$name: ";

echo "jojo";