Peter
This might not be exactly the kind of answer you are looking for(or it
might not even be what you are really asking), but
you can do Transactions programmatically in Cold Fusion. I
doubt Ultradev can do that, so you would probably have to code it
yourself.
there is a good example in t
Hi
I am looking for help with a problem I haven't figured out how to do.
Below is a
query which gives me a count of the number of applicants registered for
courses. With that I can get when the course is full, and how many are on
the waiting list.. Now what I would REALLY like is all this info,
courses.coursesid)
> WHERE applicant.applicantid = 1
>
> This gives you all courses an reservationid>0 if applicant has signed,
> NULL if hasn't signed.
>
> On Thu, 2002-04-25 at 22:47, tgharris wrote:
> > Hi --
> >
> > I have been trying to solve t
Hi --
I have been trying to solve this problem with a left join, and wonder what
I am missing:
I have three tables:
- applicant (applicantid firstname lastname etc)
- courses(coursesid coursetitle etc)
- reservation (reservationid, applicantid,coursesid etc)
What I want to do is get a list of t