s.postgresql.org/pgsql-general/2000-06/msg00449.php
- Original Message -
From: "Haggerty, Mike" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 4:04 PM
Subject: RE: MySQL Heirarchies (fwd)
> Yeah, ideally the solution
table to
itself for purposes of sorting heirarchical information.
M
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 12:55 PM
To: CF-Talk
Subject: RE: MySQL Heirarchies (fwd)
It needs to go an arbitrary number of levels, righ
7 |
| 8 | 9 |
| 9 | 10 |
++---+
8 rows in set (0.00 sec)
- Original Message -
> From: Haggerty, Mike
> To: CF-Talk
> Sent: Monday, October 20, 2003 2:58 PM
> Subject: RE: MySQL Heirarchies
>
>
> Well, the best solution at that poi
On Monday 20 Oct 2003 19:25 pm, Barney Boisvert wrote:
> I don't think you'll be able to do it, because you can't use stored
> procedures with MySQL.
You can in the current dev., and it will be in the v5 release.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [
Charlie Griefer wrote:
>The NULL attribute (which, as we've seen, is 'YES' or 'NO') simply
>indicates whether to insert a NULL value.
DOH!
Never occurred to me to use the NULL parameter like this. Incredibly useful.
--
---
Matt Robertson, [EMAIL P
Haggerty, Mike wrote:
>
> The real problem is the lack of recursion in MySQL, and this issue is
> independent of stored procedures. It would be nice if it was possible to
> write a query, loop around it, and store intermediate results in a
> temporary table within the database.
>
> For the rec
Well, the best solution at that point does not involve a database, but I
appreciate your thoughts.
M
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 2:41 PM
To: CF-Talk
Subject: RE: MySQL Heirarchies
MySQL 5.0 (in alpha) has
Mike [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 11:34 AM
To: CF-Talk
Subject: RE: MySQL Heirarchies
Barney -
I suspect you are right, and that the real solution is to do the
processing on the Web server side.
The real problem is the lack of recursion in MySQL, and this iss
PM
To: CF-Talk
Subject: RE: MySQL Heirarchies
I don't think you'll be able to do it, because you can't use
stored
procedures with MySQL. You can use a temp table, if you want,
though. Just
run a CREATE TEMPORARY TABLE statement. However, I suspect that
pulling the
raw re
I don't think you'll be able to do it, because you can't use stored
procedures with MySQL. You can use a temp table, if you want, though. Just
run a CREATE TEMPORARY TABLE statement. However, I suspect that pulling the
raw recordset back to CF and processing it there will be faster, because
you'
10 matches
Mail list logo