AW: [PHP-DB] php, OCI and datatypes

use the display sourcecode function of your browser, it is more reliable than the output. try to get the char column with ocifetch($stmt); $charcol = ociresult($stmt, "nameofcharcol"); maybe your using [] the wrong way so you are getting the chars of the string instead of the strings in the

AW: [PHP-DB] How can I have connection pooling in PHP?

you can use persistent connections or you can have the db-Environment do that for you, e.g. COnnectionManager or ConenctionPooling of oracles NET8 mk -Ursprngliche Nachricht- Von: Christopher Cheng [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 14. Februar 2001 11:27 An: [EMAIL

[PHP-DB] MySQL Database Design

If was to create a table in a database with 19 Fields, and define them all as a BLOB, even though some of them may only hold a max of 10 characters. What would be the implications of this? -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail:

[PHP-DB] Apache, PHP4, access problem to MS SQL 7.0

Can anybody help me about my serious problem to connect to MS SQL 7.0. I tried to use the freetds-driver but i'm not able to connect with it. They said that I must define the Serverconnection in the interfaces-file. I found one in the freetds-directory but i don't know how to write it correct.

Re: [PHP-DB] mysql access

What about... GRANT ALL PRIVILEGES ON *.* TO user@"%" IDENTIFIED BY 'user_pass' WITH GRANT OPTION make also this for localhost... GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'user_pass' WITH GRANT OPTION By the way, RTFM ;-) Vojta hi all... can you tell me how can i grant

Re: [PHP-DB] number formatting

Hi, I have a problem with numer formatting. I want to have string from my numbers that have thousands separator '.', decimal separator ',' and fixed n decimal digit. example: num: 1285.3string 1.285,3 num: 12.1string 12,10 etc. Is there some php function to do this? Thanks

[PHP-DB] sorting and links

OK, I'm sure that the answers are extremely simple, but I'm having two problems. 1. How do I sort a list through PHP alphabetically? This is a drop-down menu full of part numbers and it's a pain in the neck to search for the right one through about a thousand of them. Currently, the sort

Re: AW: AW: [PHP-DB] php, OCI and datatypes

Ok, thanks all for the advices. The problem is linked with the NLS parameters. Here are my database related param: NLS_LANGUAGE=French NLS_TERRITORY=France NLS_DATE_LANGUAGE= french NLS_DATE_FORMAT = dd/mm/ I change my query : select CHAR_COL . into select convert(CHAR_COL,

Re: AW: AW: [PHP-DB] php, OCI and datatypes

On Thu, Feb 14, 2002 at 04:23:23PM +0100, dsi safir wrote: Ok, thanks all for the advices. The problem is linked with the NLS parameters. Here are my database related param: NLS_LANGUAGE=French NLS_TERRITORY=France NLS_DATE_LANGUAGE= french NLS_DATE_FORMAT = dd/mm/ set

Re: [PHP-DB] number formatting

This is not what I want. I want only remove the right zeros, that is: $a = 2.1; number_format($a, 2, ",", "."); // 2,10 I want to display 2,1 $a = 2.00; number_format($a, 2, ",", "."); // 2,00 I want to display 2 $a = 2.46; number_format($a, 2, ",", "."); // 2,46 this is ok I want to display

Re: [PHP-DB] PHP4/Apache on Win95 to remote Oracle

Hi Stas, I already tried that solution to no avail... Later, Jorge Hello, "Jorge Santos"! You wrote: $connect = OCIPLogon ("MDC", "MDC", $tns) or die ("It's not possible to connect"); Try to put "MDC6" as your 3rd parameter in OCIPLogon call. I mean if you connect as MDC/MDC@MDC6

[PHP-DB] Qoute problem

Hi! I was hoping that someone could help me out. I am not positive if I understand whats going on.. so let me try to explain. This is a process to modify news articles in a MySQL database. (From the point after picking the article to modify) PHP Script #1: I grab everything from the database

[PHP-DB] MySQL and XML

Does MySQL 3 have XML support, or do I need to write (or find) a class to transform MySQL databases into XML documents? -- 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

Re: [PHP-DB] Apache, PHP4, access problem to MS SQL 7.0

Can anybody help me about my serious problem to connect to MS SQL 7.0. I tried to use the freetds-driver but i'm not able to connect with it. They said that I must define the Serverconnection in the interfaces-file. I found one in the freetds-directory but i don't know how to write it

RE: [PHP-DB] subtotal

There is a ROUND function in MySQL...try this: $totalsql = "SELECT ROUND(SUM(total),2) FROM entry WHERE user_id='$passedid'"; $totalresult = mysql_query($totalsql); $totalrow = mysql_fetch_array($totalresult); print "PTotal : $totalrow[0]/P"; --Mike Norton -Original Message- From:

[PHP-DB] Undefined Variable and argument not valid . . .

Could someone please give me some direction on what is wrong with what I am trying to do below. I've checked it over but still get the same errors. What I'm trying to do is have a list of links that display information when you click them. I'm getting the following error at the top of the first

[PHP-DB] Oracle, Stored Procedure Out Variable confusion

confusion: Using PHP 4.0.3pl1 with oci8 libraries and Oracle 8.1.6 there seems to be problem when retrieving OUT-Variables from stored procedure, bind to a variable. for example i got an error retrun value (parsed to SQL as :1 and bind to $error with a buffer of 4) it could !! happen that

[PHP-DB] RE : Bug #9125: image file corrupted when upload

Try this it worked for me : http://bugs.php.net/bugs.php?id=9014edit=2 This new rpm correct the bug Olivier JOUBERT Hbergement web et tlmatique RFI Informatique, Groupe YONI Socit de Service et d'Ingnierie en Informatique et