Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Microsoft SQL Server Functions : mssql_free_result

mssql_free_result

Free result memory (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
bool mssql_free_result ( resource result )

Examples ( Source code ) » mssql_free_result

<?php
// Select some data from a table
$query mssql_query('SELECT * FROM [php].[dbo].[persons]'$link);

// Handle query result here

// When we're done we free the result by calling
// mssql_free_result like so:
mssql_free_result($query);

Code Examples / Notes » mssql_free_result

veggivore

MSSQL only allows one HRESULT open per connection. If you have a query with a server side cursor open any subsequent queries using that connection will fail.

26-jul-2005 10:56

Bug #33877   When multiple result sets are not freed subsequent queries fail

Change Language


Follow Navioo On Twitter
mssql_bind
mssql_close
mssql_connect
mssql_data_seek
mssql_execute
mssql_fetch_array
mssql_fetch_assoc
mssql_fetch_batch
mssql_fetch_field
mssql_fetch_object
mssql_fetch_row
mssql_field_length
mssql_field_name
mssql_field_seek
mssql_field_type
mssql_free_result
mssql_free_statement
mssql_get_last_message
mssql_guid_string
mssql_init
mssql_min_error_severity
mssql_min_message_severity
mssql_next_result
mssql_num_fields
mssql_num_rows
mssql_pconnect
mssql_query
mssql_result
mssql_rows_affected
mssql_select_db
eXTReMe Tracker