OK this was also answered. Thanks to everyone especially back channel folks.
Especially Tim Kelly who reminded me to try an old favorite <@Filter> Once I
refreshed my feeble memory it was a breeze and I was able to add all kinds
of cool options to the results of the Course Registration search.
By not even displaying a course they were already signed up for I don't have
to worry about anything on the insert end which I bet is faster. In other
words I would guess its faster to parse when displaying the rows then it
would be to check for each course registration to see if the value is in the
current course list.
This will be a big help in my next project because it is another course
registration system.
Got to love that this editor, list and the ability to reuse stuff.
If anyone wants to see the code back channel me and I'll send it along.
Dan
on 5/23/02 11:05 AM, Dan Stein at [EMAIL PROTECTED] wrote:
> First thanks to everyone who has helped with my questions. I am learning a
> lot from this project and much of it is from the kind help of people on the
> list.
>
> I know that is what the list is for, but I just wanted to say thanks.
>
> So on to the next thing.
>
> I need to make sure people do not sign up twice for the same course. I don't
> want to even bother them with a message if they do I just want the who
> insert step to be skipped and a result to show that says You were already
> registered for this course. Please check you current course registration
> list before you select a course. Or I might not even bother with that and
> just use the same message as it the signed up the 1st time.
>
> So I do a search anyway when they come into registration that displays their
> current course list. I also assign this result set to @@local$currentList
> and the count of the rows to @@local$num_currentList
>
> When they select a course from the course list ( a result of a search action
> on the 1st form) and then go to detail and then submit that I do an insert
> into Staff_Records table of the course they selected and A Cross_Link ID
> which allows for inserts of courses that run multiple days.
>
> What I need to do is before that insert check to see if the course_ID is
> already in the @@local$currentList and this is where I am a little lost.
> Looping through that array looking for a match and then not doing the insert
> if their is one.
>
> And is that they best way to do it.
>
>
>
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
215-799-0192
610-256-2843
Fax 413-410-9682
FMP,Tango, EDI,SQL 7
[EMAIL PROTECTED]
www.dss-db.com
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
