[PHP-DB] OCIExecute very slow when Updating rows

2003-07-08 Thread Krueger, Philipp
hi there! sorry for bothering but i can't help myself anymore. i've written a small hardware-database for my company with a webinterfaced based upon php. now: everything works just fine - selects, inserts - everything works except for the damn updates! ### CODE ### $stmt = OCIParse($con

[PHP-DB] Re: OCIExecute very slow when Updating rows

2003-07-08 Thread Philippe Saladin
"Philipp Krueger" <[EMAIL PROTECTED]> a écrit dans le message news: [EMAIL PROTECTED] ... > but it still wouldn't work - when i comment OCIExecute out the script works > again - which is out of question of course since i need the damn script to > execute. > when i take the query and paste it in s

RE: [PHP-DB] OCIExecute very slow when Updating rows

2003-07-08 Thread "RENAULT, François"
i think it's a usual transactionnal problem i dont know what is your SQL update , but mostly the problem is there -Message d'origine- De : Krueger, Philipp [mailto:[EMAIL PROTECTED] Envoyé : mardi 8 juillet 2003 09:13 À : '[EMAIL PROTECTED]' Objet : [PHP-DB] OCIExecute very slow when Upd

[PHP-DB] :: Vieatatissimo minori 18 anni ::

2003-07-08 Thread jvksexy-pornstar
http://allpornstar.coolhardcoresite.com ...meglio di Miss Universo http://allpornstar.coolhardcoresite.com ...le ragazze più belle e SEXY del mondo pronte a tutto, pur di essere PORNOSTAR per non rivevere altri messaggi manda una mail senza testo a: [EMAIL PROTECTED] -- PHP Database Mai

[PHP-DB] HEAP table

2003-07-08 Thread Terry Riley
I have a query that I would have liked to cache, but as it uses UNIX_TIMESTAMP and has a user variable in it, where cacheing won't work, I looked around for another way to do it (it is used to create a smallish < 50 records table on each web page, so any speed increase is worthwhile). I decided

Re: [PHP-DB] Re: PHP crashing with using Oracle (SOLVED... well, sorta)

2003-07-08 Thread Thies C. Arntzen
On Mon, Jul 07, 2003 at 03:58:45PM -0400, Reuben D. Budiardja wrote: > Apparently there is a bug or something with OCI8 extention for PHP-4.3.2. > > Using the same configuration and everything, I compiled PHP-4.3.1, and 4.2.3 > and both worked. > > I send e-mail to PHP-DEV wondering if this is

[PHP-DB] Problems using Postgres

2003-07-08 Thread Jadiel Flores
Hi all, I really need your help asap, I have to change a website from mysql to postgres but this site is in spanish and Postgres is returning the error: PostgreSQL said: ERROR: Unicode >= 0x1 is not supoorted This is everytime I try to insert the characters ñ, á, é, etc. Do I need a special

RE: [PHP-DB] HEAP table

2003-07-08 Thread Gary . Every
Create a create_date table with one record, one or two fields, and put the last refreshed time/date in it. If that's expired, refresh Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:[EMAIL PROTECTED] http://accessingram.com > -Original Message-

Re: [PHP-DB] Problems using Postgres

2003-07-08 Thread Pascal Polleunus
Jadiel Flores wrote: Hi all, I really need your help asap, I have to change a website from mysql to postgres but this site is in spanish and Postgres is returning the error: PostgreSQL said: ERROR: Unicode >= 0x1 is not supoorted This is everytime I try to insert the characters ñ, á, é, etc

Re: [PHP-DB] Problems using Postgres - Solved

2003-07-08 Thread Jadiel Flores
Well, after a couple hours of reading the postgres website I found that I should create my database with the "encoding" option, it seems it worked. Thanks all. At 06:26 PM 7/8/2003 +0200, you wrote: Jadiel Flores wrote: Hi all, I really need your help asap, I have to change a website from mysql

[PHP-DB] formating results in seperate tables?

2003-07-08 Thread Aaron Wolski
Hi All, Having some issues with the code below: 0) { for ($i=0;$threadResults = db_fetch($threadQuery);$i++) { ?>

RE: [PHP-DB] HEAP table

2003-07-08 Thread Daevid Vincent
Or instead of creating a table and tying up one more mysql thread, just save the timestamp in a file. This could be as simple as that, you could use XML, you could use INI parser, you could use any number of things. Also, if the HEAP is created per "session", then just store that timestamp in a ses

[PHP-DB] Delete constraint

2003-07-08 Thread Norma Ramirez - TECNOSOFT
Hi all, coul I delete a constraint made over a postgresql table? (In the parent table). The child doesn`t have records. By the way, does any one know a good postgresql administrator like mysqladmin?? Thank´s Norma Ramirez

[PHP-DB] Weird Segfaults with Oracle, PHP, Apache2

2003-07-08 Thread Harris, Jeff
We're getting segfaults (11) when we try and execute a simple piece of Oracle PHP code. This is a new installation and compilation of Apache2 and we're just trying to see what is wrong. This particular code works on all of our Apache 1.3 installations. Versions: Redhat 8.0, PHP version 4.3.2, Apa

Re: [PHP-DB] Delete constraint

2003-07-08 Thread Pascal Polleunus
Norma Ramirez - TECNOSOFT wrote: Hi all, coul I delete a constraint made over a postgresql table? (In the parent table). The child doesn`t have records. I'm not sure to have correctly understood what you mean :-/ Anyway, to delete a constraint you need to use an ALTER TABLE command. ALTER TABLE [