[PHP-DEV] Bug #15013: String length restriction in mssql functions

[blakjak]

From: [EMAIL PROTECTED]
Operating system: Win2k
PHP version:  4.1.0
PHP Bug Type: Feature/Change Request
Bug description:  String length restriction in mssql functions

I read in the response to a previous bug report that the mssql extension
doesn't support varchar or char columns larger than 255 characters.

My request is that the extension be updated to cope with the 8KB maximum
in SQL Server.

Please.

BJ
-- 
Edit bug report at: http://bugs.php.net/?id=15013edit=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 #14119: Spelling error on manual page mysql_result

[blakjak]

From: [EMAIL PROTECTED]
Operating system: RHL 6.1
PHP version:  4.0.6
PHP Bug Type: Documentation problem
Bug description:  Spelling error on manual page mysql_result

On the manual page for the MySQL function mysql_result, in the first
paragraph after the function definition, you'll find the phrase

..., or the field's table dot field's name (tabledname.fieldname).

The first error is the stray lowercase d in the middle of tablename.

The second error is grammatical - field's table dot field's name has one
possession too many.  You could rephrase it to field's table dot field
name.

Sincerely,
BJ
-- 
Edit bug report at: http://bugs.php.net/?id=14119edit=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 #14091: Problem with main example on the MySQL Functions page

[blakjak]

From: [EMAIL PROTECTED]
Operating system: RHL 6.1
PHP version:  4.0.6
PHP Bug Type: Documentation problem
Bug description:  Problem with main example on the MySQL Functions page

On the LV. MySQL Functions page of the PHP Manual, there is a piece of
example code, demonstrating how to connect to MySQL, send a query and
output the result of that query.  The part I'm concerned about goes like
this:

print table\n;
while ($line = mysql_fetch_array($result)) {
print \ttr\n;
while(list($col_name, $col_value) = each($line)) {
print \t\ttd$col_value/td\n;
}
print \t/tr\n;
}
print /table\n;

When I reproduced this example, something went wrong.  Specifically, every
value was printed twice.  I'll elaborate on that - If my source table
looked like this:

id   name
-
1blah
2foo
3bar

Then the above code produced:

1  1  blah blah
2  2  foo  foo
3  3  bar  bar

My guess is that, because mysql_fetch_array supplies BOTH associative and
numerical indexes, using the while(list = each) format references two
key/value pairs for every one.

When I used mysql_fetch_assoc instead of mysql_fetch_array, the example
worked perfectly.  I assume that it would also work if you specified
MYSQL_ASSOC or MYSQL_NUM for mysql_fetch_arry, but I haven't tested it.

Feel free to email me if you need more detailed information.

Sincerely,
BJ
-- 
Edit bug report at: http://bugs.php.net/?id=14091edit=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]