Hi
I have a page that inserts data into a oracle table using a oracle
stored procedure via php. However when the php runs I get the following
error:
Warning: oci_execute() [function.oci-execute]: ORA-06550: line 2, column
7: PLS-00553: character set name is not recognized ORA-06550: line 0,
If I have a SQL statement using the IN clause, how do I keep the order
of the list?
Example:
SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2, 8, 6))
How would I pull records in the order of the numbers to list out as:
5 - Record 5
9 - Record 9
3 - Record 3
4 - Record 4
1 - Record 1
7
By the way, I want the numbers to list out in the order I have them in
the statement, not numerically and not randomly like it does now.
Thanks...
Bryan wrote:
If I have a SQL statement using the IN clause, how do I keep the order
of the list?
Example:
SELECT * FROM table WHERE (number in
Thanks to Benno Rem for pointing out the ORDER BY FIELD(..) that one can
use in MySQL. Now to find a way to use it in MSSQL 2000. Wrong group for
that I guess. 8-O
Bryan wrote:
By the way, I want the numbers to list out in the order I have them in
the statement, not numerically and not
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
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 to
u can use array
put all your data into array.. example below
while($tmp=mysql_fetch_array($res)){
$myData[$tmp[0]]=$tmp[1];
}
ksort($myData);
foreach($myData as $nm=$val){
//put your script here..
}
- Original Message -
From: Bryan [EMAIL PROTECTED]
To: php-db@lists.php.net