the FilesKeep is a list of items in the DB I want to keep - also in a table now
I need to flag each FilesAll if it is NOT in FilesKeep so that I can delete
the FilesAll and FilesKeep names will be the same (text - ex: MO.40334)
Does this make sense ?
TIA,
Donna
----- Original Message -----
From: I-Lin Kuo
To: CF-Talk
Sent: Tuesday, August 03, 2004 10:45 AM
Subject: Re: CF/SQL Help Needed
Your database structure isn't very clear to me.
How do you know one file is in a table? Same ID, or is
its filename in a comma-delimited list field list in
filesall?
If fileskeep and filesall are comma-delimited lists,
then there isn't an easy solution
--- Donna French <[EMAIL PROTECTED]> wrote:
> I have compiled 2 lists of files - one is a list of
> all files, the second is a list of files I want to
> keep. What I would like to accomplish is flag the
> files in the first list that are NOT in the second
> list so they can be deleted from the server.
>
> I've setup 2 tables:
>
> Lanesid (table 1)
> ID (auto)
> FilesKeep (text - files to keep)
>
> Lanesid2 (table 2)
> ID (auto)
> FilesAll (text - all files)
> Flag (yes/no - if the file is NOT in table 1 flag to
> be deleted)
>
> I know I need to loop thru and set the flag but I
> can't seem to wrap my brain around it this morning.
>
> TIA,
> Donna
>
=====
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer
_______________________________
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now.
http://messenger.yahoo.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
