Hello Steve,
can you please make a unified diff (diff -u)? That is much more readable.
Derick
On Tue, 16 Apr 2002, steve dillon wrote:
> The 4.1.2 (and before) mssql entension returns datetime fields as a locale
> specific format eg: Oct 30 2001 7:44PM, which doesn't allow access to the
> seconds or milliseconds field of datetime. I patched my copy of mssql to
> have a php.ini entry mssql.longdatetime which tells mssql to return datetime
> in the long format: eg: 2001-10-30 19:44:54.206. 99% of the changes are in
> php_mssql.c with php_mssql.h just needing a variable added to it. Diff of
> php4.1.2 php_mssql.c => my patch ver
>
> 45,46c45,46
> < static void php_mssql_get_column_content_with_type(mssql_link
> *mssql_ptr,int offset,zval *result, int column_type);
> < static void php_mssql_get_column_content_without_type(mssql_link
> *mssql_ptr,int offset,zval *result, int column_type);
> ---
> > static void php_mssql_get_column_content_with_type(mssql_link
> *mssql_ptr,int offset,zval *result, int column_type,long longdatetime);
> > static void php_mssql_get_column_content_without_type(mssql_link
> *mssql_ptr,int offset,zval *result, int column_type,long longdatetime);
> 136a137
> > STD_PHP_INI_BOOLEAN("mssql.longdatetime", "0",
> PHP_INI_ALL, OnUpdateBool, longdatetime,
> zend_mssql_globals, mssql_globals)
> 739c740
> < static void php_mssql_get_column_content_with_type(mssql_link
> *mssql_ptr,int offset,zval *result, int column_type)
> ---
> > static void php_mssql_get_column_content_with_type(mssql_link
> *mssql_ptr,int offset,zval *result, int column_type,long longdatetime)
> 795,801c796,823
> < char *res_buf;
> < int res_length =
> dbdatlen(mssql_ptr->link,offset);
> < if (column_type == SQLDATETIM4) res_length
> += 14;
> < if (column_type == SQLDATETIME) res_length
> += 10;
> <
> < res_buf = (char *) emalloc(res_length + 1);
> < res_length =
> dbconvert(NULL,column_type,dbdata(mssql_ptr->link,offset),
> res_length,SQLCHAR,res_buf,-1);
> ---
> > char *res_buf; > int res_length;
> >
> > if (column_type == SQLDATETIME && longdatetime ) {
> > /* if it is the long date time format and user wants the
> extended date/time (with seconds and millis)*/
> > /* then output: 2001-03-15 23:06:36.000 */
> > DBDATEREC dr;
> >
> > if (dbdatecrack(mssql_ptr->link,&dr,(DBDATETIME
> *)dbdata(mssql_ptr->link,offset)) != SUCCEED) {
> > php_error(E_ERROR,"MS SQL: column %d unable to convert
> datetime field", offset);
> > ZVAL_FALSE(result);
> > /* no further processing */
> > return;
> > }
> >
> > res_length = 23;
> > res_buf = (char *) emalloc(res_length+1);
> > sprintf(res_buf,"%4d-%02d-%02d %02d:%02d:%02d.%03d",
> >
> dr.year,dr.month,dr.day,dr.hour,dr.minute,dr.second,dr.millisecond);
> >
> > } else {
> > res_length = dbdatlen(mssql_ptr->link,offset);
> > if (column_type == SQLDATETIM4) res_length += 14;
> > if (column_type == SQLDATETIME) res_length += 10;
> >
> > res_buf = (char *) emalloc(res_length + 1);
> > res_length =
> dbconvert(NULL,column_type,dbdata(mssql_ptr->link,offset),
> res_length,SQLCHAR,res_buf,-1);
> > }
> 814c836
> < static void php_mssql_get_column_content_without_type(mssql_link
> *mssql_ptr,int offset,zval *result, int column_type)
> ---
> > static void php_mssql_get_column_content_without_type(mssql_link
> *mssql_ptr,int offset,zval *result, int column_type, long unused)
> 858a881,885
> > /* Ugh.. It would be cleaner to fetch the longdatetime in */
> > /* get_column_content_with_type, but doing the thread-safe lookup */
> > /* for every row that has a datetime field seems bad also. So get it
> */
> > /* here and pass the value in */
> > long longdatetime = MS_SQL_G(longdatetime);
> 916c943
> < MS_SQL_G(get_column_content(mssql_ptr, j+1,
> &result->data[i][j], column_types[j]));
> ---
> > MS_SQL_G(get_column_content(mssql_ptr, j+1,
> &result->data[i][j], column_types[j],longdatetime));
>
>
-----------------------------------------------------------------------
Did I help you? Consider a gift:
http://www.amazon.co.uk/exec/obidos/registry/SLCB276UZU8B
-----------------------------------------------------------------------
PHP: Scripting the Web - [EMAIL PROTECTED]
All your branches are belong to me!
SRM: Script Running Machine - www.vl-srm.net
-----------------------------------------------------------------------
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, visit: http://www.php.net/unsub.php
