Two tables, one with users in, the other with user paths. One user can have
many paths.
tblUsers
UserID Username
1 Adrian
2 Bob
3 Sue
tblUserPaths
UserID Path
1 c:\
1 c:\qwerty
1 c:\qwerty\berty
2 d:\a\path\to\nowhere
3 d:\look\mum\I\got\me\a\path
UserID in both tables would be integers, the path would be varchar.
To get all the paths for me...
SELECT up.Path
FROM tblUserPaths up
INNER JOIN tblUsers u ON up.UserID = u.UserID
WHERE u.Username = 'Adrian'
How's that?
Ade :O)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 07 October 2004 12:19
To: CF-Newbie
Subject: RE: CF and SQL
SOmething I'm doing wrong. I created a new database
with the tables "users" and "paths". I'm not sure what
to enter in for the "column name" or "data type" etc.
for each table. I knew it had to be a relational
database but I've never really created one. The other
tdatabases were done by someone else.
On Thu, 7 Oct 2004 10:21:27 +0800, James Holmes wrote:
>
> Ideally, yes, create a relational setup. A "users"
> table linked to a "paths"
> table would do.
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 7 October 2004 2:34
> To: CF-Newbie
> Subject: CF and SQL
>
> I'm inserting the filename and directory path into my
> sql database when a
> link is clicked based on the user which I get from
> login. The update being
> done just appends everything into one field in the
> database.
>
> How can I get each file and directory inserted into
> individual fields and be
> able to extract that information basxed on the user
> account?
>
> I'm not that familar with sql. Do I have to create a
> relational database?
>
>
> Now
> ---
>
> field1 field2
>
> bob c:\temp,c:\windows,c:\windows32
>
>
> Want
> ----
>
> field1 field2
> bob c:\temp
> bob c:\windows
> bob c:\windows32
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
