[PHP-DB] OCIPLogon , maximum number of sessions apache/php - Oracle

Hi all, Does anyone know how many sessions can be opened by apache/php to Oracle using OCIPlogon, or what parameter setting controls this? TIA Steve -- - Minds are like parachutes, they work best when open Support free speech; visit

Re: [PHP-DB] OCIPLogon , maximum number of sessions apache/php- Oracle

Hi Michael, So what you are saying is that apache/php will keep opening sessions until oracle runs out of processes or cursors or memory or hits session_per_user maximum ?? I was thinking of experimenting with the profile parameter IDLE_TIME Profile Parameter to make oracle close open

[PHP-DB] Re: Session data not being deleted on browser close.

Don't cross post such question... All you need to understand is how cookie is managed unless you are passing session id via URL. Read RFC2965 and RFC2964. You probably want to read netscape cookie spec also. -- Yasuo Ohgaki Youngie wrote: Why would my session data not be deleted after my

Re: [PHP-DB] OCIPLogon , maximum number of sessions apache/php - Oracle

Hi, first we when we started up with oracle we had problems with these params: processes, open_cursors, max_enabled_roles After a week or so oracle was not able to allocate shared memory, something like this: ORA-04031: unable to allocate 4200 bytes of shared memory (shared pool,TRIGGER$,sga

RE: [PHP-DB] Form select field problem

Beau Cheers for that. Option one worked as a way of referring to the field. I made a couple of other 'take-down and rebuilds' but it is now working one hundred percent, and wouldn't without your input. Thanks a whole tonne! :) Keiran -Original Message- From: Beau Lebens

[PHP-DB] MSSQL_connect() won't work

Hello all! I am desperately trying to connect to a Win2000 SQL-Server, but I always get the error message: Warning: MS SQL message: Login failed for user 'gn'. (severity 14) in c:\inetpub\wwwroot\test.php on line 11 Warning: MS SQL: Unable to connect to server: SERVER1 in

RE: [PHP-DB] Build-up of MySQL Sessions

Check out this link for an explanation of the mysql_pconnect funtion: http://www.php.net/manual/en/function.mysql-pconnect.php It explains what a persistent connection is and how it thinks. Unless you have a legitimate need for a persistent connection, try using mysql_connect(). It stays open

RE: [PHP-DB] MSSQL_connect() won't work

Does the user 'gn' exist? Are you using the correct password? Does that user have permissions on the database? Hint: Login failed for user 'gn' suggests that there is something wrong with that account... Regards Joakim Andersson -Original Message- From: Gabor Niederlaender

RE: [PHP-DB] MSSQL_connect() won't work

Hi! Does the user 'gn' exist? Are you using the correct password? Does that user have permissions on the database? Hint: Login failed for user 'gn' suggests that there is something wrong with that account... That would be fine, but it is not the case. It just won't work! I have read

[PHP-DB] Bug in SQL can you help?

Here is my SQL(used in a PHP script so this isn't ot) SELECT extract(year FROM time), extract(month FROM time), count(*) as monthly_views, time FROM tececo_stats group by extract(year FROM time), extract(month FROM time) order by monthly_views desc limit 1 the problem

[PHP-DB] Getting Percentage of coloumn value

Could some one give me an idea as to what I SQL query could use to get the percentages of each differant colomn value. ie if this was my table: +---+---+ | name | id | +---+---+ | foobar | 1 | | foobar | 2 | | foobar | 3 | | barfoo | 4 | +---+---+ I would get this result(Then

[PHP-DB] Executing PHP script through image

I am making a stats program. When the nessicary include file is included it does a reverse-DNS lookup to find the remote host's DNS name. The problem with this is that is seems slow(at least on my test server with a DSL connection). I thought the best way to speed things up would be putting the

[PHP-DB] Re: Executing PHP script through image

Sorry wrong PHP list :} Jj Harrison [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am making a stats program. When the nessicary include file is included it does a reverse-DNS lookup to find the remote host's DNS name. The problem with this is that is seems

[PHP-DB] Saving to local computer

Hello all, Im working on a project in witch i have to save to the users computer from where it views the php site on the server. Better explained in this graph: Im connection from 192.168.10.11 to 192.168.10.1 and the project is on 192.168.10.1. And from the project i need to save to

[PHP-DB] ntext data

Hi! As I wanted to retrieve a field of the data type ntext from the db, I got this error message: Warning: MS SQL message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16) in

[PHP-DB] how do i establish odbc connection?

Hi all! I realized, that it is impossible to retrieve ntext from an MSSQL DB with php normally. (Is this correct?) But I think it should be possible to make it through ODBC. Can someone explain me how this goes? (I think I have set up one ODBC Data Source, but I am not sure) But I cannot even

[PHP-DB] Delete from multiple tables with php

Hi, What is the best way to simulate the following delete statement with php to MySQL 3.23..? $sql = DELETE ordlines.*, ordmaster.* FROM ordlines, ordmaster; $sql.= WHERE ordlines.ORDER_NO ='.$order.'; From what I've read MySQL doesn't support deletes from multiple tables. TIA,

Re: [PHP-DB] Delete from multiple tables with php

I think this changed this in the more recent version(s) of MySQL. Check the MySQL docs which match your current version. Proceed from there, it's only a query. Miles Thompson At 03:11 PM 7/9/2002 -0400, Steve Bradwell wrote: Hi, What is the best way to simulate the following delete statement

[PHP-DB] SQL mailing list

Do any of you know of any good, general SQL discussion mailing lists? Preferably DB-independent. I'd like to find a place to ask SQL questions and get a human response... TIA, -- Casey Allen Shobe / Network Security Analyst PHP Developer SecureWorks, Inc. / 404.327.6339 x169 / Fax:

[PHP-DB] Hostname

Is there a SQL hostname function that'll return the name of the host a db is running on? MySQL has the a SYSDATE() function, does anyone know of a HOSTNAME() function in SQL and/or MySQL? I know that I can find it either from the OS or in PHP, however the need right now is to have it in the

[PHP-DB] Re: SQL mailing list

Hello, On 07/09/2002 05:22 PM, Casey Allen Shobe wrote: Do any of you know of any good, general SQL discussion mailing lists? Preferably DB-independent. I'd like to find a place to ask SQL questions and get a human response... This is a recorded message from a machine just to let you

[PHP-DB] A Simple Question

I recently discovered that you can pass variables through hyperlinks. (I didn't know this could be done) This will be very helpful for the project I'm working on but I cannot find any information on this subject. Does anybody know where I can find information on the syntax and limitations of

Re: [PHP-DB] A Simple Question

Suppose you are using PHP. A link like this: http://yourdomain.com/yourpage.php?var1=value1var2=value2var3=value3 will do the trick. And in the page that receives this link (yourpage.php that is), use $_GET[] to get the value: $var1 = $_GET[var1]; $var2 = $_GET[var2]; $var3 = $_GET[var3];

RE: [PHP-DB] A Simple Question

Also, as far as limitations go, the following are considerations; 1. You can't pass an array using the querystring 2. Multiline variables (ie. textarea contents) are bad 3. There is a limit of 255 or something characters to a URI (someone?) 4. Be careful with the $_GET[] array that Tony

Re: [PHP-DB] A Simple Question

4. Be careful with the $_GET[] array that Tony mentions, it is only available on more recent versions of PHP, before that it was $HTTP_GET_VARS and a lot of people had been using just plain $var1 or whatever, assuming that register_globals would always be ON in the php.ini file (which also