CVS update: php3/dl/mssql

From: Date: Wed, 06 Jan 1999 07:26:47 +0000
Subject: CVS update: php3/dl/mssql
Groups: php.dev 
Request: Send a blank email to php-dev+get-3324@lists.php.net to get a copy of this message
Date: Wednesday January 6, 1999 @ 2:26 Author: fmk Update of /repository/php3/dl/mssql In directory asf:/u/temp/cvs-serv11394 Modified Files: mssql.c Log Message: Adding two new php3.ini params: mssql.textsize and mssql.textlimit used to handle the block size of text columns Index: php3/dl/mssql/mssql.c diff -c php3/dl/mssql/mssql.c:1.11 php3/dl/mssql/mssql.c:1.12 *** php3/dl/mssql/mssql.c:1.11 Tue Jan 5 02:08:23 1999 --- php3/dl/mssql/mssql.c Wed Jan 6 02:26:47 1999 *************** *** 32,38 **** +----------------------------------------------------------------------+ */ ! /* $Id: mssql.c,v 1.11 1999/01/05 07:08:23 jah Exp $ */ #define IS_EXT_MODULE #ifdef THREAD_SAFE # ifndef PHP_31 --- 32,38 ---- +----------------------------------------------------------------------+ */ ! /* $Id: mssql.c,v 1.12 1999/01/06 07:26:47 fmk Exp $ */ #define IS_EXT_MODULE #ifdef THREAD_SAFE # ifndef PHP_31 *************** *** 277,282 **** --- 277,288 ---- } else { msSQL_GLOBAL(get_column_content) = php3_mssql_get_column_content_without_type; } + if (cfg_get_long("mssql.textsize",&msSQL_GLOBAL(textsize))==FAILURE) { + msSQL_GLOBAL(textsize) = -1; + } + if (cfg_get_long("mssql.textlimit",&msSQL_GLOBAL(textlimit))==FAILURE) { + msSQL_GLOBAL(textlimit) = -1; + } /* set a minimum timeout, and exclude infinite timeouts */ if(connecttimeout<1)connecttimeout=1; dbsetlogintime(connecttimeout); *************** *** 337,342 **** --- 343,349 ---- int hashed_details_length; mssql_link mssql,*mssql_ptr; list_entry *le; + char buffer[32]; msSQL_TLS_VARS; msSQL_GLOBAL(resource_list) = list; *************** *** 451,456 **** --- 458,480 ---- RETURN_FALSE; } + if (msSQL_GLOBAL(textsize) != -1) { + sprintf(buffer, "%li", msSQL_GLOBAL(textsize)); + if (dbsetopt(mssql.link, DBTEXTSIZE, buffer)==FAIL) { + efree(hashed_details); + dbfreelogin(mssql.login); + RETURN_FALSE; + } + } + if (msSQL_GLOBAL(textlimit) != -1) { + sprintf(buffer, "%li", msSQL_GLOBAL(textlimit)); + if (dbsetopt(mssql.link, DBTEXTLIMIT, buffer)==FAIL) { + efree(hashed_details); + dbfreelogin(mssql.login); + RETURN_FALSE; + } + } + /* hash it up */ mssql_ptr = (mssql_link *) malloc(sizeof(mssql_link)); memcpy(mssql_ptr,&mssql,sizeof(mssql_link)); *************** *** 552,558 **** dbclose(mssql.link); RETURN_FALSE; } ! /* add it to the list */ mssql_ptr = (mssql_link *) emalloc(sizeof(mssql_link)); memcpy(mssql_ptr,&mssql,sizeof(mssql_link)); --- 576,603 ---- dbclose(mssql.link); RETURN_FALSE; } ! ! if (msSQL_GLOBAL(textlimit) != -1) { ! sprintf(buffer, "%li", msSQL_GLOBAL(textlimit)); ! if (dbsetopt(mssql.link, DBTEXTLIMIT, buffer)==FAIL) { ! efree(hashed_details); ! dbfreelogin(mssql.login); ! RETURN_FALSE; ! } ! } ! if (msSQL_GLOBAL(textsize) != -1) { ! sprintf(buffer, "SET TEXTSIZE %li", msSQL_GLOBAL(textsize)); ! ! dbcmd(mssql.link, buffer); ! dbsqlexec(mssql.link); ! dbresults(mssql.link); ! // if (dbsetopt(mssql.link, DBTEXTSIZE, buffer)==FAIL) { ! // efree(hashed_details); ! // dbfreelogin(mssql.login); ! // RETURN_FALSE; ! // } ! } ! /* add it to the list */ mssql_ptr = (mssql_link *) emalloc(sizeof(mssql_link)); memcpy(mssql_ptr,&mssql,sizeof(mssql_link)); *************** *** 590,595 **** --- 635,641 ---- return msSQL_GLOBAL(default_link); } + /* {{{ proto int mssql_connect([string host[, string user[, string password]]]) Open MS-SQL server connection */ void php3_mssql_connect(INTERNAL_FUNCTION_PARAMETERS) *************** *** 790,795 **** --- 836,842 ---- } } + /* {{{ proto int mssql_query(string query[, int link_id]) Send MS-SQL query */ void php3_mssql_query(INTERNAL_FUNCTION_PARAMETERS) *************** *** 831,836 **** --- 878,884 ---- } convert_to_string(query); + if (dbcmd(mssql_ptr->link,query->value.str.val)==FAIL) { php3_error(E_WARNING,"MS SQL: Unable to set query"); RETURN_FALSE; *************** *** 1104,1110 **** } result->cur_row++; } - /* {{{ proto object mssql_fetch_object(int result) Fetch row as object */ --- 1152,1157 ---- -- PHP Development Mailing List http://www.php.net/ To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net For help: php-dev-help@lists.php.net

« previous php.dev (#3324) next »