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 session
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 bro
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$","s
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 [mailto:[EMAIL
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
c:\inetpub\wwwroot\te
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
un
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 [mailto
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 re
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
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 l
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 e
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
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 192.168.10.
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
c:\inetpu
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
Hi to all,
I changed Linux from version 7.2 to 7.3 and now when I try to load data
using LOAD DATA LOCAL INFILE I got the following error:
The used command is not allowed with this MySQL version. I
enable --local-infile=1 But I'm still getting the same error.
Any help, is greatly appreciate it
T
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.
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 statemen
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: 404.728
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 SQL
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
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 t
Suppose you are using PHP.
A link like this:
http://yourdomain.com/yourpage.php?var1=value1&var2=value2&var3=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"
Also, as far as limitations go, the following are considerations;
1. You can't pass an array using the querystring
2. Multiline variables (ie. 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 mentions, it is o
> 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 al
Here is my script:
" .
mysql_error());
$result1 = mysql_query($query1) or die("Query failed: $query1" .
mysql_error());
$num_results = mysql_num_rows($result);
?>
'.$row['referer'].''.$row['count(referer)'].'';
}
?>
How can I echo count(referer) ?
I currently get this error
Warning: Und
26 matches
Mail list logo
