many thanks - (I actually have three tables to amend two of which have
more than 2 fields).
I ended up doing this:
added three yes/no fields - one for update, one for insert, and one to say
whether or not to show the entry
set all entries to No before an update/insert
then if an update set the
Seamus,
Option #1: Simply delete everything in the database and then add everything in
the new group list. No need for updates. You can get away with this because
the new group list contains all of the fields (i.e. 2) in the database table,
if I read you right.
Option #2: Remove items in-th
many thanks
With your help I have managed to get a bulk update/insert going
However I cannot work out how to account for items originally on database
but not on new group list
ie groups that need to be deleted from original database after update
process (is that understandable?)
Any help grat
Basically because I'm way out of my depth here and have virtually no idea
of what I'm doing
Can you possibly show me a bit more of what you are doing so I can learn a
bit more???
Many thanks
Seamus
At 10:23 pm 5/06/01 , you wrote:
>Seamus,
>
>I'm working on the same issue today. Out of curious
I wrote:
>
> #CityCode# / #City#
>
I just noticed I left that loop in from an earlier version of the page that
worked a different way. Obviously you don't want to use cfloop when a
regular cfoutput will do. Sorry.
Marc
~~
Structure your Cold
Tim, thanks again for your assistance. I'd be interested to see whether you
think the code below is a good way to handle this issue.
Seamus, here's some code I wrote this morning that deals with the same
issue. It had not occurred to me to use CFFILE until I saw your code, so my
approach was to c
sage -
> From: "Tim Painter" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, June 05, 2001 8:21 AM
> Subject: Re: list and looping problems
>
>
> > You can also use the pipe as the delimiter. This code uses
AIL PROTECTED]>
Sent: Tuesday, June 05, 2001 8:21 AM
Subject: Re: list and looping problems
> You can also use the pipe as the delimiter. This code uses that and steps
> over every other list element to get the group code and
om: "Seamus Campbell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 05, 2001 7:41 AM
Subject: list and looping problems
> Hi - I have a text file in the below format:
>
~~
Structur
pText,idx,"|")#
Group Desc = #ListGetAt(groupText,grpDescIdx,"|")#
HTH,
Tim P.
- Original Message -
From: "Seamus Campbell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 05, 2001 7:41 AM
Subject: lis
Hi - I have a text file in the below format:
999|No Group Assigned |
AC |Activity|
BF |Brain Food |
BT |Books On Tape |
etc |
I want to insert/update this into a database table wit
11 matches
Mail list logo