RE: [PHP-DB] PHP on WIN32 with DB2 CLI
Well in linux I use the CLI interface from php to run all my queries. I read somewhere that the native CLI interface was faster than using the ODBC driver. I have the ODBC driver working properly, I just wanted to know if it was possible to use CLI with PHP in windows (like on Linux). I guess I'll just stick with ODBC. Thanks, Chris Book [EMAIL PROTECTED] -Original Message- From: Dan Scott [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 01, 2001 11:40 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP on WIN32 with DB2 CLI Actually, CLI is almost function-for-function the same as ODBC. The PHP implementation of ODBC is quite a simplified version, but it covers most of the basic function. Chris, what is it that you are trying to do, specifically? Dan Phil Jackson wrote: Chris - I think to use DB2's CLI interface, you need a compiled langauge, like some flavor of C++ or VB. I've seen some examples using the CLI interface, so my question is why on earth would you chose that over generic ODBC? That CLI is nasty-looking, pages of code versus what you can do in a few lines with ODBC.. - but I have a project using both DB2 on a mainframe and DB2 UDB - so I am very interested in your thoughts on all this! Phil J. Chris Book wrote: Hi, I've compiled php before with --with-ibm-db2 to use DB2's CLI driver. Now I'm working on NT with the php binary, and I can't figure out how to connect to DB2 except with ODBC. I would prefer to use the CLI interface than an ODBC interface. Is this possible or am I stuck with ODBC on NT? Thanks, Chris Book [EMAIL PROTECTED] -- PHP Database 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 Database 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-DB] PHP on WIN32 with DB2 CLI
Hi, I've compiled php before with --with-ibm-db2 to use DB2's CLI driver. Now I'm working on NT with the php binary, and I can't figure out how to connect to DB2 except with ODBC. I would prefer to use the CLI interface than an ODBC interface. Is this possible or am I stuck with ODBC on NT? Thanks, Chris Book [EMAIL PROTECTED] -- PHP Database 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]
RE: [PHP-DB] IBM DB2 connectction problems
If you're running off a unix platform, did you bind your database to CLI? I'm assuming you're trying to connect with CLI and not ODBC (ie you compiled with --with-ibm-db2) Chris -Original Message- From: ManieQ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 7:07 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] IBM DB2 connectction problems hello, $i = odbc_connect( "sample", "db2inst1", "ibmdb2" ); I changed, but got same (= none) result. Please provide more detailed information on the SQL error and SQL state. Otherwise it is not really easy to tell, what the problem is. Well, as I posted, my SQL error is null and state is random/accidental string. I wonder if it is a version problem (I use db2 v7.1 - perhaps some api changes were made in this release?). ManieQ -- PHP Database 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]
RE: [PHP-DB] retrieval of NEXT, PREV records
you have to make sure you order by Rec_id all the time too. -Original Message- From: JJeffman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 4:39 PM To: Adv. Systems Design; [EMAIL PROTECTED] Subject: Re: [PHP-DB] retrieval of NEXT, PREV records "SELECT * FROM Table WHERE Rec_id $recid LIMIT 1" always bring you the next record no matter the Rec_id is. HTH Jayme. -Mensagem Original- De: Adv. Systems Design [EMAIL PROTECTED] Para: [EMAIL PROTECTED] Enviada em: tera-feira, 20 de fevereiro de 2001 11:41 Assunto: [PHP-DB] retrieval of NEXT, PREV records I have set up links to browse records one by one, using (ID+1) for NEXT and (ID-1) for PREV...the only problem is that if there is a hole in the ID sequence (as from DELETION), there is no record returned...How can I have it so that the 'holes' are paved over and not returned? TIA Luis __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- PHP Database 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 Database 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]