Re: [PHP-DB] PHP and OCI NLS behaviour

2002-04-16 Thread Graeme Merrall
Rouvas Stathis wrote: Hi, place appropriate NLS_LANG definitions in the Apache startup script (/etc/rc.d/apache ?). As a background to this, it's essential to do this because certain things happen when the module is initialised in PHP. Hence if you use putenv() to alter some Oracle

RE: [PHP-DB] Help -- Oracle

2002-01-24 Thread Graeme Merrall
Help, i'm trying to connect to a remote oracle database from win98/apache/php4 and win2k/iis/php4 but it always gives me tns error. Other apps however, works fine with the tns configuration. the php oracle module was loaded successfully on both platforms. I've tried all sorts of

Re: [PHP-DB] Oracle Oci*Logon

2001-08-21 Thread Graeme Merrall
Quoting Andrey Hristov [EMAIL PROTECTED]: Can someone tell more about OciPLogon. I'm sure Theis will add to this but here goes... :) I know that OciLogon is used frequently but the connection to the DB is shared amongst the pages so as in the common way where every page in a site uses

Re: [PHP-DB] oracle (oci8) intro

2001-08-19 Thread Graeme Merrall
Quoting Cynic [EMAIL PROTECTED]: Hi there, I'm in a situation where I need to produce a small app on top of an Oracle server really quickly. I'm quite a seasoned developer, but have only experience with MySQL so far. It's my understanding that Oracle lacks the MySQL's LIMIT feature.

Re: [PHP-DB] OCIDefineByName/OCIBindByName help?

2001-08-13 Thread Graeme Merrall
Quoting Barry Prentiss [EMAIL PROTECTED]: Hi, Can anyone help me to understand the OCIBindByName/OCIDefineByName functionality when used with the Oracle 'returning' clause? These two functions are seriously under-documented at PHP.net. I need the sequence-generated ID created during an

Re: [PHP-DB] OCIDefineByName/OCIBindByName help?

2001-08-13 Thread Graeme Merrall
Quoting Barry Prentiss [EMAIL PROTECTED]: Hi, Can anyone help me to understand the OCIBindByName/OCIDefineByName functionality when used with the Oracle 'returning' clause? These two functions are seriously under-documented at PHP.net. I need the sequence-generated ID created during an

RE: [PHP-DB] MSSQL: Spaces in database name

2001-08-08 Thread Graeme Merrall
Quoting Robert D. Young [EMAIL PROTECTED]: That did it! Using: ... stuff $dbname = [Test Database]; ... more stuff mssql_select_db($dbname); worked perfectly. Again, Thanks! This is standard Microsoft (and maybe ODBC?) syntax. Using square brackets will work on most things

RE: [PHP-DB] ORACLE 8 randomly unsucessful execution

2001-06-23 Thread Graeme Merrall
Do you get an Oracle error code back? What version of PHP are you using? Cheers, Graeme -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ludo Sent: Saturday, 23 June 2001 1:31 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] ORACLE 8 randomly

[PHP-DB] RE: Informix user wierdness

2001-04-01 Thread Graeme Merrall
This is more an Informix question rather than a PHP question but I hope someone can help I've installed the Linux-SE version and CSDK of Informix from informix.com and installation has gone fine including createing the demo DB. I can also start 'dbaccess' and browse/query the tables so the

[PHP-DB] Informix user wierdness

2001-03-31 Thread Graeme Merrall
This is more an Informix question rather than a PHP question but I hope someone can help I've installed the Linux-SE version and CSDK of Informix from informix.com and installation has gone fine including createing the demo DB. I can also start 'dbaccess' and browse/query the tables so the

[PHP-DB] pg_put_line and file()

2001-01-27 Thread Graeme Merrall
Hi. I was tinkering around with pg_put_line and pg_end_copy and rather than inserting data from a variable as per the example, I was wondering if it was posible to insert the data from a delimited file via these two functions. I produced a dump from postgres and tried inserting the data raw $text