[PHP-DB] Error
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, column 0: PL/SQL: Compilation unit analysis terminated in /nfs/rcs/www/webdocs/research/rsr/staff/dev/rae-mypubs1.php on line 121 Does anyone know why this is occurring? Regards David
[PHP-DB] IN clause
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 - Record 7 2 - Record 2 8 - Record 8 6 - Record 6 Thanks so much... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: IN clause
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 (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 - Record 7 2 - Record 2 8 - Record 8 6 - Record 6 Thanks so much... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: IN clause
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 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 (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 - Record 7 2 - Record 2 8 - Record 8 6 - Record 6 Thanks so much... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Error
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 with binding parameter to oracle procedures in php. If I remove the binding the procedure works. If I add it it fails. Any ideas David -Original Message- From: Roberto Mansfield [mailto:[EMAIL PROTECTED] Sent: 26 June 2007 16:09 To: php-db@lists.php.net Subject: [PHP-DB] Re: Error This could be a problem with your ORACLE_HOME and/or NLS_LANG environment variables. These need to be set for your user account running the web server BEFORE the web server is started. Don't try to set these in your php script or you'll get strange results. David Skyers wrote: 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, column 0: PL/SQL: Compilation unit analysis terminated in /nfs/rcs/www/webdocs/research/rsr/staff/dev/rae-mypubs1.php on line 121 Does anyone know why this is occurring? Regards David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Error
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 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 with binding parameter to oracle procedures in php. If I remove the binding the procedure works. If I add it it fails. Any ideas David -Original Message- From: Roberto Mansfield [mailto:[EMAIL PROTECTED] Sent: 26 June 2007 16:09 To: php-db@lists.php.net Subject: [PHP-DB] Re: Error This could be a problem with your ORACLE_HOME and/or NLS_LANG environment variables. These need to be set for your user account running the web server BEFORE the web server is started. Don't try to set these in your php script or you'll get strange results. David Skyers wrote: 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, column 0: PL/SQL: Compilation unit analysis terminated in /nfs/rcs/www/webdocs/research/rsr/staff/dev/rae-mypubs1.php on line 121 Does anyone know why this is occurring? Regards David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] IN clause
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
Sent: Tuesday, June 26, 2007 8:01 PM
Subject: [PHP-DB] IN clause
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 - Record 7
2 - Record 2
8 - Record 8
6 - Record 6
Thanks so much...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
