[PHP-DEV] Bug #15338 Updated: Can't select database with '-' in name.
ID: 15338 Updated by: [EMAIL PROTECTED] Old Summary: Can't select database with '-' in name. Reported By: [EMAIL PROTECTED] Old Status: Open Status: Closed Bug Type: MSSQL related Operating System: windows NT IIS PHP Version: 4.1.1 New Comment: If your database name contains '-' or ' ' you can select the database like this: mssql_select_db([my database]); or mssql_select_db([my-database]); That works fine. Previous Comments: [2002-02-01 19:46:52] [EMAIL PROTECTED] I have a database on my MSSQL server with a '-' in the database name. The database works fine with all of my other applications including ASP. However, I cannot select the database with PHP. Interestingly, a '-' in the server name doesn't seem to be a problem. $server=SQL-Server; $dbName=My-DB; $user=phpusr; $passwd=phppass; $hcon = mssql_connect($server, $user, $passwd); if ($hcon == FALSE) die(Could not connect to SQL server '$server'); $hdb = mssql_select_db($dbName, $hcon); The resulting message is: Warning: MS SQL message: Line 1: Incorrect syntax near '-'. (severity 15) in C:\InetPub\PHP\dbtest.php on line 10 Warning: MS SQL: Unable to select database: My-DB in C:\InetPub\PHP\dbtest.php on line 10 Could not select database 'My-DB' Edit this bug report at http://bugs.php.net/?id=15338edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #11593 Updated: varchar(8000) field in MSSQL returns only 4096 chars
ID: 11593 Updated by: fmk Reported By: [EMAIL PROTECTED] Old Status: Open Status: Closed Bug Type: MSSQL related Operating System: NT4.0 PHP Version: 4.0.6 New Comment: The DB Library used for the MSSQL extension does not support char and varchar columns with more than 256 characters. char and varchar columns was extended from 256 to 8000 in SQL Server 7.0 but the DB library from Microsoft was not updated. If you want to use wide columns use the text type. Further textlimit only affects columns of type text. It has no effect on char or varchar columns. Previous Comments: [2001-06-24 09:45:15] [EMAIL PROTECTED] still the same on the new version 4.0.6. mssql_fetch_array() delivers only the first 4k. please help. [2001-06-20 17:22:32] [EMAIL PROTECTED] i have a table with varchar(8000) fields. tried to get the content. php delivers only the first 4k. odbc delivers the full range... i've added in the php.ini the setings for mssql.textlimit to 8192 and for mssql.textsize to 8192, too phpinfo() shows me my ini-settings but the content is stille 4k. please help asap. many thanks and best regards christian marnitz Edit this bug report at http://bugs.php.net/?id=11593edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #9071 Updated: Wide Charater problems
ID: 9071 Updated by: fmk Reported By: [EMAIL PROTECTED] Old Status: Open Status: Closed Bug Type: MSSQL related Operating System: windows2000server PHP Version: 4.0.4 New Comment: nchar, nvarchar and ntext columns used to store national character values are not supported by the DB library functions used in the MSSQL extension for PHP. The only fix at this point is to use an other set of DB functions, like ODBC with the latest ODBC driver from Microsoft. Previous Comments: [2001-04-16 06:46:16] [EMAIL PROTECTED] Reclassify [2001-02-02 07:27:33] [EMAIL PROTECTED] when use php read data from sql7.0,only 200 chinese characters be readed.But sql7.0 have more then 200 chinese characters.i use asp no this problem.why?how to do? Edit this bug report at http://bugs.php.net/?id=9071edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #11868 Updated: Improper character encoding
ID: 11868 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.0.6 New Comment: In the MS SQL Server Client Network Utility tool under DB-Library Option you can specify Automatic ANSI to OEM convertion. Change this setting and your problem should be solved. Previous Comments: [2001-07-04 05:13:48] [EMAIL PROTECTED] I am using PHP, Apache 1.3 and MSSQL 2000 server via mssql_* functions. If I SELECT some text types with czech characters (ie scaron; zcaron; etc.) these characters are malformed. If I INSERT and SELECT these chars directly from browser, they seem to be OK in browser, but not in direct DB view, so I suppose it is caused by incompatible character encoding between Apache, PHP and MSSQL server. Edit this bug report at http://bugs.php.net/?id=11868edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #14055 Updated: Install MS SQL Server 'client connectivity' before using php_mssql.dll
ID: 14055 Updated by: fmk Reported By: [EMAIL PROTECTED] Old Status: Open Status: Closed Bug Type: Documentation problem Operating System: Windows NT/2000 PHP Version: 4.0.6 New Comment: I have added this to the documentation under php.net/mssql. It will be available at the next update. Previous Comments: [2001-11-14 12:05:14] [EMAIL PROTECTED] Thanks for notifying, but making this a documentation problem. Derick [2001-11-14 11:32:18] [EMAIL PROTECTED] I have read the install.txt more than once, I have searched the online documentation and the mailing list archive for hours. But there was nowhere an explicit refer how you can get php_mssql.dll work properly. There are some suggestions of course but always 'maybe'. Do avoid others from searching as many hours for the solution I hope you will place the solution more findable. It would be pleasant if you add it to install.txt too. If you want to use php_mssql.dll on a NT-Webserver where isn't installed a MS SQL Server itself, you have at least to install the component 'Client Connectivity' from the MS SQL Server-CD (select custom installation!). Regards, J. Schadler Jet2Web Telekom/IT Edit this bug report at http://bugs.php.net/?id=14055edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #13722 Updated: mssql text type returns only 255 char
ID: 13722 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Sybase-ct (ctlib) related Operating System: Solaris 2.7 PHP Version: 4.0.6 New Comment: When you use subase-ct and FreeTDS you are not using the mssql extension, and all the settings in the ini file for mssql is not used. The settings you are refering to works when you use the mssql extension, though that extension is only available on Win32 platforms. Previous Comments: [2001-10-17 22:19:34] [EMAIL PROTECTED] Built with: (edited config template to remove uneccessary sybase libs that are not included with freetds -lsybtcl -lcomn -lcs ) ./configure --prefix=/home/username/php --with-sybase-ct=../../freetds --with-pgsql=/home/postgres/pgsql --with-apache=../../apache_1.3.22 -enable-track-vars --with-imap=../../imap make make install FreeTDS verified functional using test scripts, and functional through Perl to same DB that PHP is connected to. Problem: Text type returns only first 255 chars Expected: 540 chars (can retrieve through FreeTDS/Perl) php.ini contains uncommented lines: mssql.textlimit=8192 mssql.textsize=8192 Query to MSSQL Server: SELECT @@TEXTSIZE Returns: 4096 Expected: 8192 (due to php.ini settings?) Query to MSSQL Server: SET TEXTSIZE 8192 SELECT @@TEXTSIZE Returns: 8192 Expected: 8192 Suspect: php.ini not being read But: other setting changes show up on php_info() Suspect: mssql settings not being read properly from php.info? Query to MSSQL Server: SET TEXTSIZE 8192 SELECT our_col FROM our_table; Returns: only first 255 chars of our_col Expected: all 500+ chars in field Edit this bug report at http://bugs.php.net/?id=13722edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #13357 Updated: TEXTAREA not accepting variable value
ID: 13357 Updated by: fmk Reported By: [EMAIL PROTECTED] Old Status: Open Status: Closed Bug Type: Output Control Operating System: Unix PHP Version: 4.0.6 New Comment: This is not a bug in PHP. Try WRAP='virtual' NAME='note' ROWS='4' COLS='52'$note/TEXTAREA - Frank Previous Comments: [2001-09-18 00:59:24] [EMAIL PROTECTED] print(trtd height='82' colspan='2' valign='top'TEXTAREA WRAP='virtual' NAME='note' value='$note' ROWS='4' COLS='52'/TEXTAREA/td/tr) ;I The above TEXTAREA tag will not accept a variable. The INPUT tag will accept the same varible. print(trtd height='12' colspan='2' valign='top'INPUT type='text' NAME='note' value='$note' size='52'/td/tr) ; Edit this bug report at http://bugs.php.net/?id=13357edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #12479 Updated: Request for (on click) feature in list boxes
ID: 12479 Updated by: fmk Reported By: [EMAIL PROTECTED] Old Status: Open Status: Closed Bug Type: Feature/Change Request Operating System: WIN9x/WINNT PHP Version: 4.0.6 New Comment: PHP is a server side scripting language. If you want magic stuff to happen on the client side you have to write it using JavaScript or other techniques available on the client. Previous Comments: [2001-07-31 03:49:04] [EMAIL PROTECTED] As a Foxpro programmer trying to migrate to PHP, Is it possible with PHP to automatically refresh some fields in a form based on a choice made from a combi/list box, something along the operation of the [valid()] clause in Foxpro Access without having to click on the [submit] button I could do it using multiple similar hidden forms, but it's less user friendly than just clicking on an item (say apples), then automatically populating the next combi/list with Granny Smith, Golden Delicious etc, and filling unit of sale Unit cost text boxes with the last entered value. Then when the variety is redefined, refreshing again the unit of sale Unit cost text boxes Any chance in later versions, or is it just not possible within the PHP framework? Edit this bug report at http://bugs.php.net/?id=12479edit=1 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #12348 Updated: Call to undefined function: mssql_next_result()
ID: 12348
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MSSQL related
Operating System: linux 7.1
PHP Version: 4.0.6
New Comment:
Please notice that the FreeTDS stuff might be broken for SQL Server 2000 and up.
Previous Comments:
[2001-07-24 18:37:30] [EMAIL PROTECTED]
We do have a patch that you can roll out in your next release i will send in soon
after removing junk comments.
[2001-07-24 17:18:13] [EMAIL PROTECTED]
please send your patch (when you are done) to
[EMAIL PROTECTED]
[2001-07-24 16:45:26] [EMAIL PROTECTED]
the issue is i am using the sybase C files and the function is for the mssql C files.
I am working with a coworker to rewrite the sybase C files to support the
mssql_next_result function. If you have a version that does please let me know and if
we get this to work i will give you the C files for the next release.
// error
Fatal error: Call to undefined function: mssql_next_result() in
/usr/local/apache/htdocs/reporting/reports/rpttrafficdetailsbycpc.dll on line 12
[2001-07-24 14:26:35] [EMAIL PROTECTED]
could you post the exact error message, or put the script
on the internet so I can view it.
[2001-07-24 14:24:14] [EMAIL PROTECTED]
?
if (connect_db($ip, $db)) {
$q = exec $sp @date='$date';
$results = mssql_query($q);
$max = mssql_num_fields($results);
for ($f=0; $f $max; $f++) {
$name = mssql_fetch_field($results, $f);
print $name-name .br;
}
// this is the problem ??? the sp has 2 result sets
// i am trying to get to the second set.
mssql_next_result($results);
}
?
// config line
./configure \
--with-mysql \
--with-mhash \
--with-sybase=/usr/local/freetds \
--with-apache=../apache_1.3.20 \
--enable-versioning \
--disable-debug \
--enable-debug=no \
--enable-sigchild \
--enable-calendar \
--enable-trans-sid \
--disable-xml
// other info
i am runnong freetds v.0.51 connecting to sql2000
Edit this bug report at http://bugs.php.net/?id=12348edit=1
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #7780 Updated: Return of Text field returns only 4kB, but only in ISAPI-Mode
ID: 7780 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.3pl1 Assigned To: Comments: This has been fixed. When running the ISAPI module, the php.ini file was not read correctly. Upgrade to latest version Previous Comments: --- [2000-11-13 06:22:01] [EMAIL PROTECTED] Working with IIS 4 and ISAPI, and having added the following lines to php.ini *snip* mssql.textsize = 8192 ; mssql.textlimit = 8192 ; *snip* a request of a field with Data-Type Text 4kB gives back only the first 4kB of the text (in general). The interesting phenomenon is: After restarting IIS completely (net stop iisadmin), the WHOLE text out of the DB (appr. 6kB) will be returned, but only ONCE (meaning a reload in the browser, taking another browser, etc. gives again only the cutted text-field). Working in CGI-mode, the whole text will be returned every time. A exemplary code-snippet, if it helps: **shortened snip** $check = SELECT * FROM $table WHERE $QUERY_STRING; $result = mssql_query($check) or die(Konnte die Datenbankabfrage nicht durchführen.); $row=mssql_fetch_row($result); $head = makehtmlchar($row[2]); $body = makehtmlchar($row[3]); $mytext .= table width=610 trtdh4b$head/bbrfont class=stdtext($row[1])/font/h4/td/tr trtdfont class=bigtext$body /font/tdn; **snip** --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=7780edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #8810 Updated: Access violation with mssql.allow_persistent = on
ID: 8810 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: The function mssql_pconnect() has been fixed in php4.0.6. Please update and try again. Previous Comments: --- [2001-01-19 14:45:00] [EMAIL PROTECTED] PHP 4.0.4pl1 gives an access violation when persistent connections are enabled using mssql.allow_persistent = on. It doesn't matter if they are used or not. The code seems to work but each request produces an access violation dialog. Setting mssql.allow_persistent to off resolves the problem (for a price I'm not willing to pay). I tried both MS SQL Server 7 and 2000 both on Windows 2000 Professional. PHP 4.0.4 had the same problems. --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=8810edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #8777 Updated: Error in mssql_query
ID: 8777
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Operating system:
PHP Version: 4.0.4pl1
Assigned To:
Comments:
Update to latest version. The return value for mssql_query has been fixed.
Previous Comments:
---
[2001-01-18 04:25:23] [EMAIL PROTECTED]
for INSERT,UPDATE,DELETE
$Sql=INSERT INTO $phpAds_tbl_session
(Cod_Sessions,moses_SessionID,moses_SessionData,moses_LastUpdate)VALUES
($Max,'$SessionID', '.AddSlashes(serialize($Session)) . ', .date(YmdHis).) ;
if ($conn-Execute($Sql)===false){
Connection_die(Kc_End insertando);
$conn-close();
}
$con-execute all code return false forever
---
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=8777edit=2
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #11730 Updated: Cannot use uniqueidentifier
ID: 11730
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Operating system:
PHP Version: 4.0.6
Assigned To:
Comments:
UNIQUEIDENTIFYER is an alias for a 16 byte binary and as the support for binary data
was changed between 4.0.5 and 4.0.6, the data returned is no longer converted to a
readable string.
A new function will be introduced mssql_guid_string() in 4.0.7. This function can
convert the binary value to a readable string.
If you dont want the extra call in your code, use this work arround:
select cast(id as varchar(36)) from my table
Previous Comments:
---
[2001-06-27 05:15:20] [EMAIL PROTECTED]
(Apache 1.3.20, PHP4.0.64.0.4,MSSQL70)
Cannot work with the MSSQL-uniqueidentifier.
e.g. I need to use following select in php:
select newid() as id;
normally I would get something like this
id={874E725E-03A0-44C7-BB0B-E52C7EC74B9F}
but the vars only get cryptical codes like
ägøüO²wÕ® ?
---
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11730edit=2
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #10413 Updated: Error retrieving image field from MSSQL database
ID: 10413
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Operating system:
PHP Version: 4.0.4pl1
Assigned To:
Comments:
Handling of binary data was changed in php4.0.6. Please update and try again.
Previous Comments:
---
[2001-04-19 22:01:41] [EMAIL PROTECTED]
Looks like there's a problem in the Windows version of the mssql extension. I'm having
the same problem as Leonid Freidin with queries that have a image in the result.
I'm using php4.04pl1.
This is the code.
?
$con = mssql_connect(laptop2000,sa,adfasdf) or die(couldnt connect to db);
//Nos conectamos al servidor de BD
if (mssql_select_db(MexMatch,$con)) {
$query= select * from Usuario where apodo = 'karls'; //It crashes here,
because I have an image field here.
$result = mssql_query($query,$con) or die(bke);
while($array = mssql_fetch_array($result))
echo $array{apodo};
mssql_free_result($result);
}
mssql_close($con);
?
---
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10413edit=2
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #9379 Updated: mssql_query can't get result
ID: 9379 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.3pl1 Assigned To: Comments: This is not a bug in the extension. You are sending queries to the server that causes the server to report errors. Previous Comments: --- [2001-02-21 13:45:45] [EMAIL PROTECTED] mssql_query() can't fetch result from server if I use sql server variables in query. For example this script: ?php mssql_connect([server],[user],[password]) $sql_result=mssql_query(declare @kala int;select @kala=5;delete from [table] where field1=@kala); $sql_result2=mssql_query(select * from kasutajad); ? If I turned error severity to 0 I saw following error:MS SQL error: Attempt to initiate a new SQL Server operation with results pending. (severity 7) in c:htdocssqltest.php on line 4 ...but the first query has no result to fetch... --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9379edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #8086 Updated: query link identifiers are not usable
ID: 8086 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.3pl1 Assigned To: Comments: Update to latest version. All link identifiers has been changed from integers to resources. Previous Comments: --- [2000-12-03 10:13:26] [EMAIL PROTECTED] This report uses php 4.04 and the php_mssql70.dll extension on windows nt 4. There seem to be a problem with the functions that accept a mssql_query() link identifier as parameter. I have the followin basic script : $hdb = mssql_connect( testserver, test, testpwd ); print( hdb = $hdbbr ); print( mssql_select_db : .mssql_select_db( test_db, $hdb ).br ); $hcur = mssql_query( select * from t_test, $hdb ); print( hcur = $hcurbr ); print( mssql_num_fields : .mssql_num_fields( $hcur ).br ); print( mssql_num_rows : .mssql_num_rows( $hcur ).br ); which produces the following output : hdb = Resource id #1 mssql_select_db : 1 hcur = 1 Warning: Supplied argument is not a valid MS SQL-result resource in c:phpdefault.php4 on line 17 mssql_num_fields : Warning: Supplied argument is not a valid MS SQL-result resource in c:phpdefault.php4 on line 18 mssql_num_rows : --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=8086edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #11045 Updated: Odd MSSQL errors about 25% of the time
ID: 11045
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Operating system:
PHP Version: 4.0.5
Assigned To:
Comments:
An error in mssql_pconnect() was fixed in php 4.0.6. Please update and try again.
Previous Comments:
---
[2001-05-23 09:26:24] [EMAIL PROTECTED]
Yes, I can piece some together. Most of the stuff is seperated into different files
and classes so i'll just put examples of the database accesses in the order they
happen.
I am using ISAPI with Apache 1.3.19 and MS SQL Server 2k on Win2k Server SP1.
Hope this helps.
/* db.inc.php */
global $db_conn;
$db_conn = mssql_pconnect ('localhost', '***', '***') or printf ('Cannot
connect to SQL Server.');
mssql_select_db ('demoXpress') or printf ('Cannot select demoXpress DB.');
/* class_menu.php */
if (!empty($this-Name))
{
$sql = SELECT * FROM Menus WHERE Name='{$this-Name}';
$rs = mssql_query ($sql);
$this-Menu = mssql_fetch_object($rs);
mssql_free_result($rs);
}
/* class_newsmachine.php */
$sql = 'SELECT NewsID, News.SectionID, News.Poster, CONVERT(varchar(50),
News.PostDate, 120) AS PostDate, ';
$sql .= 'Title, Teaser, DATALENGTH(Content) AS ContentLength, News.ViewCount, ';
$sql .= 'Sections.Name, Sections.Icon, ISNULL(MessageCount, -1) AS CommentCount ';
$sql .= 'FROM News, Sections, mb_Topics ';
$sql .= 'WHERE (News.CommentID*=mb_Topics.TopicID) AND
(News.SectionID=Sections.SectionID) AND (News.FrontPage=1) ';
$sql .= 'ORDER BY News.PostDate DESC';
if (!($this-NewsRS = mssql_query ($sql, $db_conn))) echo mssql_get_last_message();
---
[2001-05-23 07:32:42] [EMAIL PROTECTED]
Could you provide some sample code ? And are you using CGI or ISAPI ?
---
[2001-05-23 04:27:43] [EMAIL PROTECTED]
Below is an example of the series of errors I get when loading a page on my website.
What is odd about it is that the errors do not always occur. About 75% of the time,
the page works perfectly. Then I'll refresh the page without even making any changes
to the source and the errors will occur. Refresh again and they disappear and the
page works.
Another interesting occurance. Sometimes, the first queries that are run will run and
complete successfully, but then a query that comes later in the source on the same
page will cause these errors.
Warning: MS SQL error: Invalid parameter in DB-LIBRARY function reference. (severity
11) in c:wwwdemoxpress.comhtmldb.inc.php on line 4
Warning: MS SQL: Unable to select database: demoXpress in
c:wwwdemoxpress.comhtmldb.inc.php on line 4
Cannot select demoXpress DB.
Warning: MS SQL error: Invalid parameter in DB-LIBRARY function reference. (severity
11) in c:wwwdemoxpress.comhtmlclass_menu.php on line 30
Warning: MS SQL: Unable to set query in c:wwwdemoxpress.comhtmlclass_menu.php on line
30
Warning: Supplied argument is not a valid MS SQL-result resource in
c:wwwdemoxpress.comhtmlclass_menu.php on line 31
Warning: Supplied argument is not a valid MS SQL-result resource in
c:wwwdemoxpress.comhtmlclass_menu.php on line 32
Warning: MS SQL error: Invalid parameter in DB-LIBRARY function reference. (severity
11) in c:wwwdemoxpress.comhtmlclass_menu.php on line 30
Warning: MS SQL: Unable to set query in c:wwwdemoxpress.comhtmlclass_menu.php on line
30
Warning: Supplied argument is not a valid MS SQL-result resource in
c:wwwdemoxpress.comhtmlclass_menu.php on line 31
Warning: Supplied argument is not a valid MS SQL-result resource in
c:wwwdemoxpress.comhtmlclass_menu.php on line 32
Warning: MS SQL: Unable to set query in c:wwwdemoxpress.comhtmlclass_newsmachine.php
on line 52
Warning: Supplied argument is not a valid MS SQL-result resource in
c:wwwdemoxpress.comhtmlclass_newsmachine.php on line 58
Warning: MS SQL error: Invalid parameter in DB-LIBRARY function reference. (severity
11) in c:wwwdemoxpress.comhtmlclass_pollbox.php on line 22
Warning: MS SQL: Unable to set query in c:wwwdemoxpress.comhtmlclass_pollbox.php on
line 22
---
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11045edit=2
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #7881 Updated: sybase-ct does not report server errors
ID: 7881
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Status: Open
Old-Bug Type: MSSQL related
Bug Type: Sybase-ct (ctlib) related
Operating system:
PHP Version: 4.0.3pl1
Assigned To:
Comments:
This is not related to the mssql extension. You are using the sybase extension.
Previous Comments:
---
[2000-11-21 16:44:45] [EMAIL PROTECTED]
Reclassify: MSSQL related (was Sybase CT Related)
---
[2000-11-19 21:39:13] [EMAIL PROTECTED]
ok, this is my php configure line:
./configure --with-apxs=/www/bin/apxs --with-sybase-ct=/opt/sybase-11.9.2
--enable-track-vars
I've got these 3 packages installed on /opt/sybase-11.9.2
sybase-ase-11.9.2-3.i386.rpm
sybase-common-11.9.2-3.i386.rpm
sybase-openclient-11.1.1-3.i386.rpm
I can query a MSSQL 7.0 server + SP2 applied with no problems, but if I ever misstype
a query php won't report the sql server error and hangs the script forever.
I strace'd apache and here are part of the results:
(the cmd used was: strace -s 128 /www/bin/httpd -X)
connect(6, {sin_family=AF_INET, sin_port=htons(1433),
sin_addr=inet_addr(200.32.xxx.xxx)}}, 16) = 0
ioctl(6, FIONBIO, [1]) = 0
ioctl(6, FIOASYNC, [0]) = 0
setsockopt(6, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
setsockopt(6, IPPROTO_TCP1, [1], 4) = 0
... some more not meaningfull sys calls.
send(6, 11
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #11188 Updated: translate national characters in freeeTDS-driver
ID: 11188 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Old-Bug Type: MSSQL related Bug Type: Sybase (dblib) related Operating system: PHP Version: 4.0.5 Assigned To: Comments: This is not related to the mssql extension. You are using the sybase extension. Previous Comments: --- [2001-05-30 04:33:07] [EMAIL PROTECTED] I have: FreeBSD-FreeTDS-MSSQL 7.0 This line mssql_query(SELECT * FROM table WHERE field='national characters') dont normal work function ascci2unicode() in FreeTDS-driver is not good!!! --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=11188edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #8349 Updated: Accessing a text field
ID: 8349 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Old-Bug Type: MSSQL related Bug Type: Sybase (dblib) related Operating system: PHP Version: 4.0.3pl1 Assigned To: Comments: This is not related to the mssql extension. You are using the sybase extension. Previous Comments: --- [2000-12-21 08:07:54] [EMAIL PROTECTED] I notice a bug in MSSQL functions. The bug is when you try to fetch a text field type from a table in MSSQL Server. It won't return any values, and even a single query it won't perform. But with other types of fields it didn't seems to has any kind of problem. If anyone that may have an idea of solving this problem, please let me know! Thank You! Felipe Almeida --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=8349edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #9171 Updated: Query Timeout
ID: 9171 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Old-Bug Type: MSSQL related Bug Type: Sybase (dblib) related Operating system: PHP Version: 4.0.0 Assigned To: Comments: This is not related to the mssql extension. You are using the sybase extension. Previous Comments: --- [2001-02-08 06:10:41] [EMAIL PROTECTED] I have install freetds-0.51 on PHP to connect to MSSQL Server. But it shows message like Can't show page in chinese. My doubt is that is it because my query result to big(300 rows) or something wrong with my configuration. Can somebody help me out?? --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9171edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #9244 Updated: sybase-ct does not report MSSQL-server errors
ID: 9244 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Old-Bug Type: MSSQL related Bug Type: Sybase (dblib) related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: This is not related to the mssql extension. You are using the sybase extension. Previous Comments: --- [2001-02-13 15:14:02] [EMAIL PROTECTED] Bug #7881, as posted by [EMAIL PROTECTED] is still present in PHP4.0.4pl1. My configuration is: Linux Mandrake 7.1, Apache 1.3.17, PHP4.0.4pl1, sybase-common-11.9.2.-3.1386.rpm, sybase-openclient-11.1.1-3.i386.rpm, SQLServer 7.0SP3 on Win2K. Sending a valid query, using mssql_query() works fine, sending an invalid query (for a table that does not exist for example), hangs the script. PHP does not timeout, the browser does eventually. For more details, see bug #7881. Thanks, Arjan --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9244edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #9402 Updated: never ending cycle
ID: 9402 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Old-Bug Type: MSSQL related Bug Type: Sybase (dblib) related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: This is not related to the mssql extension. You are using the sybase extension. Previous Comments: --- [2001-02-22 09:12:18] [EMAIL PROTECTED] When I call mssql_query and sql server error occured (for example I add a column to table, but didn't redefine view), then php script doesn't stop, but instead of that, it will wait forever. I have sybase-ct built in php (can compile stand-alone module, but can use, don't know why). I don't think that in earlier versions (4.x) was this problem, but I am not sure. Thanx for help ojo. --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9402edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #10347 Updated: Core Dump when selecting TIMESTAMP with FreeTDS and SQL Server
ID: 10347 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Old-Bug Type: MSSQL related Bug Type: Sybase (dblib) related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: This is not related to the mssql extension. You are using the sybase extension. Previous Comments: --- [2001-04-16 12:37:21] [EMAIL PROTECTED] When I try and select a TIMESTAMP column from SQL Server, php core dumps. I am using PHP 4.0.4pl1, with FreeTDS 0.51 and SQL Server 7.0 SP1 on kernel 2.2.16, glibc-2.2 Something as simple as: SELECT dateJoined FROM members; will cause a core dump The bad line in add_string_to_string is : memcpy(result-value.str.val+op1-value.str.len, op2-value.str.val, op2-value.str.len); GDB values: (gdb) print result-value.str.val+op1-value.str.len $1 = 0x81d3be2 (gdb) print op2-value.str.val $2 = 0x81d08e4 (gdb) print op2-value.str.len $3 = -1 (gdb) bt #0 0x40791ace in memcpy () from /lib/libc.so.6 #1 0x80eda9e in add_string_to_string (result=0xbfffdaa0, op1=0xbfffdaa0, op2=0x81c6c2c) at zend_operators.c:1004 #2 0x8125efe in execute (op_array=0x81c69b4) at ./zend_execute.c:1389 #3 0x812679a in execute (op_array=0x81b7d6c) at ./zend_execute.c:1559 #4 0x80f0ef8 in zend_execute_scripts (type=8, file_count=3) at zend.c:729 #5 0x8061b18 in php_execute_script (primary_file=0xb6b0) at main.c:1221 #6 0x805fcf8 in main (argc=2, argv=0xb764) at cgi_main.c:738 #7 0x40727f31 in __libc_start_main (main=0x805f434 main, argc=2, ubp_av=0xb764, init=0x805d784 _init, fini=0x81309dc _fini, rtld_fini=0x4000e274 _dl_fini, stack_end=0xb75c) at ../sysdeps/generic/libc-start.c:129 --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10347edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #11105 Updated: Does not compile MSSQL extension
ID: 11105 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.5 Assigned To: Comments: The MSSQL extension is not available on Solaris (Only windows) You could use the sybase functions together with FreeTDS and configure like this: ./configure --with-sybase=/usr/local/freetds ... The sybase extension includes functions aliases that allows you to use mssql_connect etc. but it is still the sybase functions you are calling. Previous Comments: --- [2001-05-25 00:06:34] [EMAIL PROTECTED] Compiled latest version PHP 4.05 with database extenstion mssql (./configure --with-mssql) on Sparc/Solaris 2.6 . COmpilation does not give errors , but under ext directory, under mssql subdirectory, no changes are seen at the end of compilation i.e. no object files are seen compiled . When opened up ./configure script, did not see any instance of mssql , whereas all other databases are defined. Is this a bug in ./configure script ? EWgate.com Senyong --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=11105edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #11171 Updated: Faulty MSSQL-queries locks PHP
ID: 11171 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Old-Bug Type: MSSQL related Bug Type: Sybase (dblib) related Operating system: PHP Version: 4.0.5 Assigned To: Comments: This is not related to the mssql extension. You are using the sybase extension. Previous Comments: --- [2001-05-29 11:15:03] [EMAIL PROTECTED] Bug #7881, as posted by [EMAIL PROTECTED] and bug #9244 is still present in PHP4.0.5. Setup: FreeBSD 3.4-STABLE, Apache 1.3.20, PHP4.0.5, newest SybaseOpenClient for FreeBSD (not sure of version, older doesn't work either), SQLServer 7.0SP3 on WinNT. Sending a valid query, using mssql_query() works fine, sending an invalid query (for a table that does not exist for example), hangs the script. PHP does not timeout, the browser does eventually. For more details, see bug #7881. This is very important for me to get fixed, would be happy for some information on why this happens? Thanks! Peter --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=11171edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #10177 Updated: IIS 5.0 can not start with enabled mssql70 extension
ID: 10177 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: Install the client tools for MSSQL Server before using the extension. The client tools can be installed from the MSSQL Server CD or by copying the file ntwdblib.dll to \winnt\system32. Previous Comments: --- [2001-04-05 05:29:46] [EMAIL PROTECTED] Steps I do: 1. PHP is working as an ISAPI without mssql70 extension. In php.ini: ;extension=php_mssql70.dll 2. Set in php.ini mssql70 extension: extension=php_mssql70.dll 3. When I try to restart World Wide Web Publishing Service it displays an error message - Service cannot be started and its status goes 'Starting' 4. If I disable mssql70 extension in php.ini and reboot computer, PHP works again. --- [2001-04-05 05:02:35] [EMAIL PROTECTED] Please provide more information, about what error's you get, the output of your phpino(); (on a website if that's possible) and your php.ini file (and the location on your filesystem of it). --- [2001-04-05 03:42:20] [EMAIL PROTECTED] --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10177edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #9855 Updated: Return column data with correct type
ID: 9855 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: Update to php4.0.6, and you will find what you are asking for. The setting mssql.compatability_mode in php.ini can be used to specify how data are returned. mssql.compatability_mode = Off Returns data as php types mssql.compatability_mode = On Returns all data ass strings. Previous Comments: --- [2001-03-20 00:04:07] [EMAIL PROTECTED] Suggestion: Add new data retrieval functions (or extend mssql_fetch_array and mssql_fetch_row) to return each column in a type that matches the underlying database column type instead of the always as type string. Also, return columns that are NULL as PHP's null type (instead of boolean/false). Two questions - is this the proper place to submit suggestions, and if so should this also be submitted to the general 'database functions' category (I know PHP's ODBC functions exhibit the same behavior)? --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9855edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #9854 Updated: Empty strings get returned as single spaces
ID: 9854 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: Handling of NULL columns is fixed in php 4.0.6 Previous Comments: --- [2001-03-19 23:45:28] [EMAIL PROTECTED] Add'l info: Web Server: Win2000 Server SP1 IIS 5.0 PHP 4.0.4pl1 Database Server: WinNT SP6 MSSQL 7.0 --- [2001-03-19 23:42:49] [EMAIL PROTECTED] mssql_fetch_array (and mssql_fetch_row) return a single space for columns that contain an empty string (as opposed to columns that contain NULL). --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9854edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #9438 Updated: Error retrieving image field from MSSQL database
ID: 9438
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Operating system:
PHP Version: 4.0.4pl1
Assigned To:
Comments:
Handling of binary data is changed for php4.0.6. Please update and try again.
Previous Comments:
---
[2001-02-24 20:27:09] [EMAIL PROTECTED]
When I try to retrieve image field from MSSQL7 database I get PHP has encountered an
Access Violation at 77FCA9EA and all PHP engine becomes unstable after this. The
script is very simple:
?
include(msdb.php);
$id=$HTTP_GET_VARS[id];
$rs=mssql_query(select Image from SpecBannerData where SpecBannerID= .
$id,$conn);
$arr=mssql_fetch_row($rs);
if ($arr)
{
header( Content-type: image/jpg);
echo $arr[0];
}
?
msdb.php:
?
$conn=mssql_connect(127.0.0.1,sa,);
if (!$conn)
{
echo (Can not connect to the database);
}
if (!mssql_select_db(metasearch,$conn))
{
echo (Can not connect to the database);
}
?
I'm quite new in PHP, but I met some other people report the same problems in
PHP-related forums. I used only precompiled PHP modules downloaded from php.net.
Best regards,
Leonid Freidin
---
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=9438edit=2
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #10889 Updated: mssql_fetch_array - IDENTITY values returned as string with padded NULL chars
ID: 10889 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.5 Assigned To: Comments: Update to php 4.0.6, and use the php.ini setting mssql.compatability_mode = Off to specify that you will have all data returned as php types. Previous Comments: --- [2001-05-15 17:03:54] [EMAIL PROTECTED] OS = Windows 2000 Server = IIS 5.0 Database = SQL Server 7 PHP = 4.0.5 To reproduce 1. Create a table as such: CREATE TABLE table1 ( row_id NUMERIC(9,0) IDENTITY, col1 INT NOT NULL, col2 INT NULL, col3 VARCHAR(25) NULL, PRIMARY KEY(row_id) ) GO 2. Insert a row: INSERT INTO table1 (col1) VALUES(1) GO 3. Now fetch that row ?php $hostname = your hostname here; $username = your username here; $password = your password here; $dbName = your database name here; // Connect $connectionID = mssql_connect($hostname, $username, $password); $retval = mssql_select_db($dbName); // Query $query = SELECT row_id, col1, col2, col3 from table1 $queryID = mssql_query($query, $connectionID) // Fetch fields $fields = mssql_fetch_array($queryID); list($row_id, $col1, $col2, $col3) = $fields; echo type = . gettype($row_id) . br; echo strlen($row_id) = . strlen($row_id) . br; echo bin2hex($row_id) . br; mssql_close($connectionID); ? 3. Results Did yours match mine? My result from bin2hex is 31 The character 1, followed by 19 nulls! --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10889edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #7088 Updated: mssql_fetch_row
ID: 7088 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.2 Assigned To: Comments: This is not a bug in the php extension, but a limmitation in the libraries provides by Microsoft. Previous Comments: --- [2000-11-10 01:36:49] [EMAIL PROTECTED] Use TEXT can fetch larger then 255 chars.But it still not be able to fetch as long as 2000 chars field. --- [2000-10-20 16:30:27] [EMAIL PROTECTED] The DB libray from Microsoft does not support the NCHAR datatype. is is converted to and handled as a CHAR with the maximum length of 255 bytes. Use TEXT type. it will work. I'll report the error to Microsoft. --- [2000-10-08 12:34:09] [EMAIL PROTECTED] when fetch a char field,it can not fetch more than 255 char in a field. --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=7088edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #8398 Updated: Php can not get any message from RAISEERROR
ID: 8398
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MSSQL related
Operating system:
PHP Version: 4.0.4
Assigned To:
Comments:
Could you provide some saple code.
When I do a mssql_query(RAISERROR ('Test', 15, 1) with nowait);
I get the error message right away.
Previous Comments:
---
[2000-12-24 03:24:08] [EMAIL PROTECTED]
Even I try Rasinerrorwith nowait
the error_level is bigger that 10.
The message will apear as php warning when scripts end.
Same level error generated by server will be retrieved at once.
---
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=8398edit=2
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #8642 Updated: mssql fetch array bug
ID: 8642
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Operating system:
PHP Version: 4.0.4
Assigned To:
Comments:
This error can not be reproduces with php 4.0.6. PLease update to the latest version.
Previous Comments:
---
[2001-01-12 16:06:25] [EMAIL PROTECTED]
reclassifying
---
[2001-01-10 16:12:26] [EMAIL PROTECTED]
If you run mssql_fetch_array on the same table more than once the script will never
finish.
If you use mssql_fetch_row is works fine.
?
$sql1 = select price from vw_items where item like '30482-__' order by item;
$result1 = mssql_query($sql1);
while ($row1 = mssql_fetch_array($result1)) {
$price = $row1[price];
echo $$price;
}
mssql_free_result($result1);
Echo NEW ONE;
$sql2 = select price from vw_items where item like '30403-__' order by item;
$result2 = mssql_query($sql2);
while ($row2 = mssql_fetch_array($result2)) {
$price = $row2[price];
echo $$price;
}
mssql_free_result($result2);
?
---
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=8642edit=2
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #11045 Updated: Odd MSSQL errors about 25% of the time
ID: 11045 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MSSQL related Operating system: PHP Version: 4.0.5 Assigned To: Comments: Could you provide some sample code ? And are you using CGI or ISAPI ? Previous Comments: --- [2001-05-23 04:27:43] [EMAIL PROTECTED] Below is an example of the series of errors I get when loading a page on my website. What is odd about it is that the errors do not always occur. About 75% of the time, the page works perfectly. Then I'll refresh the page without even making any changes to the source and the errors will occur. Refresh again and they disappear and the page works. Another interesting occurance. Sometimes, the first queries that are run will run and complete successfully, but then a query that comes later in the source on the same page will cause these errors. Warning: MS SQL error: Invalid parameter in DB-LIBRARY function reference. (severity 11) in c:wwwdemoxpress.comhtmldb.inc.php on line 4 Warning: MS SQL: Unable to select database: demoXpress in c:wwwdemoxpress.comhtmldb.inc.php on line 4 Cannot select demoXpress DB. Warning: MS SQL error: Invalid parameter in DB-LIBRARY function reference. (severity 11) in c:wwwdemoxpress.comhtmlclass_menu.php on line 30 Warning: MS SQL: Unable to set query in c:wwwdemoxpress.comhtmlclass_menu.php on line 30 Warning: Supplied argument is not a valid MS SQL-result resource in c:wwwdemoxpress.comhtmlclass_menu.php on line 31 Warning: Supplied argument is not a valid MS SQL-result resource in c:wwwdemoxpress.comhtmlclass_menu.php on line 32 Warning: MS SQL error: Invalid parameter in DB-LIBRARY function reference. (severity 11) in c:wwwdemoxpress.comhtmlclass_menu.php on line 30 Warning: MS SQL: Unable to set query in c:wwwdemoxpress.comhtmlclass_menu.php on line 30 Warning: Supplied argument is not a valid MS SQL-result resource in c:wwwdemoxpress.comhtmlclass_menu.php on line 31 Warning: Supplied argument is not a valid MS SQL-result resource in c:wwwdemoxpress.comhtmlclass_menu.php on line 32 Warning: MS SQL: Unable to set query in c:wwwdemoxpress.comhtmlclass_newsmachine.php on line 52 Warning: Supplied argument is not a valid MS SQL-result resource in c:wwwdemoxpress.comhtmlclass_newsmachine.php on line 58 Warning: MS SQL error: Invalid parameter in DB-LIBRARY function reference. (severity 11) in c:wwwdemoxpress.comhtmlclass_pollbox.php on line 22 Warning: MS SQL: Unable to set query in c:wwwdemoxpress.comhtmlclass_pollbox.php on line 22 --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=11045edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #10980 Updated: mssql query error
ID: 10980
Updated by: fmk
Reported By: [EMAIL PROTECTED]
Status: Open
Old-Bug Type: MSSQL related
Bug Type: ODBC related
Operating system:
PHP Version: 4.0.4pl1
Assigned To:
Comments:
ODBC related should not be reported as MSSQL related.
Furthermore I think we need some more information about this error.
Are you getting other results than expected ? What is 'result' ? You dont have any
variables in the code with that name.
If 'result' is the output from odbc_num_rows() we need to know the structure of the
table and what you expect from your data.
Previous Comments:
---
[2001-05-21 02:57:59] [EMAIL PROTECTED]
//error source
$connid=odbc_connect('odbc_db','odbc_user','odbc_pswd');
$sql='select id from bt_article where id978';
$row=odbc_do($connid,$sql);
echo odbc_num_rows($row);
//result -1
//if $sql='select title from bt_article where id978 order by id';
//result is ok
//if $sql='select title from bt_article where id=978 order by id';
//result -1
---
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10980edit=2
--
PHP Development Mailing List http://www.php.net/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DEV] Bug #10621 Updated: Unable to load php_gd.dll
ID: 10621 Updated by: fmk Reported By: [EMAIL PROTECTED] Status: Open Bug Type: Dynamic loading PHP Version: 4.0.5 Assigned To: Comments: did you update php_gd.dll as well. Dll's are build to be used with a specific version of php. If you update php.exe, php4ts.dll and php4isapi.dll you have to update your extensions as well. Previous Comments: --- [2001-05-02 17:51:54] [EMAIL PROTECTED] Today, I installed PHP 4.0.5 and conrigured it correctly. I asked him to load the extensions that PHP 4.0.4 was used to load... I got an error Unable to load I just can't understand... With PHP 4.0.4 it was OK, and now, with 4.0.5, it doesn't work... WHY? Hubert L. --- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10621edit=2 -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
