On Thu, 7 Oct 2004 12:44:28 +0100, "Adrian Lynch" wrote:
>
> You don't really need them to be separate DBs. Here's
> the basic premise...
>
> 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]
