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]
