> > <cfquery name="newStudentInsert" datasource="abc">
> > ....
> > <cfquery name="dupeCheck" datasource="abc">
>
> Wait a second...
>
> You have got a cfquery, nested within another cfquery. That is what is
> causing the problem.
>
>
Thanks, Leigh. I knew I needed a second set of eyes. I was under the impression
that I could do that for whatever reason (I don't know what I was thinking).
So know I have the loop wrapping all of the individual queries, and on each
success (whether a new record or on update) I append to a list that shows
detailed results of the new and updated students. It all seems to work now.
You mentioned that the method I used to get the last Id wasn't the best - how
would you suggest doing it?
Thanks again,
-Tim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342083
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
