Kind of what I was thinking of. How can I generate a unique identifier?
-Nate
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 18, 2004 2:18 PM
To: [EMAIL PROTECTED]
Subject: Re: Temporary table issues. Do I need persistent connections
with
Even with persistent connections, you can't use a temporary table on
a later HTTP connection (Web request), because you don't know that
your new HTTP connection will get the same MySQL connection that you
used before.
It should work to use a temporary table in a series of queries to get
data t
I have a php page which displays quite a bit of dynamically calculated
data which I need to be sortable using different SQL statements.
Currently to display this data, a user browses to the page, the page
checks for a cookie, if the cookie doesn't exist it includes some php to
generate a temporary
"Phil Dowson" <[EMAIL PROTECTED]> wrote:
> Very good question, I believe I do since it does work 90% of the time. Only
> occasionally it doesnt work, and thats why I need help
>
In wich cases it doesn't work? We need repeatable test cases.
>
>
> - Original Message ---
--
For technical s
gt;
Sent: Saturday, June 28, 2003 4:50 pm
Subject: Re: Temporary Table Issues
> At 16:47 -0500 6/28/03, Phil Dowson wrote:
> >Hi,
> >
> >I am experiencing a problem creating temporary tables within a MySQL
> >database. When I run the following query:
> >
>
At 16:47 -0500 6/28/03, Phil Dowson wrote:
Hi,
I am experiencing a problem creating temporary tables within a MySQL
database. When I run the following query:
CREATE TEMPORARY TABLE IF NOT EXISTS rmb AS SELECT * FROM rmmt GROUP BY
rmmtid;
drop table rmb
I get the error
[server] ERROR 1044: Access
Hi,
I am experiencing a problem creating temporary tables within a MySQL
database. When I run the following query:
CREATE TEMPORARY TABLE IF NOT EXISTS rmb AS SELECT * FROM rmmt GROUP BY
rmmtid;
drop table rmb
I get the error
[server] ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to d