Re: [PHP-DB] mysql_connect dies silently

2004-09-14 Thread Mulo Emmanuel
Did not see any attachment...? The upgrade might have been the problem. You might need to recompile or reinstall php... Christian Schlaefcke wrote: This looks like it is enabled. I recently upgraded mysql to version 4.1.4. Maybe this causes the problem. Do I have to reinstall PHP it is still

[PHP-DB] Good PHP + MySQL Organizer

2004-09-14 Thread Martin Lam
Hi, Like phpBB for newsgroups, phpMyAdmin for database administration. Is there one for Organizer? Please advise! Thanks, Martin Lam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP 5 Error Handling

2004-09-14 Thread Joseph Crawford
Guys, i have been working with custom exception classes that extend the general exception. Here is some code i have public function command($cmd) { if($cmd) { $res = fputs($this-connection, $cmd); $this-response =

[PHP-DB] MSSQL FOR XML AUTO php

2004-09-14 Thread Bozhan Boiadzhiev
Hello i have such problem Executing this script php code: ?php session_start(); include ../msdb_conn.php; $stmt_page=mssql_init(GET_RESUME_AS_XML); mssql_bind($stmt_page,RETVAL,$returnval,SQLVARCHAR); $execute_stmt=mssql_execute($stmt_page); echo mssql_num_rows($execute_stmt); do {

Re: [PHP-DB] MSSQL FOR XML AUTO php

2004-09-14 Thread Robert Twitty
HI Bozhan When you append the FOR XML clause at the end of a query, the xml data will be sent in a single column result set. The column's type is ntext, which is not easily handled by FreeTDS and PHP. The reason is because it is UC2-2 encoded UNICODE text. UNICODE text is easier to deal with if

[PHP-DB] MySql Client API still old version

2004-09-14 Thread squirrel
After installing MySQL 4.1.4-gamma, phpinfo() shows MySql client API v3.23.49 and it needs to be updated to 4.1. But I can't seem to get it updated. Please help. I recompiled with: ./configure --with-mysql=/usr/local/mysql --with-apache=../apache_1.3.31 make clean make make test make

Re: [PHP-DB] MSSQL FOR XML AUTO php

2004-09-14 Thread Bozhan Boiadzhiev
Thanks Robert but one thing i can't understand. As you can see in my first message freetds log contains such thing: -- 19:32:55.245996 tds_put_string converting 23 bytes of exec GET_RESUME_AS_XML1

Re: [PHP-DB] MSSQL FOR XML AUTO php

2004-09-14 Thread Bozhan Boiadzhiev
HAHAHAHA i am so sorry this is so called problem infornt of computer. i didn't look in source of page and becouse of XML it isn't shown in page. Very sorry Thanks Bozhan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Sybase Peristent Connections Gotchas

2004-09-14 Thread Brian Foddy
I've been using PHP4/5 and Sybase for several years, using standard sybase_connect. Today I tried playing around with pconnect to get aquainted. I expected one simple condition of a use database from one web page affecting another, and easilly handled that with a connection wrapper that re-uses

Re: [PHP-DB] MySql Client API still old version

2004-09-14 Thread Mikhail U. Petrov
1. Did you install MySQL-client or only MySQL-server? 2. Do you think I'm a telepath? Please, if you want good answers, tell, at least, your OS and PHP version. I can't help you without any information. 3. You choose wrong maillist for this question. Here are many php-programmers, but not

Re: [PHP-DB] Please help

2004-09-14 Thread Micah Stevens
WHERE columname LIKE condition ^^^ example. On Friday 10 September 2004 10:22 am, Stuart Felenstein wrote: Okay, I was under the impression that where is implied inthe joins xx.xx = xx.xx . Is that not the case ? As a matter of fact, there isn't even a where or like in my query.

Re: [PHP-DB] Help please, back to an error

2004-09-14 Thread Micah Stevens
I'm thinking you should either get a better code generator, or learn more about php.. :) -Micah On Monday 13 September 2004 02:49 pm, Stuart Felenstein wrote: Thanks to help here I was able to overcome some ivalid query errors. Now I'm back, (probably the same mistake) It's coming off

Re: [PHP-DB] php and oracle

2004-09-14 Thread Christopher Jones
Dieter, Can you share some of your migration experiences? Why did you migrate to Oracle and what problems did you face? Miscellaneous thoughts follow: Regarding the error, search the bdump trace files for 3114 or other ORA-xyz errors. You may need to get Oracle Support involved if there are any.

[PHP-DB] Accessing Matisse DB

2004-09-14 Thread Petrus Ali Saputra
Is there anyone here can tell me how to access Matisse DB? Thank you. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Sybase Peristent Connections Gotchas

2004-09-14 Thread Jeff Moss
The biggest problem I've had with persistent connections is the problems that arise when the connection goes down. You have to monitor the connection status anyways (and reconnect on a failure), so it was usually easier to just connect every time. I don't know if this is specific to sybase.