Re: [PHP-DB] Re: Error

2007-06-26 Thread Roberto Mansfield
putenv() never works well with oracle vars. They need to be set for the account running the web server. When the web server starts, it will inherit the oracle vars from the environment. David Skyers wrote: > Hi > > I have tried adding the following line to my php page. This causes the > php page

RE: [PHP-DB] Re: Error

2007-06-26 Thread David Skyers
Hi I have tried adding the following line to my php page. This causes the php page to fail. putenv("NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1"); I have tried adding $oci=oci_pconnect($user, $pass, $db,'WE8ISO8859P1'); I don't believe the error is due to character sets. I believe it is a problem w

Re: [PHP-DB] Re: Error Loading File <-- Sort of Fixed

2002-06-13 Thread Bryan Gintz
Ok, if anyone else is having the same trouble with PHP 4.2.1, David Robley's suggestion (Thank you David!) works. I am not to proud to have missed the obvious :) If you are having trouble loading files (LOAD INFILE...) with PHP into MySQL, just do a chmod($file, 0777), and it works. Not sure

Re: [PHP-DB] Re: Error Loading File

2002-06-12 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Whoops :), > Yes, this is using phpMyAdmin, trying to use the "Insert data from a > textfile into table" function, which uploads a file and the attempts to > LOAD DATA INFILE. Like I said below, it worked on PHP 4.1.2, then when > upg

Re: [PHP-DB] Re: Error Loading File

2002-06-12 Thread Bryan Gintz
Whoops :), Yes, this is using phpMyAdmin, trying to use the "Insert data from a textfile into table" function, which uploads a file and the attempts to LOAD DATA INFILE. Like I said below, it worked on PHP 4.1.2, then when upgraded to PHP 4.2.1, it gave the error : "The file '/tmp/phpr4WYQY'

Re: [PHP-DB] Re: Error creating new table

2002-04-08 Thread Lisi
For the record, the problem was assigning a length to a text field. The NOT NULL part is fine. Thanks everyone for your input! -Lisi At 04:59 PM 4/8/02 -0700, Jennifer Downey wrote: >I to have about 16 text fields in my db that are NOT NULL and they work >fine. >Just an observation. > >Jenni