I'm writing a web-application that allows users to store their bookmarks.
Each user has a tree of folders (and bookmarks belong to these folders).
The only thing I want to do with tree elements at
the same level is display them, and let the
user only go up and down in the tree by one level. No
Lieven,
If a folder belongs to an account, why not use the account PK as a FK in
folders?
See http://www.intelligententerprise.com/001020/celko1_1.jhtml for ideas
about SQL representation of trees.
Peter Brawley
http://www.artfulsoftware.com
-
Lieven De Keyzer wrote:
I'm writing a
Peter,
From: Peter Brawley [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Lieven De Keyzer [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Multi-user bookmark system
Date: Fri, 06 May 2005 10:09:12 -0500
Lieven,
If a folder belongs to an account, why not use the account PK as a FK
From: Peter Brawley [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Lieven De Keyzer [EMAIL PROTECTED]
Subject: Re: Multi-user bookmark system
Date: Fri, 06 May 2005 11:07:48 -0500
Lieven,
Here it is.
Removing the FK looks to me like an incorrect fix to the transitive
dependency.
But the FK
want to move this into the online-bookmarks 'bookmark' table which
has the format:
+-+---+--+-+-++
| Field | Type | Null | Key | Default | Extra
| |
+--+--+--+-+-+
---+
I want to move this into the online-bookmarks 'bookmark' table which
has the format:
+-+---+--+-+-+
+
| Field | Type | Null
Sorry, my mistake in not explaining in details
I have problem on 'Multiple-step operation generated errors. Check
each status value'. when i use Visual Basic ADODC OCX to addnew. This is
the sample of my source code. The problem crop up when the bookmark value 1.
againxxx1:
Form1
I am using VB6 with MYSQL,
Is MYSQL support Bookmarking ?
How can I implement that on the MYSQL ?
Regards
SB Lim
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
, May 17, 2002 5:42 AM
Subject: BookMark
I am using VB6 with MYSQL,
Is MYSQL support Bookmarking ?
How can I implement that on the MYSQL ?
Regards
SB Lim
-
Before posting, please check:
http://www.mysql.com/manual.php